[ODBC Manager] Data Source Name too long

ODBC connection in Oracle .

Have written a VB script which connects to an Oracle database using ODBC connection string.
When trying to connect its gives me an error

[Microsoft][ODBC Manager] Data Source Name too long.

My connection string as follows

"Driver={Microsoft ODBC for Oracle};Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=123abdc-1.amazon.com)(PORT=1441))(CONNECT_DATA=(SERVICE_NAME=TTD)));Uid=test;Pwd=test@123;"

Could anyone let me know why iam getting this error and how can i solve it.


0 answers