Skip to Content
0
Former Member
Mar 25, 2009 at 12:05 PM

Logon Error Null user or password not supported in THIN driver - ?????

442 Views

I am getting the following stack trace error on all my reports:

03-25 07:55:42 ERROR [TP-Processor8] (datainterface:?) - Failed to open connection (Connection: databaseType=JDBC (JNDI) serverName=jdbc:oracle:thin:@pabaix08:1521:CRCP state=closed databaseDriverName=crdb_jdbc.dll).

com.crystaldecisions.reports.queryengine.bl: Logon Error: Null user or password not supported in THIN driver

I saw a previous post about this error and it stated that you get it when a userid/password is not associated with the ConnectionInfos object, but here is my database connection code for all reports:

PropertyBag propertyBag = new PropertyBag();

propertyBag.put("Server Name", "pabaix08");

propertyBag.put("URI", "!oracle.jdbc.OracleDriver!jdbc:oracle:thin:/@pabaix08:1521:crcp");

oIconnectionInfo.setUserName("crcuser");

oIconnectionInfo.setPassword("crcuser1");

propertyBag.put("Connection String",ConnStr);

propertyBag.put("Server Type", "JDBC (JNDI)");

propertyBag.put("Database Class Name", driver);

propertyBag.put("Database DLL", "crdb_jdbc.dll");

PropertyBag bag = new PropertyBag();

bag.put(PropertyBagHelper.CONNINFO_CRQE_LOGONPROPERTIES, propertyBag);

bag.put(PropertyBagHelper.CONNINFO_CRQE_DATABASETYPE, "JDBC (JNDI)");

bag.put(PropertyBagHelper.CONNINFO_DATABASE_DLL ,"crdb_jdbc.dll");

oIconnectionInfo.setAttributes(bag);

oConnectionInfos.add(oIconnectionInfo);

The reports are running for the most part, but the export functionality is not working and seems to take as long to export a report as it did to run it originally. Very glitchy this API it seems, we've been having troubles getting it to perform reliably, so I'm hoping it's a configuration issue or something. Any help would be vastly appreciated!

Thanks,

Mike