Re: FreeTDS driver for windows

Hi guys,

You should have told me it would be easy...

Steps for future reference:
1. downlad freetds-stable.tgz. - I used 0.82 version
2. download bloodshed devcpp from their site - I used Dev-C++ 5.0 beta 9.2
(4.9.9.2) full.
3. install devcpp
4. unpack freetds.
5. run devcpp and File->Open project or File...
6. go to: freetds-0.82\win32\dev-cpp and select FreeTDS.dev
7. press Ctrl+F9 to compile. it will create FreeTDS.dll in the same folder.
8. copy the dll to c:\windows\system32 or %WINDIR%\System32

Register the driver in the ODBC - 32 bit - under Windows Server 2008 R2 64
bit.

Run this commands as Administrator from cmd:

C:\Windows\SysWOW64\ODBCCONF.exe INSTALLDRIVER
"FreeTDS|Driver=FreeTDS.dll|Setup=FreeTDS.dll||"
C:\Windows\SysWOW64\ODBCCONF.exe CONFIGDRIVER "FreeTDS" "APILevel=1"
C:\Windows\SysWOW64\ODBCCONF.exe CONFIGDRIVER "FreeTDS"
"ConnectFunctions=YYY"
C:\Windows\SysWOW64\ODBCCONF.exe CONFIGDRIVER "FreeTDS"
"DriverODBCVer=02.50"
C:\Windows\SysWOW64\ODBCCONF.exe CONFIGDRIVER "FreeTDS" "FileUsage=0"
C:\Windows\SysWOW64\ODBCCONF.exe CONFIGDRIVER "FreeTDS" "CPTimeout=60"

Run C:\Windows\SysWOW64\odbcad32.exe to see the FreeTDS driver in place.

When i installed it to the 64 bit ODBC - and error kept coming when i tired
to use it :The Setup routines for the FreeTDS ODBC Driver could not be
loaded due to system error code 193.
I guess this driver compiles only to 32 bit.

Dave.


On Fri, May 13, 2011 at 7:17 PM, Brian Bruns <[email protected]> wrote:

> If anybody is looking into packaging FreeTDS on Windows, I've used Wix
> (wix.sourceforge.net) for another project compiled with mingw and it
> works really well to generate an .msi file and register
> services/drivers and whatnot.  It was surprisingly easy.
>
> Brian
>
>
> On Fri, May 13, 2011 at 10:57 AM, Frediano Ziglio <[email protected]>
> wrote:
> > 2011/5/13 David Savelski <[email protected]>:
> >> Hi guys, thanks for your posts.
> >>
> >> I need a driver that I could load into Microsoft ODBC data sources
> >> (odbcad32.exe) like i use it under linux odbc.
> >>
> >> Can that be done? in what enviroment can i compile it?  Is there any
> >> compiled drivers for this already out there?
> >>
> >> Why can't it be downloaded and installed like db2 drivers or informix
> >> drivers...
> >>
> >> Thanks,
> >>
> >> Dave
> >>
> >
> > You can... I don't exactly remember how :(
> >
> > I think it should be possible to copy the dll and register with
> > regsrv32 (I know regsvr32 works for ActiveX but I wrote the code that
> > let our driver register with regsrv32!)
> >
> > Frediano
> >
> >>
> >> On Wed, May 11, 2011 at 4:58 PM, Andrew H. Wakefield
> >> <[email protected]>wrote:
> >>
> >>> To answer the question another way, I am working on a project that
> needs
> >>> to be able to run on Windows and on Linux (and maybe on Mac, but
> haven't
> >>> gotten that far yet). I am using FreeTDS to connect to an MS-SQL Server
> >>> database. Using Linux as my development platform, I have had no
> problems
> >>> cross-compiling FreeTDS for Windows and using it in the cross-compiled
> >>> program running on Windows.
> >>>
> >>> Note that I am still using 0.82 -- one of these days I'll give .91 a
> >>> try, but for now my energy is best spent elsewhere.
> >>>
> >>>
> >>> On Mon, 2011-05-09 at 08:14 -0400, Ken Collins wrote:
> >>> > Luis Lavena did a series of patches in the latest code to allow
> FreeTDS
> >>> to be compiled on Windows. We did this because I prepackage a static
> library
> >>> for Ruby that includes FreeTDS for Windows as part of the TinyTDS
> project <
> >>> https://github.com/rails-sqlserver/tiny_tds>.
> >>> >
> >>> > So technically, your question would be does FreeTDS compile on
> Windows?
> >>> The answer should be yes and then it is a matter of what do you do with
> it
> >>> after that. The answer is whatever you want :) In my case, I wrote ruby
> C
> >>> extensions to make a driver for Ruby. You or others should be able to
> do the
> >>> same.
> >>> >
> >>> >  - Ken
> >>> >
> >>> >
> >>> > > Hi, Is there such a thing as FreeTDS driver for windows ?
> >>> > >
> >>> > > Thanks,
> >>> > > Dave.
> >>> >
> >>> > _______________________________________________
> >>> > FreeTDS mailing list
> >>> > [email protected]
> >>> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >>>
> >>>
> >>> _______________________________________________
> >>> FreeTDS mailing list
> >>> [email protected]
> >>> http://lists.ibiblio.org/mailman/listinfo/freetds
> >>>
> >> _______________________________________________
> >> FreeTDS mailing list
> >> [email protected]
> >> http://lists.ibiblio.org/mailman/listinfo/freetds
> >>
> > _______________________________________________
> > FreeTDS mailing list
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>