cancel
Showing results for 
Search instead for 
Did you mean: 

CR - Java - MSSQL EXPRESS - "UNEXEPECTED ERROR IN DATABASECONNECTOR "

Former Member
0 Kudos

Hi,

i have that app using CR 12 for java and that connects to a SQL SERVER 2005 database

i overwrite database connection settings at runtime and everything works fine

i use a propertybag and reportClientDocument.getDatabaseController().replaceConnection(oldconnInfo, connInfo, null, DBOptions._ignoreCurrentTableQualifiers ); method to do this.

But when i try to access a SQLSERVER 2005 EXPRESS database

i get a "UNEXEPECTED ERROR IN DATABASECONNECTOR " error message.

Is this version of MSSQL SERVER not supported?

Thanks for any help

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You shouldn't have a problem connecting with SQL Server Express in general. One thing to keep in mind, however, is that a typically SQL Server Express installs as a named instance where as Standard & above will install as a default instance. Because of this you may need to check connection string properties.

You may also need to make sure the instance of SQL Server Express is setup to allow remote connections. I'm not sure about this, but I'm thinking that allow remote connections is turned of by default in the Express edition.

Try creating a simple test report that connects directly to that specific instance and make sure you are able to connect that way. If you are not able to connect it is most likely as SQL Server setting that is locking you out. If you can connect, then odds are its a problem with the connection string you are trying to pass.

Also, make sure using the SQL Native client driver (ODBC or OLE DB).

HTH,

Jason

Former Member
0 Kudos

Which type of commection your CR used to connect to SQL server DB?

Former Member
0 Kudos

For any of the SQL Server 2005 editions you should be using the SQL Native Client. For any of the SQL Server 2008 or 2008 R2 products, you should be using the SQL Native Client 10.

0 Kudos

Moved to JAVA SDK forum