data source too long error for connection string given.

I have used connection string as below

SERVER="(DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=servername)(PORT=portno))(CONNECT_DATA=(SERVICE_NAME=servicename))));uid=username;pwd=password;"
ConnectionString = "Data Source=" & SERVER

During excecution in QTP,
I am getting the error [Microsoft][ODBC Driver Manager] Data Source name too long.

I have used the details from tnsnames.ora file present.

Pls advice - how to resolve this.

0 answers