Using Windows ODBC drivers

[Simon.Tyler at ddscanada.com]

Hi Brian,

I'm not sure if this is useful, but I have been able to access MSSQL
databases from Linux using Unix ODBC and FreeTDS. I was unable to get Wine
to use this method of accessing the database, so I switched back to Windows
ODBC drivers.

Simon Tyler


                                                                           
             "Brian Vincent                                                
             (C)"                                                          
             <VincentB at copperc                                          To 
             olorado.com>              "'fwunderlich at devbrain.de'"         
             Sent by:                  <fwunderlich at devbrain.de>           
             wine-devel-admin@                                          cc 
             winehq.org                "'wine-devel at winehq.org'"           
                                       <wine-devel at winehq.org>             
                                                                   Subject 
             04/29/2004 01:33          Re: Using Windows ODBC drivers      
             PM                                                            
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           







> 5.14.2. Using Windows ODBC drivers
> Does anyone actually have any experience of this and anything to add?
>
>
> I do, with Microsoft Access and the JetProxy JDBC. If there's any
> interest, I can give you a quick summary on how to set things up.


It looks like the stuff on WineHQ is a bit out of date.
A patch I submitted in March added some info that Boaz
put together.  Now that section should read:


      <title>Using Windows ODBC drivers</title>
        <para>
          Native ODBC drivers have been reported to work for many types of
          databases including MSSQL and Oracle. In fact, some like MSSQL
can
        only be accessed on Linux through a Winelib app.   Rather than
        just copying DLL files, most ODBC drivers require a Windows-based
        installer to run to properly configure things such as registry
keys.
        </para>
        <para>
          In order to set up MSSQL support you will first need to download
          and run the mdac_typ.exe installer from microsoft.com.  In order
to
        configure your ODBC connections you must then run CLICONFG.EXE and
          ODBCAD32.EXE under Wine.  You can find them in the windows\system

        directory after mdac_typ runs.  Compare the output of these
programs
        with the output on a native Windows machine.  Some things, such
        as protocols, may be missing because they rely on being installed
          along with the operating system.  If so, you may be able to copy
        missing functionality from an existing Windows installation as
        well as any registry values required.  A native Windows
installation
        configured to be used by Wine should work the same way it did
        when run natively.


If you'd like to make any additions or corrections, please
work from the version in CVS.  If you'd like me to do the
SGML markup, feel free to email me raw text to add.  If so,
no rush - I'll be out of town till May 10th.


Thanks!


---------------
Brian Vincent
Copper Mountain Telecom
vincentb at coppercolorado.com