Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with creating User DSN
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00690512
Message ID:
00690516
Vues:
13
Please accept my apologies....I figured out the problem. It occurred to me that I should try to add the DSN through the ODBC interface and am getting an error 31 message. Looks like I need to reinstall my data drivers, so the code is probably OK.

>I am using the following command to create a DSN to Microsoft Access Tables. This works wonderfully on all but a Windows 98SE laptop I have. The create fails and I have no explanation as to why. The version of the driver is identical between the laptop and my other test machines.
>
>Here's the code:
>
>
>lcString = "DSN=Fly_Ash Export" + chr(0) + ;
>	"DESCRIPTION=Fly Ash Export Data" + CHR(0) + ;
>	"DBQ=" + ALLTRIM(l_accessdb) + CHR(0) + ;
>	"DriverId=281" + CHR(0) + ;
>	"FIL=MS Access" + CHR(0) + ;
>	"MaxBufferSize=2048" + chr(0) + ;
>	"PageTimeout=5" + chr(0)
>
>lnSuccess = SQLConfigDataSource(0, ODBC_ADD_DSN, "Microsoft Access Driver (*.mdb)", lcString)
>
>
>
>this fails only on the one machine, but I have a similar envrionment to install this project to (and of course it's a week overdue already!) and really need the process as bullet-proof as possible.
>
>Any troubleshooting ideas would be greatly appreciated!
Steve Howie, owner
DaSH Technology
Denver, CO
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform