Helping a user migrate an odbc app to Wine

[Dan Kegel]

Can somebody help this (german-speaking) fellow:
http://www.unixboard.de/vb3/showthread.php?t=26943

He says his company's internal application requires
you to input a DSN when installing it, and he doesn't
know how to come up with a DSN under Wine.

Presumably he doesn't want to mess with Unixodbc,
he just wants to keep using the Microsoft drivers...?
- Dan

[Kai Blin]

On Thursday 08 February 2007 01:42, Dan Kegel wrote:
> Can somebody help this (german-speaking) fellow:
> http://www.unixboard.de/vb3/showthread.php?t=26943
>
> He says his company's internal application requires
> you to input a DSN when installing it, and he doesn't
> know how to come up with a DSN under Wine.

The german speaking part is not a problem, I just don't know my way around 
that odbc stuff, not even on win32 native.
> Presumably he doesn't want to mess with Unixodbc,
> he just wants to keep using the Microsoft drivers...?

I figure using the appropriate native dlls would work?
I vaguely remember Windows had a tool to set up odbc drivers, what was the exe 
called?

Cheers,
Kai

-- 
Kai Blin, <kai Dot blin At gmail Dot com>
WorldForge developer    http://www.worldforge.org/
Wine developer          http://wiki.winehq.org/KaiBlin/
--
Will code for cotton.

[Stefan Munz]

Am Donnerstag, 8. Februar 2007 08:23 schrieb Kai Blin:
> On Thursday 08 February 2007 01:42, Dan Kegel wrote:
> > Can somebody help this (german-speaking) fellow:
> > http://www.unixboard.de/vb3/showthread.php?t=26943
> >
> > He says his company's internal application requires
> > you to input a DSN when installing it, and he doesn't
> > know how to come up with a DSN under Wine.
>
> The german speaking part is not a problem, I just don't know my way around
> that odbc stuff, not even on win32 native.
> > Presumably he doesn't want to mess with Unixodbc,
> > he just wants to keep using the Microsoft drivers...?
>
> I figure using the appropriate native dlls would work?
> I vaguely remember Windows had a tool to set up odbc drivers, what was the
> exe called?

it is located in windows/system32 normally. Something like odbcconf.exe or 
odbcad32.exe.
With one of those you can create a DSN and after that provide it to the app.
I post a similiar reply in the unixboard.

cu,

Stefan

-- 
Dipl.-Inform. Stefan Munz. . . . . . . . . . stefan.munz(a)itomig.de
ITOMIG GbR . . . . . . . . . . . . . . . . . www.itomig.de
Sand 14  . . . . . . . . . . . . . . . . . . mobil: [phone]
D-72076 Tübingen . . . . . . . . . . . . . .

[Rolf Kalbermatter]

Dan Kegel [mailto:dank(a)kegel.com] wrote:
> Can somebody help this (german-speaking) fellow:
> http://www.unixboard.de/vb3/showthread.php?t=26943
>
> He says his company's internal application requires you to
> input a DSN when installing it, and he doesn't know how to
> come up with a DSN under Wine.

Hmm, the DSN is just a name. You first would have to configure
it and yes that means under Wine to deal with unixODBC.

Alternatively you could change the connection string to pass all
relevant information to the driver directly and have the configuration
of those parameters in the application itself.
> Presumably he doesn't want to mess with Unixodbc, he just wants
> to keep using the Microsoft drivers...?

Ouch, I wouldn't see how this could work. Running the Microsoft
drivers together with the whole Microsoft ODBC manager under Wine
too would probably be the only way to get that working. But I think
it is safe to assume that that would require quite some work in Wine
before this could possibly work, not to talk about license issues.

Rolf Kalbermatter

[Boaz Harrosh]

On 2/8/07, Rolf Kalbermatter <r.kalbermatter(a)hccnet.nl> wrote:
> Ouch, I wouldn't see how this could work. Running the Microsoft
> drivers together with the whole Microsoft ODBC manager under Wine
> too would probably be the only way to get that working. But I think
> it is safe to assume that that would require quite some work in Wine
> before this could possibly work, not to talk about license issues.
>
> Rolf Kalbermatter

This is totally not true and it is right there in documentation. (User guide)
All you do is install mdac downloadable from Microsoft.com, or any MS
product like Office. Than run odbcad32.exe to set your DSNs. that's
it, works like a charm and is the only known way to man to connect to
an MSSQL server from Unix.
After you install MDAC, you can also install Oracle's drivers for
windows but that is a bit more tricky, just like on windows.
Also search archives it was there before.

Free Life
Boaz

[Rolf Kalbermatter]

Boaz Harrosh [mailto:boazharrosh(a)gmail.com] wrote:
> This is totally not true and it is right there in documentation. (User
> guide)

Ok! I stand corrected. Sorry.
> All you do is install mdac downloadable from Microsoft.com, or any MS
> product
> like Office. Than run odbcad32.exe to set your DSNs.

I had expected some of these drivers to make use of private APIs that might
not
be available under Wine.
> That's it, works like a charm and is the only known way to man to connect
> to
> an MSSQL server from Unix.

Well there is at least FreeTDS unless you need to communicate with the
server
through other means than TCP/IP.

Rolf Kalbermatter