LSXODBC: SQL Connection crashes Notes Client when table contains images

HCL Domino Domino Forum
1

I’m accessing a SQL-table with Lotusscript. When that table contains images it crashes my Notes Client.

I actually developed my script with a copy of that table in a local Access DB. There it did work. But when I switched to a data source that points to the SQL-Server, it crashes.

Softwareversions:

SQL Server 2000 on Windows Server 2003

Notes 6.5.4 on Windows XP Professional 2002, SP2

ODBC: Microsoft SQL Server ODBC-Treiber Version 03.85.1117

The crash happens here:

odbcResult.execute

’ OK

If odbcResult.isresultsetavailable Then

’ crash

I can prevent the crash by selecting only some columns instead of “*”.

(I don’t need the image, so this is a workaround for me, I just get all the other columns)

Tables without images work fine.

I saw some other posts about odbc crashing Notes but none of theme seemed to be related to images.

2

Subject: LSXODBC: SQL Connection crashes Notes Client when table contains images

The only officially supported ODBC drivers are the DataDirect branded drivers for Lotus. You can get them from Passport Advantage. I have successfully used other drivers, but whenever I have called for support they have been adamant that I use the branded drivers. That would be the first place to start.