You do not use a DSN in SQLStringConnect. Use the following syntax:
lnHandle = sqlstringconnect('Driver=Microsoft ODBC for Oracle;ConnectString=RETURN_HMTORA;UID=HMT;PWD=HMTNET;')
SQLConnect() uses the DSN from your ODBC list.
>Thanks for your response. I am using Microsoft ODBC for Oracle MSORCL32.DLL (02.573.4202.0, also tried 02.573.3711.0). I am using remote views with shared connection as well as SPT.
>I am using DSN to establish connection, but just before replying to you I was trying to use DSNless connection with the same results. Here are the different variation of code with the same error "Error while trying to retrieve text for error ORA-00000":
>
>DSN Name: "HMTCS"
>Login: "TEST"
>Password: "TEST"
>Oracle Service: "RETURN_HMTORA"
>
>1. lnHandle = SQLCONNECT("HMTCS", "TEST", "TEST")
>
>2. lcConnectString = "DSN=HMTCS;UID=HMT;PWD=HMTNET;CONNECTSTRING=RETURN_HMTORA"
> lnHandle = SQLStringConnect(lcConnectString)
>
>3. lcConnectString = "DRIVER={Microsoft ODBC for Oracle}; " + ;
> "CONNECTSTRING=RETURN_OHMTORA; " + ;
> "UID=TEST; " + ;
> "PWD=TEST"
> lnHandle = SQLStringConnect(lcConnectString)
>
>
>Mark, I also created 3 DSNs for Testing using the same Oracle Service but different drivers :HMTCS10 using MSORCL10.DLL, HMTCS32 with MSORCL32.DLL, HMTCSORA with SQORA32.DLL. The I used Oracle ODBC Test Utility trying to stay out of VFP and connect strings syntax possible problems. No miracles: the same result - can not connect to HMTCS10 & HMTCS32, but able to connect to HMTCSORA.
>
>Again, my code worked & works with Oracle7/8, even with Oracle8i database (8.1.6) when I am using 8.0.5 client. If I install 8.1.6 client I can not connect to any database with MS drivers (MSORCL10.SLL or MSORCL32.DLL). However using Oracle 8.01.06 ODBC Driver (SQORA32.DLL) works.
Mark McCasland
Midlothian, TX USA