This time with formatting.
>>I have a VFP application that connects to an ACCESS97 database via ODBC.
>>A client wishes to use this same VFP application to connect to 30 different ACCESS97 databases via ODBC on 12 different machines.
>>
>>This would mean configuring ODBC Connections 12*30 times.
>>Is there a way to automatically configure an ODBC connection without performing the task manually in Windows using the control panel and the ODBC Data Source Administrator?
>>
>>Will some kind of WSH program work?
>>
>>
>>Thanks In Advance.
>
>Why not use a DSN-less connection to access the Access MDB. Here is an example posted by JVP some time ago:
lconnstr = 'DBQ=C:\Program Files\Microsoft Visual Studio\VB98\NWIND.MDB;'+;
'DefaultDir=C:\Program Files\Microsoft Visual Studio\VB98;'+;
'Driver={Microsoft Access Driver (*.mdb)};DriverId=281;'+;
'FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;'
lnconn = sqlstringconnect(lcconnstr)
>This way you can keep the conenction information in a table (or whereever) and add to it as needed.
>
>HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao