Last post Sep 20, 2011 04:20 PM by kmassey
Sep 16, 2011 12:54 PM|kmassey|LINK
I'm working on moving our Intranet site from vb.net 2002 to .net 2008. When running Crystal Reports from the site it works connecting to database A no problem, but when I have a report that tries to connect to database b or C I get "the table '' could not
be found. error in file c:\windows\temp\ ...}.rpt: the table could not be found."
All databases are on the same server and currently work in production. They are using either a view or stored procedure to get the data.
Sep 17, 2011 10:06 PM|necro_mancer|LINK
may i know how did you structure your connection string ? Can you please copy the details of your conn string here?
Sep 19, 2011 10:39 AM|kmassey|LINK
The report connects using the User DSN ODBC that production is currently running, this is only on reports that connect to database B or C that don't work. Everything that connects to database A works fine and uses the same connection method.
Sep 19, 2011 10:42 PM|necro_mancer|LINK
would you please show the error message here? With an error message, I and the other forum members can aid you better.
If the error message is still the same with the post you made initially, I suspect that your connection string is wrong. It seems that your application cannot find the database B or C. Please double check it again.
P.S: You may need to create a new connection string to connect to database B or C
Sep 20, 2011 04:20 PM|kmassey|LINK
The table 'vTruckingMileageLog' could not be found. Error in File
The table could not be found.
I can open this report in Dev. on the same server as IIS and verify the database and run the report. The connection code is the same as production is currently running and works fine.