> > 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
>
>
>
> The strings at www.connectionstrings look less complicated. What's the purpose ofb rthe TNS-less conndection method.
>
> ODBC
> New version
>
> Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd=myPassword;
>
> Old version
>
> Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;
>
> -Anders

Target Achieved,Thank U

ODBC
New version

Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd=myPassword;

is the right solution for =sqlstringconnect() TNS-Less Connection

Regards

Shehzad Khan