ODBC Connection - SQL Server

[Mythran]

The entire application I am writing uses the ODBCConnection object. Now I need
to apply a way for the user to enter the SQL Server location, authentication
type, user id and password if SQL Server authentication is required, and then
show the user the list of databases to connect to.

My problem is, I do not want to create a DSN entry for this connection, what I
would like to do is just use the ODBCConnection object still but perhaps use a
file dsn (created programmatically, then removed after the connection gets
closed).

Also, I have a SQL Server connection object in a library, I need to connect with
only the information the SQL Server object provides using the ODBCConnection
object.

Any and all help appreciated, thanks.

Mythran

[Adrian Cole]

ODBC supports "DSN-less" connections, using "Driver=" in the connection
string.

"Mythran" <ki********@hotmail.com> wrote in message
news:uU**************@TK2MSFTNGP11.phx.gbl...

The entire application I am writing uses the ODBCConnection object. Now I need to apply a way for the user to enter the SQL Server location, authentication type, user id and password if SQL Server authentication is required, and then show the user the list of databases to connect to.

My problem is, I do not want to create a DSN entry for this connection, what I would like to do is just use the ODBCConnection object still but perhaps use a file dsn (created programmatically, then removed after the connection gets
closed).

Also, I have a SQL Server connection object in a library, I need to connect with only the information the SQL Server object provides using the ODBCConnection object.

Any and all help appreciated, thanks.

Mythran