Wine odbc driver question

[wpflum]

I'm pretty sure the answer is wine wont do this but I'm at my whits end with this issue, so here are the details.

I have a linux redhat server running an informix database that was provided to us by a 3rd party software company so I can't modify it. The company provides an informix sdk client that I can install on a windows machine and connect without any issues. I'm trying to get a linux box to access the informix server so I can move from the wine based access 97 database using the windows driver in wine to a pure linux based setup. Nothing I do seems to get the normal linux informix driver I get from IBM working so is there ANY way to access the windows based DSN that is already working fine in wine from the linux side?




If you reply and I don't respond right away it's probably because I've managed to make reality go away for a while by judicial application of force from my skull to the nearest concrete wall.

[lahmbi5678]

Does your application run in wine with the Windows ODBC driver? That would already be cool, since wine and ODBC still have a difficult relationship.

If you can't get the Linux ODBC driver working in Linux (not wine), you should ask at IBM. Can you get any support from them?

Did you read
http://www.unixodbc.org/doc/informix.html ? Though it seems outdated and different from what I read on the IBM page. Maybe you could ask for help on the unixodbc mailing list?

[wpflum]

Right now I'm using Access 97 in wine with the windows informix driver I got with the server and this works, except when it doesn't. What I want to do is drop Access 97 completely and go with one of the open source report generators I've seen for Linux, don't ask me which one since my getting to that point requires an odbc connection to the informix server first.

I looked at the web page you posted and other than the bit about using the etc/services file to add an "online" service what I'm doing seems identical. I'm wondering if what they talk about is actually the sqlhosts file now.

I wonder if it's possible to set up a wine version of a odbc server to act as a relay and then share that with the linux side as no matter what I've done nothing else seems to work.

I haven't tried to get support from IBM yet as I'm trying to get it through out 3rd party provider first, since we pay them for support, but I'm not sure they have the knowledge or whether or not that kind of support would be in line with out contract.

[lahmbi5678]

Regarding the linux odbc driver, what exactly isn't working? Did you make sure, that there are no permission issues? Does the driver or the client use TCP/UDP ports below 1024? There should be logs and maybe trace functions you could activate.

[wpflum]

It looks like the driver connects to the server, isql and dbaccess both give messages that the user/password is wrong when I fudge them so I know it's talking to the server. dbaccess displays a 'Connected' message when I try and connect to the server but does not show databases I can use and If I enter in a database on the server I get an error of a database not known. I had Trace logging at one point and it looked like exactly what dbaccess showed, connecting to the server but then permission or wrong database errors. This was on two different linux PCs, on a Mint Linux desktop and the other was a Ubuntu server, the one I need it running on. The service is running on port 20000. Permissions are set up ok on the server as the same info on a windows machine with the informix driver works. I've set up the informix group and user like all the info I've read tells you to but if it's another permission I'm not sure what it is.

[lahmbi5678]

You could try to politely ask the guys for help who wrote that page
http://www.ibm.com/developerworks/data/ ... ermanager/ ,
if they are still working at IBM.

Is the Informix server running on a different computer than your client? If so, can you try to connect to it locally, i.e. running isql on the server, using the same operating sytem? It should at least work, if you run e.g. Windows Informix server and Windows isql or linux Informix server and linux isql on the same machine.

[wpflum]

The server is on another computer. I think you misread my reply, when I connect with isql or dbaccess with the correct user/password I seem to connect but do not see any available databases. If I use the wrong user/password on purpose the server errors out saying that the user/password is invalid, to me this indicates that the server is handshaking with the client and authenticating the user/password but after that everything falls apart.

At this point I'm hoping the third party software support will get back to me with some help since they set up the server/software but I'm not holding my breath. This is pretty much what I ran into a year or so ago when I first tried and finally fell back to using wine so I could access the informix server from a linux server so I could convert some reports to run automatically. None of it makes any sense to me and that's why I was hoping I could share out the odbc connection from wine to the linux side to get around this.

[lahmbi5678]

You are right, I posted some nonsense, but edited my post later. It should at least work, if you run isql on the server. That is something I'd try first, assuming that you can do so.