Access 2000 and SQL Server 2000 connection string

Hi ,

I have Access 2000 and SQL Server 2000 on my PC.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11760-access-2000-sql-server-2000-connection.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11760
syntax,

objConnSQL.ConnectionString = ??????

can anyone help me with this?

Thanks in advance,
David K



*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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;Pers ist 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.

--
Brendan Reynolds
Access MVP

"David Kennedy" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11760
news:evMv8DHlGHA.896@TK2MSFTNGP04.phx.gbl...
> Hi ,
>
> I have Access 2000 and SQL Server 2000 on my PC.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11760
> 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
>
>