Database Error, Vendor Code 17

Question

I have a problem with creating an report in my Webservice with ASP. Lokally everything works fine, connecting to SqlServers or MySQL Servers is no problem at all.

But now !'m trying to connect to a SqlServer 2005 and i get an error, somthing about a database vendor code 17 (it's a german version, so i won't directly post the whole error message).

I use the CR Version 12.0.0.683 and Visual Studio 2005.

Here is a little Code Snippet, to show you the way how the connection params are submitted

ReportDocument repDoc = new ReportDocument(); repDoc.Load(fileName); repDoc.DataSourceConnections[x].SetConnection(server, database, user, password); // now there are some params set and the report will be created.

Does anybody know this bug and how i can get rid of him?

Answer 1

Error 17 in SQL Server is:

"Error: SQL Server does not exist or access denied. (Error code 17)."

So I'd start by checking the usual stuff: is the SQL Server running? Can you connect to it outside of your CR report?

See also: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3792 for a similar problem.