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