General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Connection handle error
*Handle=SQLCONNECT('Upsize','','',.T.)
Handle = SQLSTRINGCONNECT("DSN=dpsal;UID=Josephine;APP=Microsoft Visual FoxPro;WSID=HP6PQ8;DATABASE=RemoteAccess;Network=DBMSLPCN;Address=HP6PQ8\SQLEXPRESS,1433;
Trusted_Connection=Yes;Regional=Yes;UseProcForPrepare=0")
1st one is telling me handle error and im following the syntax
SQLCONNECT([cConnectionName | cDataSourceName [, cUserID [, cPassword ]][, lShared]])
(Connection Name/or datasource, userid,password)
2nd is telling me a data type mis match and this is my connection string copied from connection in foxpro.
Id love for some help on this im trying to connect my SQL database to my foxpro program thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only