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.