> > Hello,
> > Freinds
> >
> > I want to create a TNS-Less Oracle Connection from VFP
> > i.e without creating orcale ServiceName in User Machine
> >
> > I have tried but it is not working
> >
> > ?SQLSTRINGCONNECT("Provider=MSDASQL.1;Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.10)(PORT = 1527)))(CONNECT_DATA =(SERVICE_NAME = ORADbc)));User Id=username;Password=pass;")
> >
> > Shehzad Khan
>
>
> 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