August 18, 2005 at 6:53 am
How do i connect to sql server having tcp/ip connection using DAO
August 19, 2005 at 2:00 am
Create and test an ODBC DSN connection using the Start | Control Panel | Administrative Tools | Data Sources (ODBC) menu selection.
In Access or wherever you are creating the DAO connection object use this DSN.
Andy
August 19, 2005 at 7:12 am
we use the following connection string in DAO & access 97
"ODBC;DRIVER=SQL SERVER;Description=SQLServer;SERVER=10.0.5.100;UID=user;PWD=user2;DATABASE=master;Network=DBMSSOCN;Address=10.0.5.100,1433;APP=BT
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy