connectivity fro Crystal Reports from ODBC to SQL Server 1

[olrac2]

Hi,

I currently have established reports that run of my ODBC connections. We need them to connect to the SQL Server connection. How can I switch them over?

Thanks!

 

[RTag]

1. Open each report.
2. Click menu "Database\Set DataSource Location ..."
3. Create a new connection and update the datasource using the "Update" button on the right side.

If you have many reports you can use a tool to do this for you. Here are 2 links:

http://www.softwareforces.com/

http://r-tag.com/ReportDataSource.aspx

( I am linked to this company)

http://www.R-Tag.com

Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.

 

[olrac]

Hi RTag,

Thanks for your quick response. I tried this by choosing a new connection > ADO > SQL Native Client.
After entering the server and database and checking the "integrated security" I get an error:

ADO error: error code ox80040e73
Desc: Format of the initalization string does not conform to OLE DB specifications.

Any ideas would be most welcome!

Thanks

 

[RTag]

olrac , try to use OLEDB -> SQLServer. Do not use SQL Native Client it wil require license per each user.

http://www.R-Tag.com

Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.