The forum

App using odbc crashes

any hints appreciated

Author Replies
shh Wednesday 25 March 2015 at 10:14
shhAnonymous

Hi, my employer just asked me, if a certain piece of software that he uses would run on linux - so I did my best to test and got fairly far, but hit a wall so... here are the details:

- Ubuntu MATE, 14.04 running as guest on a VM server (using KVM)

- WF-MAG (windows version 7.9)

App info, errors and install history:

The app is a stock and invoice management tool currently using MSSQL EXPRESS 2008r2 as its database engine. The database is on a different VM (win 7 pro) and the app connects to the DB through LAN. 

Installing requires at least .NET 3.5, mdac2.8 (though I added vcrun2008). Additionally the software requires CrystalReports XI Runtime. 

The db connection works fine (using FreeTDS and unixodbc), I am able to connect and perform some actions, but after a minute or so the app crashes. 

Errors:

During installation of Crystal Reports Runtime:

Runtime Error! Program c:\Windows\system32\msiexec.exe, no further info. However the main app installs correctly regardles of this error.

On launching the main app:

Create MSXML2.XMLHTTP error (REGDB_E_CLASSNOTREG) 80040154 

Than the app continues startup. I can leave the window open for an indefinite time and it is all OK. I can open sub-windows and commit changes to the DB, create invoices and so on. At a seemingly random moment the app crashes - no errors, all I get is the POL debug window.

 

The full debug log is pretty long, should I post this or is it better to use pastebin or host it somwhere?

Ronin DUSETTE Wednesday 25 March 2015 at 15:26
Ronin DUSETTE

If you could post the full debug log via pastebin, that would be cool. That would probably tell us a lot more. Also, what version of Wine are you using to build the virtual drive? What architecture? I would start with the newest version of Wine, in a clean 32-bit virtual drive (1.7.39 x86), install NOTHING extra (nothing from the Install Components tab), try to install/run the program, and let's start with that particular log first. With Wine, you want to install as little extra as possible. wine-mono provides some .NET compatibility, and that will install automatically with Wine, so try that for now. 

Also, install libxml2:i386, as it looks like that will be needed by Wine (install it into your Linux machine), before doing what I said above, and let's see if that works a little better. Or at least gives us some more insight. 


Please:
Post debug logs & full computer specs in first post
No private messages for general help, use the forums
Read the wiki, Report broken scripts
shh Thursday 26 March 2015 at 8:57
shhAnonymous

Hi again.

First of all - thanks for the reply.

Next - my current setup and logs:

POL version 4.2.2

using wine version 1.7.39, 32 bit install with .net, mdac28, vcrun2008. 

The debug log (used a polish pastebin alternative as I don't have a pro account there...)

http://wklej.to/Skiih

So thats it for now. I'm going to test the libxml2:i386 today and add results here.

Best regards,

Shh

Edit 1: libxml2:i386 was already on the linux box.

Edit 2: Started with a clean wineprefix/drive in POL as suggested, am currently debating if I should try to install the Crystal Reports Runtime required by the main app without errors (Microsoft Visual C++ error, msiexec.exe, This application has requested the Runtime to terminate it in an unusual way) or to ignore the errors and try plowing forward with the main software package.

Edited by shh

Ronin DUSETTE Thursday 26 March 2015 at 18:22
Ronin DUSETTE

Upgrade to POL 4.2.6. Just to make sure you are up to date with that. The only reason I said start with a clean prefix is so that you only add stuff from Install Components as needed. If it is needing that stuff, for sure install it. I just wanted to make sure that it really needed those things. lol. 

Try and do that. If is complaining about it, attempt to correct it. 


Please:
Post debug logs & full computer specs in first post
No private messages for general help, use the forums
Read the wiki, Report broken scripts

This site allows content generated by members, and we promptly remove any content that infringes copyright according to our Terms of Service. To report copyright infringement, please send a notice to dmcayonlinux.com