Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP6: Connecting to Access
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00619586
Message ID:
00620111
Vues:
16
David,
When you install MDAC, the only thing filled in is the Drivers list. File DSNs are just DSN files in a specific directory (e.g. C:\Program Files\Common Files\ODBC\Data Sources). You can find the path to this directory stored in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN. The path is stored under the value DefaultDSNDir.

Once you have that directory, you can create a file using StrToFile() and drop it in that directory. ODBC will take care of the rest.

HTH.

>Right now I am confused. I thought that when I installed the mdac that the File DSN was filled in with the different drivers. I just installed my app on an NT PC that never had Access on it. I then ran mdac and rebooted and the File DSN was not filled and my program bombs trying to get to the Access table. I need a way to program adding to the File DSN or something! Any ideas?
>TIA!
>
>>>I am back trying to connect VFP to an Access database. I was creating the DNS-less connection with a view that I received from J. Chad Bourque. When I do an install on a PC that never had Access on it the connection failed. So, I decided to create a System DSN which I did but the view is giving me an error about the DriverID missing. Any ideas on how I can get this to work?
>>>TIA!
>>
>>Do you have Access ODBC driver installed on that PC? If you don't than you should eaiser include it in your setup or inctall MDAC on those PC's.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform