Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Access 2000 and SQL Server 2000 connection string

Discussion in 'Information Technology' started by David Kennedy, Jul 28, 2006.

  1. David Kennedy

    David Kennedy
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    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.

    --
    Brendan Reynolds
    Access MVP

    "David Kennedy" <dkennedy85@hotmail.com> wrote in message
    news:evMv8DHlGHA.896@TK2MSFTNGP04.phx.gbl...
    > 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
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page