connect oracle db with odbc via ipaddress I need to connect oracle db via network ip address from my one of php page.
$conn=odbc_connect('(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 128.212.160.2:prod)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))','username','*******');
this is what am getting when executed
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length, SQL state S1090 in SQLConnect in C:\xampp\htdocs\oracleconnect\odbccnt.php on line 34