cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC Error in Windows 7

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (7)

Answers (7)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

Forget my question. I overlooked that you are testing the DB driver directly.

CI X R2 SP6 is supported on Windows 7 anyway.

Regards,

Stratos

0 Kudos

Hi Rich,

Appears to be correct. Try testing with the DataDirect 5.3 drivers you can download from our download page:

https://smpdl.sap-ag.de/~sapidp/012002523100008666562008E/cr_datadirect53_win32.zip

Thank you

Don

Former Member
0 Kudos

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

0 Kudos

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

0 Kudos

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

0 Kudos

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

Regards,

Stratos