Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DSN-Less Connect to Access
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
DSN-Less Connect to Access
Miscellaneous
Thread ID:
00222203
Message ID:
00222203
Views:
61
I'm trying to create a DSN-Less connection from VFP6 to Access tables.

Here's what I have so far, but my connect string is clearly wrong:

ConnectString ="Driver=Microsoft Access Driver;Backgroundfetch=Yes;Collate=Machine;Exclusive=No;SourceType=MDB;SourceFile=F:\projects\accountg\data\printing\infortext.mdb"

declare integer SQLConfigDataSource in odbccp32 Integer, Integer, String, String

lnSuccess=SQLConfigDataSource(0,1,"Microsoft Access Driver",ConnectString)

What have I done wrong? Also, how will I refer to the 'table' via SQL?

TIA
Kogo Michael Hogan

"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?

Ideate Web Site
Next
Reply
Map
View

Click here to load this message in the networking platform