Wine + unix ODBC + delphi app BIG PROBLEM....

[x-man]

Hi,
I must use one windows application on linux, that app must connect to MSSQL 2005 DB and in this moment I trying to do it with freetds + unixodbc + wine but always I have same error when I click connect in this app and that is "required provider is not installed" and this is result of WINEDEBUG=+odbc32 wine app.exe:

err:winediag:X11DRV_WineGL_InitOpenglInfo The Mesa OpenGL driver is using software rendering, most likely your OpenGL drivers haven't been installed correctly (using GL renderer "Software Rasterizer", version "2.1 Mesa 7.11").
fixme:win:DisableProcessWindowsGhosting : stub
err:ole:CoGetClassObject class {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} not registered
err:ole:CoGetClassObject no class object {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} could be created for context 0x1
err:ole:CoGetClassObject class {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} not registered
err:ole:CoGetClassObject no class object {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} could be created for context 0x1
err:ole:CoGetClassObject class {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} not registered
err:ole:CoGetClassObject no class object {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} could be created for context 0x1
err:ole:CoGetClassObject class {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} not registered
err:ole:CoGetClassObject no class object {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} could be created for context 0x1
err:ole:CoGetClassObject class {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} not registered
err:ole:CoGetClassObject no class object {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} could be created for context 0x1
err:ole:CoGetClassObject class {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} not registered
err:ole:CoGetClassObject no class object {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} could be created for context 0x1
fixme:msxml:domdoc_createNode nodes with namespaces currently not supported.
fixme:msxml:domelem_setAttributeNode (0x5fa3a18)->(0x5fa3dac 0x6fde588): semi-stub
fixme:msxml:domdoc_createNode nodes with namespaces currently not supported.
fixme:msxml:domelem_setAttributeNode (0x5fa3a18)->(0x5fa3dec 0x6fde588): semi-stub
fixme:msxml:domdoc_createNode nodes with namespaces currently not supported.
fixme:msxml:domelem_setAttributeNode (0x5fa3a18)->(0x5fa3e8c 0x6fde588): semi-stub
fixme:msxml:domdoc_createNode nodes with namespaces currently not supported.
fixme:msxml:domelem_setAttributeNode (0x5fa3ce0)->(0x5fa3fbc 0x6fde560): semi-stub
fixme:wininet:InternetAttemptConnect Stub
fixme:wininet:CommitUrlCacheEntryInternal entry already in cache - don't know what to do!
fixme:msxml:domdoc_createNode nodes with namespaces currently not supported.
fixme:msxml:domelem_setAttributeNode (0x5fafcb8)->(0x5fafeac 0x6fde57c): semi-stub
fixme:ntdll:NtLockFile I/O completion on lock not implemented yet


Look like this app looking for native odbc but when I install mdac28 and set all libraries to builtin than in app I have some "ole db error occured" error...but this app can`t see unixodbc!!!

Also after few days trying to use native (mdac28) odbc I must stop to test it because always I have some SSL error when I want to connect to MSSQL DB and I know that ssl forcing is disabled but wine forcing ssl and than I must install secur32 and than again I have ssl error...

I hope that somebody can help me because I working on this few days and I need this app to work on linux...

Thanks.

[dimesio]

err:winediag:X11DRV_WineGL_InitOpenglInfo The Mesa OpenGL driver is using software rendering, most likely your OpenGL drivers haven't been installed correctly (using GL renderer "Software Rasterizer", version "2.1 Mesa 7.11").

Reinstall your graphics driver. If your system is 64 bit, make sure you have 32 bit OpenGL installed.

Look like this app looking for native odbc but when I install mdac28 and set all libraries to builtin

"Builtin" means Wine's dlls; you need to set them to "native."

You didn't say what Wine version you're using. If it's older than 1.4, upgrade.

[x-man]

System is 32 bit but in this moment graphics driver is not main problem...

I set it to "Builtin" because I want to use unix ODBC but simple this app or wine can`t see unix ODBC...

Like I already said, when I install mdac28 and set all libs to native, app try to connect to DB but always I have SSL error and can`t connect, why??? I have disabled it on MSSQL server, that is always disabled....

I`m on opensuse and I using last 1.5 version of wine...

[dimesio]

Did you follow the instructions in the User's Guide? http://www.winehq.org/docs/wineusr-guid ... ure#AEN757

[x-man]

Yes, I do that, I have /usr/lib/libodbc.so.1.0.0 and /usr/lib/libodbc.so and I have LIB_ODBC_DRIVER_MANAGER=/usr/lib/libodbc.so.1.0.0...

After it I have added odbc32 as builtin but my app can`t see it...from this errors:
err:ole:CoGetClassObject class {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} not registered
err:ole:CoGetClassObject no class object {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} could be created for context 0x1
err:ole:CoGetClassObject class {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} not registered
err:ole:CoGetClassObject no class object {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} could be created for context 0x1
err:ole:CoGetClassObject class {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} not registered
err:ole:CoGetClassObject no class object {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} could be created for context 0x1
err:ole:CoGetClassObject class {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} not registered
err:ole:CoGetClassObject no class object {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} could be created for context 0x1
err:ole:CoGetClassObject class {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} not registered
err:ole:CoGetClassObject no class object {85ecafcc-bdd9-4b03-97a8-fa65cbe3859b} could be created for context 0x1
err:ole:CoGetClassObject class {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} not registered
err:ole:CoGetClassObject no class object {0c7ff16c-38e3-11d0-97ab-00c04fc2ad98} could be created for context 0x1

look like this app looking for native odbc driver and when I install mdac28 this errors gone but than every time I have ssl error from mssql server, why sql server or odbc driver forcing ssl connection??? How I can disable it or how to make it to work with ssl?

Thanks.

[dimesio]

look like this app looking for native odbc driver and when I install mdac28 this errors gone but than every time I have ssl error from mssql server,

Did you run CLICONFG.EXE and ODBCAD32.EXE after installing mdac, as the User's Guide specifies?

Post terminal output from running with odbc32 set to native.

[x-man]

Yes, I do that, when I do all of this what I do on UBUNTU with wine version 1.2 this app connecting to mssql fine without any error but in that version and with ubuntu I have other problems, when I upgrade to wine 1.3 on ubuntu this problems with ssl errors starting and I don`t know how to fix it...same ssl errors I have with suse and wine 1.5!!

From this you can see that I know how to setup all but from wine 1.3 something is not same like on 1.2 and always forcing ssl connections via TCP/IP and I have this problem...

Problem is same like in this post: http://forum.winehq.org/viewtopic.php?t=12981

I hope that somebody know how to fix this...

Thanks.

[lahmbi5678]

Hi x-man,

this probably won't help you, but would it be possible to create a simple test case, consisting of a minimum delphi app (maybe using windows odbc instead of freetds), sample db and simple instructions how to set up e.g. MS SQL Express in order to reproduce the problem. With all that information you could file a bug in wine's bugtracker. There have been similar issues in the past, but nobody took the effort and created a bug report, which is somewhat sad.

kind regards,

[Romulo Carlos]

Hi xman! I'm the topic's author you mentioned above.

Do you have any news?? Like I sayed on my thread, now I have unixODBC configured and connecting with my DB (I can see all tables and DB on the server).

Even setting Wine to use builtin DLLs (wich, they say, is a 'bridge' to connect unixODBC with Windows), I receive the SSL Security Error when I create a System DNS!!

[lahmbi5678]

Hi Romulo and x-man,

as I said, you should file a bug and provide a sample app with easy-to-follow instructions. The biggest hurdle would probably be setting up an MSSQL server and creating test data, so maybe one of you could set up such a server at his/her home and make it publicly accessable for some time (as long as bug report would be open), this would make reproducing the bug much easier. This would of course pose an immense security risk, you should do this on a computer/VM which isn't important and you should delete/backup the whole system afterwards.

[Romulo Carlos]

Hi Romulo and x-man,

as I said, you should file a bug and provide a sample app with easy-to-follow instructions. The biggest hurdle would probably be setting up an MSSQL server and creating test data, so maybe one of you could set up such a server at his/her home and make it publicly accessable for some time (as long as bug report would be open), this would make reproducing the bug much easier. This would of course pose an immense security risk, you should do this on a computer/VM which isn't important and you should delete/backup the whole system afterwards.

Good morning!

Well, I can't setup a server or a VM and open it here... But, I can explain WHEN the problem occours.

1. Install the latest version of Wine, unixODBC (For me, Wine is emulate an XP machine)
2. Install and configure unixODBC, so it can access the MSSQL server
3. Configure Wine to use builtin ODBC libraries
4. On Wine, navigate to c:\windows\system32 and run ODBCAD32.EXE
5. Create a System DNS, setting it to use SQL Autentication

The first 4 steps above I have done. But, on the Autentication screen in step 5, when I put the user/password and click "Next", the system hangs for a while, and then the message "SSL Secirity error" comes up.

Detail: if I configure Wine to use builtin library, I get the security error. If I configure it to use native DLLs, the ODBCAD32.EXE don't open!

I don't think is a bug... maybe a configuration detail or something like...

Thanks a lot!

[lahmbi5678]

Hi,

I'm still thinking, you should file a bug, maybe two for both unixODBC and windows (native) ODBC. It probably won't help much, but what is the terminal output before "security error" and/or ODBCAD.exe not starting?

The point is, you should bring this issue to the attention of wine developers, only few of them are following wine users list, so either file bugs or post to the wine devel mailing list.