Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DSN-Less Connect to Access
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
DSN-Less Connect to Access
Divers
Thread ID:
00222203
Message ID:
00222203
Vues:
57
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform