Welcome to SPN

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

Sign Up Now!

Connecting to SQL server without ODBC driver saved

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

  1. Adam

    Adam
    Expand Collapse
    Guest

    Hi All,

    I have a data repository which is saved on a SQL server connected to
    our work network.

    I have setup reports in Access which report from the sql server. Only
    problem is that to run the reports you have to have the SQL server odbc
    connection installed on that machine.

    Is there a way where I can save the ODBC connection in the database so
    any machine on the network can run the reports?

    Many Thanks

    Adam
     
  2. Loading...

    Similar Threads Forum Date
    Need Help - Connecting with the Guru... Questions and Answers Mar 19, 2013
    Buddhism The Zen Brain: Connecting Meditation and Neuroscience Interfaith Dialogues Sep 19, 2011
    Sufism Sufism: Connecting Mankind Interfaith Dialogues Feb 16, 2011
    SikhRI Connecting with the Divine Light Sikh Organisations Jul 23, 2009
    Connecting The Dots In History Essays on Sikhism Mar 21, 2009

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    sure
    use dsn-less connections
    check out
    http://www.accessmvp.com/djsteele/DSNLessLinks.html
    for the "howto"

    Pieter


    "Adam" <adamevans81@gmail.com> wrote in message
    news:1153403114.491110.226090@m73g2000cwd.googlegroups.com...
    > Hi All,
    >
    > I have a data repository which is saved on a SQL server connected to
    > our work network.
    >
    > I have setup reports in Access which report from the sql server. Only
    > problem is that to run the reports you have to have the SQL server odbc
    > connection installed on that machine.
    >
    > Is there a way where I can save the ODBC connection in the database so
    > any machine on the network can run the reports?
    >
    > Many Thanks
    >
    > Adam
    >
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    sure
    use dsn-less connections
    check out
    http://www.accessmvp.com/djsteele/DSNLessLinks.html
    for the "howto"

    Pieter


    "Adam" <adamevans81@gmail.com> wrote in message
    news:1153403114.491110.226090@m73g2000cwd.googlegroups.com...
    > Hi All,
    >
    > I have a data repository which is saved on a SQL server connected to
    > our work network.
    >
    > I have setup reports in Access which report from the sql server. Only
    > problem is that to run the reports you have to have the SQL server odbc
    > connection installed on that machine.
    >
    > Is there a way where I can save the ODBC connection in the database so
    > any machine on the network can run the reports?
    >
    > Many Thanks
    >
    > Adam
    >




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4285 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page