Access 2000 and SQL Server 2000 connection string

  • Thread starter Thread starter David Kennedy
  • Start date Start date
D

David Kennedy

Hi ,

I have Access 2000 and SQL Server 2000 on my PC.
I am trying to connect an Access database to SQL Server 2000(local) using
VBA code.
I am having trouble with the connection string,I dont know the correct
syntax,

objConnSQL.ConnectionString = ??????

can anyone help me with this?

Thanks in advance,
David K
 
Here's an example using Windows integrated security ...

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=Northwind;Data Source=(local)

.... and here's one using SQL Server security ...

Provider=SQLOLEDB.1;Password=YourPasswordHere;Persist Security
Info=False;User ID=YourUserID;Initial Catalog=Northwind;Data Source=(local)

There are many other variations possible, but for a typical installation on
your local PC one of these will probably work.
 
Back
Top