[INUG-Users] Sybase

Fri May 1 22:17:15 EDT 2009

Thanks, Don.  Thats a good answer.  It does help.

The thread made me realize that if IBM really did come out with a product 
then they would be supporting programming questions.  AND as long as IBM 
keeps the door open for free-tds and other solutions that use the standard 
protocol, well, the solution is there for people who want to do that.  IBM 
(geez I hate saying that) can know that the people who are going to do it 
can make it work, so the solution exists and can be talked about as you 
have done,  and no official support needs to be provided because its not 
an official method.  So its still sort of a win win situation I guess. Its 
just that no revenue is being generated.  However, since is a programming 
interface the support resource cost has to be factored in. 

So, anyway, you are a very good PM, Don.  Very few PM's take the time to 
regularly read and post on extremely technical forums like this.  So my 
hats off to you.  Its beyond me how you find the time.

brad

Don Wildman <WILDMAN at uk.ibm.com> 
Sent by: users-bounces at netcoolusers.org
05/01/2009 05:58 PM

Please respond to
users at netcoolusers.org

To
users at netcoolusers.org
cc

Subject
Re: [INUG-Users] Sybase

Thanks Jacob and others on the thread,

You have expressed at least part of the reply I was about to type.  Here 
are a few points to expand on my earlier mail

By "supported" I meant that IBM will take support calls and consider fixes 

to the application causing the problem. In that context we "support" the 
ObjectServer and nco_sql.  We do not "support" freetds.

We know that freetds is extensively and successfully used in the field as 
are the java interfaces. 

Our SEs have posted guidance on GAT on how freetds may be used. 

For a time Micromuse provided a link to version of freetds on its download 

site. We dropped that long ago for a number of reasons but not because it 
does not work.

Our developers at each release aim (a) not to break those homegrown tools 
that use freetds through OpenServer and (b) to protect the ObjectServer 
and thereby its users against Sybase RPC or sql statements which are not 
part of the ObjectServers repertoire but  that some users throw at it by 
various access methods.

An underlying message is that freetds works in this scenario because it 
supports the same protocol for connection and message transfer as that 
used by Sybase OpenServer which provides the communication middleware 
between OMNIbus components.  It is up to the user to ensure that the 
message content is valid for the target application.  For OMNIbus and its 
proprietary ObjectServer database that message must be valid sql from the 
subset described in the OMNIbus Administration Guide, not commands taken 
from the Sybase database manual.

-hth-

Don Wildman 

users-bounces at netcoolusers.org wrote on 01/05/2009 15:59:06:

> [image removed] 
> 
> Re: [INUG-Users] Sybase
> 
> Jacob Steinberger 
> 
> to:
> 
> users
> 
> 01/05/2009 15:59
> 
> Sent by:
> 
> users-bounces at netcoolusers.org
> 
> Please respond to users
> 
> I can confirm PHP can connect directly to an object server.
> 
> And while FreeTDS and other solutions aren't supported, it's fully 
> expected for this to not be supported. Do you think the already 
> burdened support departments want to have to support your custom code 
> on some unknown programming language?
> 
> I sure as heck wouldn't.
> 
> Jacob
> 
> 
> Quoting "Hubbard, Greg L" <greg.hubbard at eds.com>:
> 
> > OMNIbus uses Sybase client libraries, but little else.  Where external
> > software goes "wrong" with OMNIbus is a) assuming that certain SQL
> > commands are required/supported (and they are not), and b) OMNIbus 
uses
> > null terminated variable length strings, and c) other things.
> >
> > If you search the list, you will find plenty of posts about FreeTDS,
> > SQSH, etc.  I think I have heard that PHP may even work if you fake 
out
> > the Sybase driver with FreeTDS.  I know you can get Perl to work 
through
> > DBD::Sybase and FreeTDS.
> >
> > Regardless of what may "work" -- it may not work forever, and IBM is
> > only going to support "official" interfaces.  "If you break it, you
> > bought it".
> >
> > GLH
> >
> > -----Original Message-----
> > From: users-bounces at netcoolusers.org
> > [mailto:users-bounces at netcoolusers.org] On Behalf Of Vineet Gangwar
> > Sent: Friday, May 01, 2009 7:06 AM
> > To: users at netcoolusers.org
> > Subject: Re: [INUG-Users] Sybase
> >
> > I had connected to 7.1 objectserver using Sybase C APIs and could
> > select/update/delete. I had used the free linux version of Sybase 
12.5.1
> > (I think). I am told that you can also use the Sybase API calls using
> > the library files that are supplied along with Objectserver
> >
> > Thanks
> > Vineet
> >
> >
> >
> > On Thu, Apr 30, 2009 at 3:05 PM, Schernau, Ed D <
> > Edward.Schernau at citizensbank.com> wrote:
> >
> >> Guys, any way to make Sybase ODBC drivers talk to the Object Server?
> >> We have requirements to do some Webtop-type stuff, but as upper
> > management
> >> calls it "not so ugly".   I tried the DataDirect trail drivers, but 
it
> >> keeps barfing on "syntax error in line 1" as it sends a "use NCOMS"
> >> command to the object server.
> >>
> >> Any tips?
> >>
> >>
> >>
> >> Ed
> >> -----------------------------------------
> >> Use of email is inherently insecure. Confidential information,
> >> including account information, and personally identifiable
> >> information, should not be transmitted via email, or email 
attachment.
> >
> >> In no event shall Citizens or any of its affiliates accept any
> >> responsibility for the loss, use or misuse of any information
> >> including confidential information, which is sent to Citizens or its
> >> affiliates via email, or email attachment. Citizens does not 
guarantee
> >
> >> the accuracy of any email or email attachment, that an email will be
> >> received by Citizens or that Citizens will respond to any email.
> >>
> >> This email message is confidential and/or privileged. It is to be 
used
> >
> >> by the intended recipient only.  Use of the information contained in
> >> this email by anyone other than the intended recipient is strictly
> >> prohibited. If you have received this message in error, please notify
> >> the sender immediately and promptly destroy any record of this email.
> >>
> >>
> >> _______________________________________________
> >> Sent by the netcoolusers.org "users" mailing list
> >> Post: users at netcoolusers.org
> >> Unsubscribe: users-unsubscribe at netcoolusers.org
> >> Search: http://netcoolusers.org/Search
> >>
> > _______________________________________________
> > Sent by the netcoolusers.org "users" mailing list
> > Post: users at netcoolusers.org
> > Unsubscribe: users-unsubscribe at netcoolusers.org
> > Search: http://netcoolusers.org/Search
> >
> > _______________________________________________
> > Sent by the netcoolusers.org "users" mailing list
> > Post: users at netcoolusers.org
> > Unsubscribe: users-unsubscribe at netcoolusers.org
> > Search: http://netcoolusers.org/Search
> >
> 
> 
> 
> _______________________________________________
> Sent by the netcoolusers.org "users" mailing list
> Post: users at netcoolusers.org
> Unsubscribe: users-unsubscribe at netcoolusers.org
> Search: http://netcoolusers.org/Search

Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU

_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://netcoolusers.org/Search

ForwardSourceID:NT0006B332 