ODBC without DSN

[David Wood]

is it possible to create/use a link from an Access 2000 front-end database,
to a SQL Server 7 backend database, using ODBC, without using a DSN?

Any advice appreciated!

 

[Cheryl Fischer]

It is. Here is a often-recommended link to sample connections

http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm

hth,

 

[Tony Toews]

is it possible to create/use a link from an Access 2000 front-end database,
to a SQL Server 7 backend database, using ODBC, without using a DSN?

To add to Cheryl's posting.

Using DSN-Less Connections
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafast/GetFile.aspx?file=ODBCTutor01.htm&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[loadhigh]

Use ADO:

Dim cnn as new ADODB.Connection

cnn.Provider="sqloledb"
cnn.Open "Data Source=[ServerName],Initial
Catalog=[DataBaseName]",[Userid],[Password]