Data Source name too long

I have used connection string as below in my VB macro.

ConnectionString="Data Source=(DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=servername)(PORT=portno))(CONNECTDATA=(SERVICENAME=servicename))));uid=username;pwd=password;"

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

If I use DSN instaed of Data Source, its working fine.

Can somebody please help me resolve this. Would be really helpful.

0 answers