Chad wrote:> 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.