Skip to Content.
Sympa Menu

freetds - Re: [freetds] Migrating code from HPUX to Windows.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "David Chang" <dchang AT fsautomation.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Migrating code from HPUX to Windows.
  • Date: Sat, 8 Mar 2008 12:20:28 -0800

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






Archive powered by MHonArc 2.6.24.

Top of Page