Skip to Content
author's profile photo
Former Member

ODBC Error in Windows 7

I installed Windows 7 Ultimate on a PC and I am trying to set up the ODBC drivers to use with Crystal Reports. I ran CR on my XP machine and have the ODBC settings EXACTLY the same on both PCs. When I click 'Apply & Test Connection' in the ODBC Driver Setup window, it gives me the following error message:

Unspecified System Error = -11333

Unspecified System Error = -11356.[Informix][Informix ODBC

Driver][Informix]Unspecified system Error = -931. sqlerrm(idsgtne)

I have already tried to Disable User Account Access and turned off the Windows Firewall and my Anti-virus with no luck.

Any help would be greatly appreciated.

Thanks, Rich

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • author's profile photo
    Former Member
    Oct 18, 2010 at 06:05 PM

    Did you install SP3 for Crystal Reports? I assume that your are using CR 2008.

    Regards,

    Stratos

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2010 at 03:24 PM

    Is Windows 7 32 or 64 bit?

    If it's 64 then open the 32 bit Control Panel and create your DSN there.

    You may want to post your question to Informix since CR assumes the connection/client is configure and working. At this point you can't get the DSN working so it obviously won't work in Crystal either.

    Thank you

    Don

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 19, 2010 at 03:42 PM

    Hi Don,

    It is 32 bit. I was just hoping this was a common issue with Windows 7 and someone would have been there before. I will check with Informix and see what I can find. If anyone else has any ideas...?

    Thanks Don!

    Rich

    Add comment
    10|10000 characters needed characters exceeded

    • The source of the problem is the Informix client so you should verify they even support Windows 7.

      From the error it looks to be a system resource problem for the client, those types of error would likely not be a typical easy fix but check your PATH statement, Informix like most clients require the \bin folder to be there so all app's have access.

      Thanks again

      Don

  • author's profile photo
    Former Member
    Oct 19, 2010 at 06:58 PM

    Don,

    Here's my Path statement:

    PATH=C:\Program Files\IBM\Lotus\Notes\;C:\Program Files\IBM\Lotus\Notes\Data\;C:

    \Program Files\IBM\Informix\Client-SDK\bin;C:\Windows\system32;C:\Windows;C:\Win

    dows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\

    IBM\Client Access\Emulator;C:\Program Files\IBM\Client Access\Shared;C:\Program

    Files\IBM\Client Access\;C:\Program Files\QuickTime\QTSystem\

    So I guess that /bin is included.

    Stratos,

    I have CR XI, SP 6. I believe that is the most up-to-date sp out there.

    Thanks again,

    Rich

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 25, 2010 at 06:09 PM

    Hi Don,

    I downloaded and installed the drivers. I tried using the "CR Informix ODBC Drive 5.3" and the "CR Informix Wire Protocol ODBC Driver 5.3". Each time I got the same error message (its a new error, so I think we're making progress(?): "[Crystal Reports][ODBC Informix driver][Informix]Unable to load locale categories." Should I be choosing a different driver?

    Here are the settings I am using to configure the driver. I took these setting from my XP machine, that worked just fine.

    Data Source Name = VHN

    Description = M&M Server

    Database Name = cobb

    Database Lise = I left it blank

    Default User Name = rpantano

    Host Name = 10.3.1.2

    Service Name = idsgtne

    Server Name = grandtne

    Protocol Type = onsoctcp

    Thanks again, Rich

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Rich,

      Try using any 3rd party ODBC test tool to verify the client is configure properly. MS has one called ODBCTest or if you can find our old SQLCON32.ZIP it may work also.

      Also make sure the \bin folder is in your PATH statement. CR still uses the PATH to find the client engine.

      Thanks again

      Don

  • author's profile photo
    Former Member
    Oct 26, 2010 at 03:19 PM

    Hi Don,

    I ran the ODBCTest program and came up with the following results. Unfortuantely, they don't mean much to me. Hopefully someone else can translate it for me. And yes, the \bin folder is in my PATH statement.

    SQLDriverConnect returned: SQL_ERROR=-1

    dbc: szSqlState = "HY000", *pfNativeError = -1829, *pcbErrorMsg = 82, *ColumnNumber = -1, *RowNumber = -1

    MessageText = "[Crystal Reports][ODBC Informix driver][Informix]Unable to load locale categories."

    dbc: szSqlState = "HY000", *pfNativeError = -1829, *pcbErrorMsg = 82, *ColumnNumber = -1, *RowNumber = -1

    MessageText = "[Crystal Reports][ODBC Informix driver][Informix]Unable to load locale categories."

    SQLError:

    In: henv = SQL_NULL_HENV, hdbc = SQL_NULL_HDBC,

    hstmt = SQL_NULL_HSTMT, szSqlState = 0x006CBB10, pfNativeError = 0x006CBBE0,

    szErrorMsg = 0x006CBC28, cbErrorMsgMax = 300, pcbErrorMsg = 0x006CBBF8

    Return: SQL_INVALID_HANDLE=-2

    Out: *szSqlState = <unmodified>, *pfNativeError = <unmodified>,

    *szErrorMsg = <unmodified>, *pcbErrorMsg = <unmodified>

    Thanks again,

    Rich

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Rich,

      Basically what the log tells you is the Driver failed to create a HDBC handle. It may be an indication your log on credentials are not correct. If it doesn't log on it can't get a handle. That's the initial connection, once the handle is created then "henv" creates a thread to piggy back onto the handle then queries the DB for the database and table names etc.

      It really doesn't like your categories.... Try the same test using Informix's ODBC driver. Then search Data Directs site on the error. DD is the Company that created these drivers for CR, they should be able to tell you what the exact error message means.

      You could also search Informix's forums for more info....

      It may be a permission issue also, be sure you are logged on as the local PC admin and you run the installer as Administrator by right clicking on the setup.exe.

      Sorry I can't be of more help...

      Thanks

      Don

  • author's profile photo
    Former Member
    Nov 04, 2010 at 07:11 PM

    Just to let you know... I am now able to use CR. I still can not complete a test through the ODBC Drive Test button, but CR works(?). Go figure. When I find some time I may go back and play with this again, but... it works!

    Thanks for everyone's help!

    Rich

    Add comment
    10|10000 characters needed characters exceeded