Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
connecting to sql database from excel using file dsn
in the past I have set up a machine dsn using Access then used the following
connection statements in excel vba to access the data. Set wrkODBC = CreateWorkspace("", "admin", "", dbUseODBC) Set Connection1 = wrkODBC.OpenConnection("Connection1", dbDriverNoPrompt, , "ODBC;Uid=username;Pwd=password;DSN=dsnname") it always worked great. Now I want to use a file dsn so any user can use the excel file on a server that everyone has access to. I set up the file dsn on the server at X:\foldername\dsnfilename.dsn . I'm wondering how I have to alter my code to use this file dsn.... thanks in advance.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
connecting database curopting excel | Excel Programming | |||
Connecting to a database | Excel Programming | |||
Connecting To a Excel Database | Excel Programming | |||
Connecting to External Database | Excel Programming | |||
Excel Connecting to SQL Server Database - Need your Help | Excel Programming |