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

Connect to OLEDB..?

Discussion in 'Information Technology' started by Kent Johnson, Nov 3, 2005.

Tags:
  1. Kent Johnson

    Kent Johnson
    Expand Collapse
    Guest

    Hi all,

    I usually link tables from a datasource via ODBC but now I have a SAS OLEDB
    datasource.
    How can I connect to a OLEDB-datasource from Access?

    /Kent J.
     
  2. Loading...

    Similar Threads Forum Date
    Do You Ever Feel Completely Disconnected? Blogs Dec 7, 2016
    Connected Blogs Oct 17, 2015
    connection! Blogs Oct 17, 2015
    Still No Connection Blogs Oct 17, 2015
    connection Blogs Oct 16, 2015

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    You can't as a linked table, but you can open an ADO recordset in VBA code,
    assuming you know the appropriate connection string to use to connect.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Kent Johnson" <08.6044303@telia.com> wrote in message
    news:uC9af.149809$dP1.507648@newsc.telia.net...
    > Hi all,
    >
    > I usually link tables from a datasource via ODBC but now I have a SAS

    OLEDB
    > datasource.
    > How can I connect to a OLEDB-datasource from Access?
    >
    > /Kent J.
    >
    >
    >
     
  4. Kent Johnson

    Kent Johnson
    Expand Collapse
    Guest

    OK!
    How can I use ADO to connect to a OLEDB datasource?

    /Kent J.

    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:eWQWTN$3FHA.3400@tk2msftngp13.phx.gbl...
    > You can't as a linked table, but you can open an ADO recordset in VBA

    code,
    > assuming you know the appropriate connection string to use to connect.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Kent Johnson" <08.6044303@telia.com> wrote in message
    > news:uC9af.149809$dP1.507648@newsc.telia.net...
    > > Hi all,
    > >
    > > I usually link tables from a datasource via ODBC but now I have a SAS

    > OLEDB
    > > datasource.
    > > How can I connect to a OLEDB-datasource from Access?
    > >
    > > /Kent J.
    > >
    > >
    > >

    >
    >
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    See, for example,
    http://msdn.microsoft.com/library/en-us/dnado/html/workshp2.asp

    Doing a Google search on ADO should also result in thousands of hits.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)



    "Kent Johnson" <08.6044303@telia.com> wrote in message
    news:esaaf.149815$dP1.507609@newsc.telia.net...
    > OK!
    > How can I use ADO to connect to a OLEDB datasource?
    >
    > /Kent J.
    >
    > "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > news:eWQWTN$3FHA.3400@tk2msftngp13.phx.gbl...
    >> You can't as a linked table, but you can open an ADO recordset in VBA

    > code,
    >> assuming you know the appropriate connection string to use to connect.
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no e-mails, please!)
    >>
    >>
    >> "Kent Johnson" <08.6044303@telia.com> wrote in message
    >> news:uC9af.149809$dP1.507648@newsc.telia.net...
    >> > Hi all,
    >> >
    >> > I usually link tables from a datasource via ODBC but now I have a SAS

    >> OLEDB
    >> > datasource.
    >> > How can I connect to a OLEDB-datasource from Access?
    >> >
    >> > /Kent J.
    >> >
    >> >
    >> >

    >>
    >>

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