Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with creating User DSN
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problems with creating User DSN
Divers
Thread ID:
00690512
Message ID:
00690512
Vues:
49
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform