Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with creating User DSN
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problems with creating User DSN
Miscellaneous
Thread ID:
00690512
Message ID:
00690512
Views:
48
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
Next
Reply
Map
View

Click here to load this message in the networking platform