Forum Discussion

amit_deshpande's avatar
amit_deshpande
Occasional Contributor
14 years ago

Error while connecting to the SQL server 2008

Hi, I am getting the connection error while connecting to the SQL server 2008. The connection string that I have configured is- connectionstring="Provider=SQLOLEDB.1;Persist Security ...
karkadil's avatar
karkadil
Valued Contributor
14 years ago

It looks like you have to specify database name you connect to:


Initial catalog=YOUR_DB_NAME;


Another guess, you have to specify port number in your IP address, e.g.


Data Source=xx.yy.zz.nn,ABCD


where ABCD is a port number.