ODBC without DSN

  • Thread starter Thread starter David Wood
  • Start date Start date
D

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!
 
David Wood said:
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?
Click to expand...

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
 
Use ADO:

Dim cnn as new ADODB.Connection

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