Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connecting To VFP Database Using VFPOLEB
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01305538
Message ID:
01305552
Vues:
13
>As Al stated already, SQLCONNECT() and SQLSTRINGCONNECT() work with ODBC drivers only.
>
>>SQLSTRINGCONNECT() prompts me for a data source. Is there a way to do this with a connection string?
>>

I tried this
CLEAR

sDatabase = "C:\Projects\mydatabase.dbc"
sConnString = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB="+sDatabase+";Exclusive=No; NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;"

iHandle = SQLCONNECT(sConnString, .T.)

IF iHandle > 0

	? "Connect"
	
	SQLDISCONNECT(iHandle)

ELSE

	? "Unable to connect"
	AERROR(aErrInfo)
	? aErrInfo[1]
	? aErrInfo[2]
	
	_cliptext = aErrInfo[2]
	
ENDIF
I got "Connectivity error: [Microsoft][ODBC Driver Manager] Data source name too long"

I got the connection string info from http://www.connectionstrings.com/?carrier=visualfoxpro
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform