I have visual studio 2008 professional with the inbuilt crystal reports version 10 I think. I create everything from my laptop and IIS runs from my laptop as well.
I have created the most basic report to try and figure out a problem I have, anyways the report contains one database field that is it .... which I connect to by ODBC. I then create a web form add the crystal report viewer to the report and the crystal report source run the web page and it loads the data from the field as I would expect to the crystal report viewer !!
I have several ODBC connections setup on my machine one using integrated security the other using SQL authentication both are system DSNs. Now when I publish my application and access it from IIS and not the localhost I can access everything from my application ok except when I go to form that has the crystal reports I get this error (ODBC used here is the 'sa' account)
Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error in File
If I use the other ODBC that uses Windows authentication I get this error message
Logon failed. Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested by the login. T
View Complete Post