Crystal Reports to connect to the MS Access and SQL database using ODBC/OLEDB DSN.
Currently reports are generated in Visual Basic 6.0 using MS Access database and Crystal Report 8.0. The reports are working fine without problem. Access to the MS Access is via directly accessing the database for designing all the Crystal Report reports. Due to the size and security limitations of Access database, my company had decided to migrate certain databases from MS Access to SQL Server 2000. The access database tables were successfully exported into sql server tables. My VB applications are also working fine with the existing codes (with minor modification to existing vb code).
Now I need to use ODBC/OLEDB connection in my reports to support both Access as well as SQL databases.
I need to change all my crystal reports to connect to the database using ODBC/OLEDB DSN.
I need a solution to change the datasource name at run-time in my VB application without any changes to my existing reports.
I need to be able to use both MS Access databases and SQL databases in my reports and applications.
Kindly help me in finding a working solution to changing the data sources at run time in my VB application.
I need a solution promptly.
Now I need to use ODBC/OLEDB connection in my reports to support both Access as well as SQL databases.
I need to change all my crystal reports to connect to the database using ODBC/OLEDB DSN.
I need a solution to change the datasource name at run-time in my VB application without any changes to my existing reports.
I need to be able to use both MS Access databases and SQL databases in my reports and applications.
Kindly help me in finding a working solution to changing the data sources at run time in my VB application.
I need a solution promptly.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That is using an ADO recordset as I suggested. I didn't have the code so thanks for supplying it.
If that works points to Fadi_Hania.
mlmcc
If that works points to Fadi_Hania.
mlmcc
ASKER
Gee thanks all...will try it out and get back to you...;-)
ASKER
Thanks all, decided to upgrade to Version 10...;-)
Glad I could help
mlmcc
mlmcc
ASKER
Yes, I'm using Crystal Report 8.0. I was hoping that there is a quicker method other than manual...&-(