FreeTDS Development Group

["David Chang" <dchang AT fsautomation.com>]

Answers are below...

----- Original Message ----- 
From: "Garudappa, Gangegowda (iGATE)" <gangegowda.garudappa AT rbc.com>
To: <freetds AT lists.ibiblio.org>
Sent: Saturday, March 08, 2008 10:24 AM
Subject: [freetds] Migrating code from HPUX to Windows.


> We are migrating one of the legacy Unix application to Windows VS .Net
> environment.
> We are planning to use freeTDS8.2/6.4 and we have downloaded it. But we
> did not see any options for compiling/building freeTDS application on
> Win 2003 Server using VS .NET.
>
> We would like to know the following,
>
> 1) Are there already a database stubs/libraries/functions available in
> Microsoft/Visual Studio(VC++) for connecting and performing database
> operations on Sybase database running on Solaris box.

Yes.  If you are using Sybase ASE, you can download the PC client software 
for ASE from Sybase at 
http://downloads.sybase.com/swd/detail.do?relid=6942&ebf=12305&baseprod=2&client=search , 
however, you need a valid Sybase login (I think this means you have to have 
a valid maintenance contract with Sybase).

Once you have these libraries and include files, you can write (or port) 
DB-Library and CT-Lib applications in Microsoft C++.

Otherwise, you can use FreeTDS.  I've only used the DB-Library API for 
FreeTDS.  I'm not sure if they have a CT-Lib API.

Lastly, you can always use Cygwin (UNIX API layer) and compile FreeTDS with 
gcc and the port might be easier.

> 2) Is it possible to use existing HPUX open-client libraries on Windows
> side to perform Sybase database operations running on Solaris box. The
> Unix application is compiled using 'cc' with all the sybase libraries.
> Is it possible to use the Unix database related libraries to customize
> our application.

Sure.  Once you have the Net-Lib and DB-Lib layers, you can communicate with 
any ASE server regardless of O.S.

> 3)What are the essential things are required from freeTDS for connecting
> to a database server running on Solaris machine.

Once the application compiles, you just need to set-up the proper 
freetds.conf file.  There are lots of examples and it's fairly simple.
If you're already familiar with the 'interfaces' file in Sybase, you should 
have no problems with the freetds.conf file.

> 4) How to compile/build freeTDS in MS-VS .Net 2005 environment.

What specific question do you have about this?  Generally you do a 
'configure' and a 'make'.

> 5) How to integrate/customize our application with freeTDS.
>
> We are running on below platform,
> 1. The database will be running on : Sybase ASE 12.5
> Sparc/Solaris2.8
> 2. The application runs and connects to database from : Windows
> 2003 Server Visual Studio with .Net 2005 environment using VC++
> Please correct us if we are missing anything here because this is the
> first time we are trying to do this.
> Please let us know if there is any alternative mechanism or different
> open source code/libraries available to implement the same.
> We are running on below platform,
> 1. The database will be running on : Sybase ASE 12.5
> Sparc/Solaris2.8
> 2. The application runs and connects to database from : Windows
> 2003 Server Visual Studio with .Net 2005 environment using VC++

Is it a DB-Lib application?  If so, you only need to make modifications to 
the Windows specific things (like filenames that use backslashes, and 
multiple hard drive letters) or use the Cygwin API layer.  The DB-Lib stuff 
pretty much works.

DC