Post reply

DAO and SQL Server 2000 using TCP/IP Connection

  • August 18, 2005 at 6:53 am

    #164862

    How do i connect to sql server having tcp/ip connection using DAO

  • August 19, 2005 at 2:00 am

    #583422

    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

    #583499

    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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply