Re: Can FreeTDS be used to connect Sybase from Cobol on OpenVMS

"Craig A. Berry" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
On Aug 30, 2010, at 10:46 PM, palani vel wrote:

> Hi Good Morning,
>
> I have a question. Can you please help me out?.
>
> We have existing HP Cobol programs on OpenVMS having embedded SQLs and
> connecting to Sybase DB on Unix using Sybase Open Client libraries.

What sort of precompiler are you using for the embedded SQL?  I can't  
remember Sybase ever having that but it may just be a product we never  
bought.  That's one component I don't know of a replacement for (not  
saying there isn't one, just that I don't know of it).  Depending on  
what the precompiled code looks like, you could end up in a situation  
where you can compile the .cobpre (or whatever it's called) but not  
the .cob.

> Can FreeTDS be used to replace the Sybase Open Client libraries on  
> OpenVMS
> (running on HP Integrity servers) for Cobol?

As the other Craig said, you won't necessarily have binary  
compatibility, but you should have source compatibility as far as  
libsybdb goes.  It's possible there could be some routines you're  
using that are unimplemented in FreeTDS; you'll just have to try it  
and see.  I've never made the FreeTDS build produce shareable images,  
so if you'd been using those, you'll have to switch to static linking  
or modify the build.

> Please note:    Sybase is no longer supporting Open Client on OpenVMS.

Right, since 1998 or so.


________________________________________
Craig A. Berry
mailto:[email protected]

"... getting out of a sonnet is much more
  difficult than getting in."
                  Brad Leithauser
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.