Access 2000 connection string to SQL Server
Hi!
I'm trying to use Access 2000 as front-end and SQL Server as back-end, and have already created the ODBC.
I have a couple of questions.
1) Can anybody give me the connection string?
2) Do I need to use it in every form?
Thanks!
[281 byte] By [
Siegfried] at [2007-11-11 7:14:37]
# 1 Re: Access 2000 connection string to SQL Server
I would recommend using the OLEDB provider (first link) instead of ODBC.
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServer
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForSQLServer
I'm not sure where in your code you're establishing the connection to SQL Server but that is where you would need to use the connection string.
# 2 Re: Access 2000 connection string to SQL Server
Thanks. I did what you said, and it works.
