>*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
Check WHY you get error with AERROR():
TEXT TO lcConnectioString NOSHOW PRETEXT 15
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
ENDTEXT
Handle = SQLSTRINGCONNECT(lcConnectioString)
IF Handle < 0
AERROR(laError)
MessageBox(laError[1,2])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.