I´ve migrated to sqlserver from access 2000

[anilucm]

Hello

I've migrated my systems from vb6, access 2000, and crystal 8.5 to sqlserver, my visual basic systems are working ok after migrating the access to sqlserver but all of my reports can´t be executed from visual basic this is the error I get
"unable to open data base" when I try to execute then from crystal there is no problem....... help!!

[VB_Learner]

have you verified your database on the reports...you can do so..

open your crystal report....go to Database in the main menu...either u get a dialog box with the connection details, when you click on Database menu, or u may get the drop down menu, if u get the drop down menu, then select the verify menu option, it will as you to give ur database name, connection details and other options. once you finished save ur report and open that, it will work...

[umararif]

I have a easiest solution:
If your crystal report is working fine independently (as you said), add these designed report again in your project.
Right click on Project window goto Add>Crystal Report 8.5, select "From an existing Report" radio option and give the path of your report.

Problem will be hopefully solved.

Umar

[hensa22]

if you has been working with ODBC,
maybe you must change database driver from menu Database/convert database driver.

oversee menu Database/Set Location too.