> >
> >
> > TNS less Oracle Connection
> > --------------------------------------------
> >

Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));User Id=myUsername;Password=myPassword;

> > Pete "the IceMan", from the Great White North of Canada.
>
> Thanks,
> Pete
>
> I can connect with ADO.Connection
> but thru SQLSTRINGCONNECT() is still a problem.
>
> Shehzad Khan

Of course, "Provider=OraOLEDB.Oracle" , that says it's an OLE DB string and we must use the ADODB.Connection object. VFP's SQL..() functions only do ODBC connectivity.

-Anders