SQLDriverConnect question

[Igor Korot]

Hi, ALL,
Does SQLDriverConnect() function support SQL_DRIVER_PROMPT,
SQL_DRIVER_COMPLETE and SQL_DRIVER_COMPLETE_REQUIRED as a
last parameter?

According to http://msdn.microsoft.com/en-us/library/ms715433.aspx

"
SQL_DRIVER_PROMPT: If the connection string does not contain either the DRIVER, DSN, or FILEDSN keyword, the Driver Manager displays the Data Sources dialog box. It constructs a connection string from the data source name returned by the dialog box and any other keywords passed to it by the application. If the data source name returned by the dialog box is empty, the Driver Manager specifies the keyword-value pair DSN=Default. (This dialog box will not display a data source with the name "Default".)

SQL_DRIVER_COMPLETE or SQL_DRIVER_COMPLETE_REQUIRED: If the connection string specified by the application includes the DSN keyword, the Driver Manager copies the connection string specified by the application. Otherwise, it takes the same actions as it does when DriverCompletion is SQL_DRIVER_PROMPT.
"

Thank you.

_______________________________________________
unixODBC-dev mailing list
unixODBC-dev@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev

[Nick Gorham-2]

Igor Korot wrote:

>Hi, ALL,
>Does SQLDriverConnect() function support SQL_DRIVER_PROMPT,
>SQL_DRIVER_COMPLETE and SQL_DRIVER_COMPLETE_REQUIRED as a
>last parameter?
>
>  
>
Generally no, it will try via odbcinstQ if there is a QT based
ODBCCOnfig to be found, but as building that is optional, its best
(IMHO) to assume not, unless you have 100% control over whats installed
and how its set up.

--
Nick
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev

[Igor Korot]

OK.
But such call wouldn't fail, right? It still going to return SQL_SUCCESS?

Thank you.

-----Original Message-----

>From: Nick Gorham <nick@...>
>Sent: May 29, 2008 12:07 AM
>To: Igor Korot <ikorot@...>, Development issues and topics for unixODBC <unixodbc-dev@...>
>Subject: Re: [unixODBC-dev] SQLDriverConnect question
>
>Igor Korot wrote:
>
>>Hi, ALL,
>>Does SQLDriverConnect() function support SQL_DRIVER_PROMPT,
>>SQL_DRIVER_COMPLETE and SQL_DRIVER_COMPLETE_REQUIRED as a
>>last parameter?
>>
>>  
>>
>Generally no, it will try via odbcinstQ if there is a QT based
>ODBCCOnfig to be found, but as building that is optional, its best
>(IMHO) to assume not, unless you have 100% control over whats installed
>and how its set up.
>
>--
>Nick

_______________________________________________
unixODBC-dev mailing list
unixODBC-dev@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev

[Nick Gorham-2]

Igor Korot wrote:

>OK.
>But such call wouldn't fail, right? It still going to return SQL_SUCCESS?
>  
>

Well, it will depend on if the driver has enough information to connect
without asking the user for more.

--
Nick
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev