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
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
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
Dan Kegel [mailto:dank@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
On 2/8/07, Rolf Kalbermatter r.kalbermatter@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
Boaz Harrosh [mailto:boazharrosh@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
-
Boaz Harrosh -
Dan Kegel -
Kai Blin -
Rolf Kalbermatter -
Stefan Munz