Skip to Content
Former Member
Mar 27, 2015 at 04:33 PM

Problem setting connection for Reports


We are using CR The app's connection to the DB is fine; the VB code can bring data back. BUT the Reports do not run. I get vendor code 17. I assume it has to do with the connection string, which looks like this:

Server=servername;Initial Catalog=Production; User id=ronald; Password=abcdef;

These credentials work jut fine. I'm not a CR guru (obviously). There are three SQL Server ODBC Datasources: SQLSVR32.DLL, SQLNCLI10 and SQLNCLI11. I'm not sure where I set these. When I try to run a report from CR itself I cannot change the Database Location; it's greyed out. The reports are not read only.

Any help or tips is greatly appreciated.