>actually i send this one
>
>Driver={Microsoft ODBC for Oracle};Port=1521;Server=hostip;Service_name=servicename.loc;Uid=username;Pwd=mypassword
>
>but i get the error : 1526 : connectivity error ..connectattr failed

The usual trick is to do it manually, from the ODBC entry in Control panel / administrative tools. Create a file DSN (the other two are just fancy names which mean to store the string in the registry or somewhere else), with the help of the driver itself. Find the .dsn file and open it in a text editor. Remove the first line, which is enclosed in brackets, and replace line breaks with semicolons. Use that string from VFP.