Accessing data sources without creating it in ODBC Administrator

[Bryan]

In vb, how can I get access to data sources that are in sql server without
adding it to the ODBC Data Source Administrator?

[Joel Ryan]

If you mean connecting to a data source without using a DSN, you can do it
with ADO. Here's an example:

Dim oConn as New ADODB.Connection

' For SQL Server:
sDataSource = "Driver={SQL Server};server=myserver;database=mydatabase;"

' For an MDB:
sDataSource = "Driver={Microsoft Access Driver
(*.mdb)};dbq=c:\myaccessdatabase.mdb"

oConn.Open sDataSource

-- Joel


Bryan wrote:

> In vb, how can I get access to data sources that are in sql server without
> adding it to the ODBC Data Source Administrator?

[Joel Ryan]

If you mean connecting to a data source without using a DSN, you can do it
with ADO. Here's an example:

Dim oConn as New ADODB.Connection

' For SQL Server:
sDataSource = "Driver={SQL Server};server=myserver;database=mydatabase;"

' For an MDB:
sDataSource = "Driver={Microsoft Access Driver
(*.mdb)};dbq=c:\myaccessdatabase.mdb"

oConn.Open sDataSource

-- Joel


Bryan wrote:

> In vb, how can I get access to data sources that are in sql server without
> adding it to the ODBC Data Source Administrator?