+ Reply to Thread
Results 1 to 1 of 1

set up ODBC datasource via VBA if user doesn't have it already

  1. #1
    Forum Contributor
    Join Date
    10-17-2008
    Location
    Vancouver
    MS-Off Ver
    2002 and XP
    Posts
    117

    set up ODBC datasource via VBA if user doesn't have it already

    Hello All,

    I have a query table that is refreshed from a sql server. I have the connection string figured out

    Please Login or Register  to view this content.
    but, when I try to use it on someone's computer who doesn't have a datasource setup, it prompts them to do so with the ODBC Administrator program. Is there a way I can do this programatically?

    user's connection is to a SQL database.


    Update: Okay, found out about DSN-less connections currently using
    Please Login or Register  to view this content.
    However, the "Select Datasource" window still crops up. How do I set up the connect to avoid any prompts to "select Datasource" as that is a manual, technical process

    Update: for servername, had to specify ip address as some end users were accessing remotely.
    Last edited by kuraitori; 02-09-2010 at 05:02 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1