DB2 Datasource Connection problems

[Dmadzia]

I have been using DB2 for a number of years by installing the DB2 v7 client on
the CF server, and creating a datasource via an ODBC socket. This works ok,
but the ODBC drivers are flaky and the CF ODBC server hangs up ALOT. Since I
paid $6K for the enterprise version of CF I thought I would give the DB2 Native
drivers a shot, since I never have problems with the SQL server drivers.
Every time I try to creat a DSN through CF, I get the error:
"Connection verification failed for data source: db2
java.sql.SQLException: The databaseName connection property is not valid when
connecting to Host Operating Systems.
The root cause was that: java.sql.SQLException: The databaseName connection
property is not valid when connecting to Host Operating Systems"

I add the DatabaseName=xxx in the Connection String box or leave it blank,
still same error. What is the difference between the "database" and the
connectionstring "DatabaseName" parameters??

Has anyone else successfully connected to an IBM mainframe with DB2 using the
Native drivers? If so, how??
Thanks. Dan

[Dmadzia]

So no one uses DB2 with Native drivers??

[ksmith]

Hi Dan,
What version of CFMX are you using? What flavor of DB2? Please give version
and OS it is installed to. DB2 varies alot from UDB on windows to Mainframe
MVS. The settings vary also.

Regardless, you should start by making sure you have the latest macromedia 3.5
drivers at [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=42dcb10a[/url]

[Dmadzia]

Thanks. I will load the new drivers.

We have an MVS mainframe with OS390 which is now zOS. DB2 is version 7.

I did figure out that I have to use LocationName instead of DatabaseName.
I now get an error about something not enabled on the Mainframe (sorry, I
don't have the error in fron of me right now. I gave it to my mainframe guys.)
They have Java 2 SDK 1.3.1 installed on the IBM, but it is not enabled. They
will try to enable it and then hopefully I can connect.

Thanks..Dan

[Dmadzia]

I forgot to answer that I have CFMX 7.01 Enterprise installed on a Windows 2003 server.

Dan