trouble connecting to DB server after upgrade

[dag]

On my work PC I run PCLinuxOS. When I was running the 32 bit version I was able to run proprietary software that accesses our Windows 2003 SQL database. I believe there was something I had to install with Winetricks to make it work in Wine, but can't recall now what it was. It may have also been a library override, or both.

I recently upgraded the PC to 64 bit PCLinuxOS, which destroyed everything except my home folder which is a separate partition. Now when I run the program it reports the connection to the database server is lost, and will not continue.

I've searched this forum, found some reference to editing winetricks configuration, which would then allow the installation of the app I need. I do recall having to do this, but not the details. I can't find what files I need to edit, nor information about what I should install.

Since this is not Windows, the software vendor is not able to help.

All help will be appreciated.

[dimesio]

On my work PC I run PCLinuxOS. When I was running the 32 bit version I was able to run proprietary software that accesses our Windows 2003 SQL database. I believe there was something I had to install with Winetricks to make it work in Wine, but can't recall now what it was. It may have also been a library override, or both.

This may be what you're looking for: http://www.winehq.org/docs/wineusr-guid ... ure#AEN962.

[dag]

Thanks. I went through that procedure up to the point of running mdac_typ.exe. The instructions say to link a file but not where the link should be placed. I did it in /usr/lib64/wine. That did not help. So proceeded to run mdac_typ.exe from Wine, which I had tried last week. It failed with error indicating "this setup does not support installing on this operating system." WHich may be due to the fact that Microsoft has dropped XP altogether. I may have to look for an older version.

[dimesio]

Thanks. I went through that procedure up to the point of running mdac_typ.exe. The instructions say to link a file but not where the link should be placed. I did it in /usr/lib64/wine.

If you mean the part that says

# ln -s libodbc.so.1.0.0 /usr/lib/libodbc.so

the symlink should be in the same directory as the file you're linking to. In the example that would be /usr/lib.

That did not help. So proceeded to run mdac_typ.exe from Wine, which I had tried last week. It failed with error indicating "this setup does not support installing on this operating system." WHich may be due to the fact that Microsoft has dropped XP altogether. I may have to look for an older version.

FYI, you can change the Windows version reported by Wine to something newer in winecfg.