on 10-28-2011 9:02 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Moved to JAVA SDK forum
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.