RE: FW: Question

I did reply to this on tuesday... as follows:

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@xxxxxxxxxxx]
> Sent: 25 September 2003 20:43
> To:   freetds@xxxxxxxxxxxxxxxxx
> Subject:      [freetds] FW: Question
> 
> I sent you this question on Tuesday but have not gotten a reply.  Can
> your product be used to do this?
>  
> thanks 
> Richard Shariff
> richard@xxxxxxxxxxx
> -----Original Message-----
> From: Richard Shariff [mailto:richard@xxxxxxxxxxx] 
> Sent: Tuesday, September 23, 2003 6:37 PM
> To: 'freetds@xxxxxxxxxxxxxxxxx'
> Subject: 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@xxxxxxxxxxx
> _______________________________________________
> FreeTDS mailing list
> FreeTDS@xxxxxxxxxxxxxxxxx
> http://lists.ibiblio.org/mailman/listinfo/freetds