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

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