Open database error: IDispatch error #3127

Posted by: Rasmussen

Open database error: IDispatch error #3127 - 09/13/12 03:41 AM

When i connect to a specific table in our datawarehouse, I get an "Open database error : IDispatch error #3127"

That specific table contains app. 320.000 records.
When connecting to smaller tables in the same datawarehouse, there's no errors.

Is this a known error ?
Posted by: Anonymous

Re: Open database error: IDispatch error #3127 - 09/13/12 06:57 AM

Rasmussen,
What vesion of PrintShop Mail are you using?
What type of database are you connecting to?
Posted by: Rasmussen

Re: Open database error: IDispatch error #3127 - 09/17/12 07:36 AM

Jeff,
I'm using Printshop Mail 6.1.2 (build 1)
The database is a DB2
I use an sql-server driver to connect between psm and the database.



Product details.
PrintShop Mail Windows Edition
Version 6.1.2 (build 1)

Language: English (C:\Programmer\PrintShop Mail 6.1\Libraries\PSMail_en-US.dll)

Microsoft Windows XP version 5.1 Service Pack 3 (Build 2600)

Library information:
- Msvcr80.DLL - 8.00.50727.4027
- GDIPlus.DLL - 5.2.6002.22791
- ODBC32.DLL - 3.525.3012.0
- RichEd20.DLL - 3.0
- MSFTEDIT.DLL - 4.1
- Shell32.DLL - 6.00.2900.6242
- SHFolder.DLL - 6.00.2900.5512
- MSJET35.DLL - Not found
- MSJET40.DLL - 4.00.9511.0

Plugin information:

- Barcode.plugins.dll - 1.1.1.0
Barcode 05-2008

- DirectSmile.plugins.dll - 2.0.1.0
DirectSmile 05-2008

- OLA.plugins.dll - 1.1.0.1
Acceptgiro 05-2008

Color management disabled.

Copyrights:
The included Adobe ICC Profiles are copyright Adobe Systems Incorporated.
LibTIFF : Copyright (c) 1988-1997 Sam Leffler; Copyright (c) 1991-1997 Silicon Graphics, Inc.
Posted by: Sander vd Berg

Re: Open database error: IDispatch error #3127 - 09/17/12 07:50 AM

We fixed some problems related to DB2 in PSM 7.1.

The most recent PSM version is 7.2. Maybe you could download a trial version to see if this version allows you to connect to that table?
Posted by: Anonymous

Re: Open database error: IDispatch error #3127 - 09/17/12 07:57 AM

Rasmussen,
The "3127" error is a SQL message and as such, you will have to look to the ODBC driver.


Is there a reason you are not using the latest version of PrintShop Mail? There have been improvements in data handling since v6 that may be of value. You can review the release notes for more details:
http://www.objectiflune.com/OL/en-US/Download/DownloadSoftware.aspx