Native ODBC in WinXP Mode

[Chad]

Has anyone here been able to get native ODBC MS SQL connection working in Wine while the Windows version is set to XP? I've been able to get it working as long as it's set to Win98, but that's a bit of a problem now.

I'm currently running an application that no longer works or is supported in Windows 98. The aplication starts fine in WinXP mode, except for the fact that it cannot connect to the database due to the native ODBC MS SQL issue in WinXP mode.

When in WinXP mode I can setup the system DSN, but it doesn't seem to even connect to the database. When configuring the DSN via odbcad32, I cannot change the default database of the DSN and when I try to test the connection at the end I receive "Test Failed!". The only wine error/fixme messages I receive are...

err:ntlm:SECUR32_initNTLMSP ntlm_auth was not found or is outdated. Make sure that ntlm_auth >= 3.0.25 is in your path.
err:ntlm:SECUR32_initNTLMSP Usually, you can find it in the winbind package of your distribution.
fixme:winsock:WSAIoctl unsupported WS_IOCTL cmd (98000004)
fixme:winsock:WSAIoctl unsupported WS_IOCTL cmd (98000004)

A quick google of these messages doesn't bring up anything too interesting. I created a +odbc log to see if anything real noticeable was in there, though I have to admit that reading through debug logs is probably beyond my abilities in most of these situations Nothing really stood out in there either, though I do get quite a few messages with "<unknown, check return>", such as...

CALL DBnetlib.ConnectionOpenW(<unknown, check return>)

Any ideas or insight is appreciated! Btw - I tried to configure unixODBC and FreeTDS for this application and ran into problems there too, which I believe are FreeTDS related. Anyways, it would be quite convienient to just use the native ODBC for the DSN.

[Chad]

Has anyone here been able to get native ODBC MS SQL connection working in Wine while the Windows version is set to XP? I've been able to get it working as long as it's set to Win98, but that's a bit of a problem now.

I'm currently running an application that no longer works or is supported in Windows 98. The aplication starts fine in WinXP mode, except for the fact that it cannot connect to the database due to the native ODBC MS SQL issue in WinXP mode.

When in WinXP mode I can setup the system DSN, but it doesn't seem to even connect to the database. When configuring the DSN via odbcad32, I cannot change the default database of the DSN and when I try to test the connection at the end I receive "Test Failed!". The only wine error/fixme messages I receive are...

err:ntlm:SECUR32_initNTLMSP ntlm_auth was not found or is outdated. Make sure that ntlm_auth >= 3.0.25 is in your path.
err:ntlm:SECUR32_initNTLMSP Usually, you can find it in the winbind package of your distribution.
fixme:winsock:WSAIoctl unsupported WS_IOCTL cmd (98000004)
fixme:winsock:WSAIoctl unsupported WS_IOCTL cmd (98000004)

A quick google of these messages doesn't bring up anything too interesting. I created a +odbc log to see if anything real noticeable was in there, though I have to admit that reading through debug logs is probably beyond my abilities in most of these situations Nothing really stood out in there either, though I do get quite a few messages with "<unknown, check return>", such as...

CALL DBnetlib.ConnectionOpenW(<unknown, check return>)

Any ideas or insight is appreciated! Btw - I tried to configure unixODBC and FreeTDS for this application and ran into problems there too, which I believe are FreeTDS related. Anyways, it would be quite convienient to just use the native ODBC for the DSN.

Ok, I actually worked around this. I ended up upgrading to FreeTDS 0.82 (Ubuntu only packages 0.63) and then setting the TDSVER to 8.0 solved the issue and allowed my application to finally launch. I figured I would at least report back in case someone searches and finds this info helpful

However, building FreeTDS from source was a huge pain (on ubuntu at least) that I don't wish any new users of Wine to have to go through to get an app to work :p

Anyways, the issue with using native dll's for ODBC is still an issue, as I was still unable to get it to work outside of Win98 mode. I guess this would turn into more of a wish list item then an actual problem with wine, as being able to utilize the windows odbcad32 configuration program is much easier and convenient than unixODBC and FreeTDS, IMO at least.