Welcome to SPN

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

Sign Up Now!

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
    >
    >
     

Share This Page