ODBC2 and "Error creating product object" error

HCL Domino Domino Forum
1

After upgrading a Domino Server from 6.5.6 to 8.5.1 FP1 (64-bit) running Windows 2008 64-bit, a scheduled agent that uses ODBC2 to via LCConnection to connect to Microsoft SQL Server is generating the following error now:

Error #217 - Error creating product object

Initially, I thought this had to do with the Lotus Domino Service running as a “Local System Account” but that does not appear to be the cause.

However, our DB2 connections using LCConnection are working properly.

The ODBC System connection exists on the machine and I can test that connection without any issues. It seems like the connection is failing before it even tries to use the configured information. The ODBC driver for SQL Server is 6.00.6002.18005.

Does anyone have any ideas of what we might have to either install, enable or (worse case) copy into the Domino program files folder?

UPDATE - It appears that the nodbc2.dcx file is not getting installed as a part of the 8.5.1 install. Since Domino cannot find this file, we believe the error above is happening. Posts that we have seen indicate copying an old file can cause Domino to crash.

Thanks!

jv

2

Subject: Resolution …

Below, is the resolution to our issue … for others who find themselves in the same boat as you upgrade to 8.5.x:

The problem stems from the upgrade to the 64-bit version of Domino and Windows. Since your script had been using ODBC2, that indicates that you were previously using our Lotus ODBC drivers, which utilize nodbc2.dcx.

However, now that you are on 64-bit Domino and 64-bit Windows, this attempted connection is failing for two reasons:

  1. According to the driver version you provided, you are now using the SQL Native Client, rather than the ODBC drivers. (Certainly this is understandable, since the ODBC drivers are 32-bit only until 8.5.2 is released). However, the SQL Native Client cannot and will not use ODBC2. It is only capable of utilizing an OLE DB connection to MS SQL.

  2. Domino 64-bit cannot use ODBC connections at this time. That functionality will be added to the 64-bit code in 8.5.2. (That is to say, even if we had an ODBC driver in a 64-bit version, we would not be able to use ODBC2 until 8.5.2).

I’m assuming that you have a 64-bit version of the SQL Native Client. If so, then you’re on the right track - we just need to change your script to use the correct connector type. You will first want to create an OLE DB connection to your MS SQL database (being a Microsoft connector, I can’t provide explicit instructions, but they should be generally available online). Then, simply create an LCConnection of type “OLEDB” in your

script, which utilizes that connection. For your reference, here are the LCConnection parameters for OLE DB:

connection.Provider = “sqloledb” if connecting to SQL Server

connection.Init_datasource = Name of your SQL Server

connection.Database = Name of your database

connection.UserId = Userid

connection.Password = Password

connection.CommitFrequency = Commit every “N” operations

connection.Metadata = Table/View/Proc that you are connecting to.

Now, 64-bit Domino will only be able to use a 64-bit connector, so if you do in fact have a 32-bit version of the SQL Native Client, you will need to download and install the 64-bit version.

3

Subject: Release 8.5.2

“Domino 64-bit cannot use ODBC connections at this time. That functionality will be added to the 64-bit code in 8.5.2.”

When will this release be available ?

4

Subject: ODBC for ORACLE 11g R2

Dears,is there any resolution for ODBC ORACLE 11gR2 (64-bit) ???

regards…Valdir.

5

Subject: Thank You

Many thanks for posting a resolution!

Helps a lot!

Greatings

Martin