Cannot load data source sybase , cannot open file c:\sybase\OLEDB\ .ids

HI Folks,

Error : Cannot load data source sybase , cannot open file c:\sybase\OLEDB\ .ids

Weird error, I got really confused by seeing this error. Finally, I got a solution for this J

 Solution

Please have a look on to the Connection string in the web.config file, if you have given the provider name differently you will have to change to  Sybase.ASEOLEDBProvider.2

<add key="ConnStringSYB" value="Provider=Sybase.ASEOLEDBProvider.2;Server Name=servername,portno if any; Initial Catalog=dbname;User Id=id;Password=password"/>

This is most important, please check the provider name it will work

Provider=Sybase.ASEOLEDBProvider.2