Error in ODBC connection to Pick D3 database in CF 7.0.1

[elkar portu]

I've updated CF 5.0 over Windows 2000 to CF 7.0.1 and queries over Pick D3 ODBC
conection give an "ColdFusion MX 7 ODBC Server" error: "ColdFusion MX 7 ODBC
[email]Server@LOCALHOST,ErrorCode=3004,ErrorMessage=sched .swschd.1756.Inte[/email]rnal error,
an unexpected exception was detected.".

After activating ODBC server debugging, generated logfile is as shown in
attach code.

I read a similar problem on CF MX 6 and I want know if it was solved.



Tue Feb 07 09:32:37 2006:SLX ODBC Socket. Build 0097
Tue Feb 07 09:32:37 2006:Connection request from 127.0.0.1, client application
unknown
Tue Feb 07 09:32:37 2006:ZABAL3(2 CPU) - Microsoft Windows 2000(5.0-Service
Pack 4 (Build 2195))

Dumping 73 (00000049) bytes from: NET READ
-------------------------------------|-----------------------
53657175 654C696E 6B000000 05000000 SequeLink.......
01000000 04000000 07000000 02000000 ................
04000000 09000000 04000000 04000000 ................
02000000 05000000 04000000 01000000 ................
08000000 04000007 FF .........

Tue Feb 07 09:32:37 2006:SSP INPUT
====================================
INITIAL CONNECT
SequeLink
Attributes :5
MINSSP :7
MAXSSP :9
CLIENTTYPE :2 JDBC
CLIENTVERSION:2
TYPES :0x7ff

Tue Feb 07 09:32:37 2006:SSP OUTPUT
====================================
INITIAL CONNECT
SequeLink
Attributes :6
SELECTED SSP :9
SELECTED TYPES:0x7ff
SERVER TYPE :DATA ACCESS
SERVER VERSION:0x5040000
SERVER CHARSET:ASCII
ENCRYPTION :0

Dumping 90 (0000005A) bytes from: NET WRITE
-------------------------------------|-----------------------
53657175 654C696E 6B000000 06000000 SequeLink.......
03000000 04000000 09000000 09000000 ................
04000007 FF000000 06000000 04000000 ................
01000000 07000000 04050400 00000000 ................
0A000000 09000000 05415343 49490000 .........ASCII..
000B0000 00040000 0000 ..........

Dumping 35 (00000023) bytes from: NET READ
-------------------------------------|-----------------------
00000009 00000002 00000001 1F000000 ................
11016A00 00000000 00000001 01030000 ..j.............
004CCC .L.

Tue Feb 07 09:32:37 2006:SSP INPUT
====================================
sspVersion:9
-------------------------------------------
CHAIN
SSPREQUEST: ADMIN (receive)
nrAdminVerbs: 1
subverbNr: 0
iSubverbId: ENTITYFINDATTRIB_THISCONN
iEntitytype: 0
iPKAttributes:
iAttributes:
1: 76
Tue Feb 07 09:32:37 2006:SSP OUTPUT
===================================
sspVersion:9
error :0
--------------------------------------------
CHAIN
num:1
subPacketError:0
SSPREQUEST: ADMIN (reply)
error: 0
oSubVerbFailed: 0
nrAdminVerbs: 1
subverbNr: 0
oRetCode: 0
oEntities: (0 entities)
oAttributes:
76: Anonymous

[helenmhudson]

I'm in the very early stages of looking to connect to D3 through my CF7. I
would be very pleased to know if you solved this problem and how you made the
connection . i.e. where do you get the D3 driver from?
Helen

[elkar portu]

The last driver for Pick D3 is ODBC 2.0 (version 27) and ColdFusion MX 6-7 uses
a Datadirect JDBC-ODBC bridge that says that supports ODBC 2.x and 3.x drivers,
but it isn't true, it uses some ODBC 3.x functions that cause error and it's no
possible to connect to the driver. Until Macromedia or Datadirect provide and
JDBC-ODBC bridge that support ODBC 2.0 drivers or Rainingdata upgrades its
driver, you must use CF 5.x, that conects directly to ODBC sources.