Skip to Content.
Sympa Menu

freetds - RE: [freetds] Question

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Question
  • Date: Wed, 24 Sep 2003 09:15:12 +0100

Hey Richard,

I need to clarify your requirement, so...

My understanding of your requirement is as follows:

1) do I take it that you now wish to communicate with a SQL server database
instead of Sybase ?
2) you have legacy "scripts" that use isql.exe. what kind of scripts ? shell
scripts, batch files ? on Windows or UNIX ?

If I read you right, my experience may help...
I have migrated applications from Sybase to SQL server that include large
numbers of shell scripts that incorporate the Sybase isql program and/or the
bcp program.

My strategy has been to :

1) install freetds
2) install sqsh 1.7 from www.sqsh.org, compile against the freetds
libraries/include files
3) replace calls to "isql" in my shell scripts to call "sqsh" instead (the
interface is, to all intents and purposes, identical)
4) replace calls to "bcp" in my shell scripts to call "freebcp" instead
(again, the interface is in most respects identical)

sqsh compiled against freetds will work equally well against both Sybase &
SQL server. Ditto freebcp

HTH, If I've misunderstood your requirement, please clarify...

Bill

> -----Original Message-----
> From: Richard Shariff [SMTP:richard AT shariff.com]
> Sent: 23 September 2003 23:37
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] Question
>
> I need to write a C++ progam that allows the sybase isql.exe program to
> connect to it and send it sql commands such as "select getdate()". The
> program would respond in a way that isql.exe would think it's a sybase
> server 12.0. The reason for this is that I have legacy scripts that use
> isql.exe to communicate with a sybase server. I have to intercept the
> commands that they send and send the reply that they expect from the
> sybase server.
>
> Will freeTDS allow me to do this?
>
> If not do you know of another product?
>
> By the way is this the proper way to post a question.
>
> thanks
> Richard Shariff
> richard AT shariff.com
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page