Re: unixODBC, psqlodbcw.so, and Wine...

this looks like the issue I noted to the list. the ucs-2 data being passed
to the unixodbc driver manager was not working with the driver. it was
suggested that I re-build it having edited the config.h file #undef
SQL_WCHAR_CONVERT which did the trick.

On Thu, Jan 21, 2010 at 5:00 PM, <Raiford(at)labware(dot)com> wrote:

> I have been beating my head over this all day and I'm not turning anything
> up at Google. I'm basically trying to get an ODBC app to run in Wine and
> use the PostgreSQL ODBC driver configured in unixODBC. Here is a brief
> rundown of my problem:
>
> First, to prove I have unixODBC set up properly:
>
> * Run /usr/bin/odbctest
> * Select the Conn -> Full Connect ... menu item
> * Select my Data Source, enter a User and Password, and click OK
> * "Full Connect Succeeded" is displayed (yay!)
>
> ** Note that this works regardless of whether I choose the ANSI or Unicode
> ODBC driver.
>
> Now, from within Wine, I run a very similar test:
>
> * Run Unicode ODBCTEST.EXE from
> http://www.datadirect.com/support/downloads/tools/index.ssp
> * Select the Conn -> Full Connect ... menu item
> * Select my Data Source, enter the exact same User and Password, and
> click OK
> * This fails with the text "[unixODBC]c"
>
> ** Note that I can connect via Wine if I use the ANSI ODBC driver, but when
> I try to access a Unicode Postgres database, there are errors that invalid
> data types are being used
>
> Everything looks correct in the ODBC tracing output. I've tried a few
> other scenarios, but this is the most direct test case to show you. In all
> cases, the Unicode driver only passes a single character back to the app
> running under Wine. I have been trying to turn on Postgres specific
> logging, but I can't seem to figure out how. I also considered that maybe
> the Unicode encoding between Wine and unixODBC may be a problem, but I
> didn't see any way to check or change this.
>
> Please help! I'm willing to put more effort in to document this better.
> At this point I'm not sure if its a Postgres error, unixODBC error, or a
> Wine error. Doing this exact same test with FreeTDS and MDBTools had errors
> as well, although the connections did succeed.
>
> I'm running 32-bit Ubuntu 9.10 (Karmic). I have updated Wine to the latest
> available in the Wine PPA with no change in behavior.
>
> Jon