Sybase Open Client 12.5.1 on Windows Server 2003, x64

[c***@comcast.net]

Hi. I'm working with OC 12.5.1 on Win2k3, x64. When I log into my
application and the open client is invoked, I get an error: "Unable
to connect to the MDI gateway....sqldbcode is 999 Unable to
initialize client library context" I haven't been able to resolve
this one. Any help would be great. Thanks.

[Neal Stack]

Hello,

Are you able to run the dsedit utility on the x64 server
and choose the option to "ping" a server? If not, do
you get a different error?

Are you able to run the ISQL utility directly x64 utility
and connect to the target server? Does it get a different
error?

From a DOS Command prompt, can you type "set > env.txt" and
post a listing of your environment variables?

Thanks,
Neal

[unknown]

Hi, Neal. Yes, I can open dsedit and ping a server - no
problem. Unfortunately, I don't have an account on the
target server, so I have to get someone else to run the isql
command for me. I'll let you know what happens. The
environment variables look ok, but I'll confirm. Also, I
don't have the net-library tab in oscfg like the 12.5 open
client did. Is that correct?

Post by Neal Stack
Hello,
Are you able to run the dsedit utility on the x64 server
and choose the option to "ping" a server? If not, do
you get a different error?
Are you able to run the ISQL utility directly x64 utility
and connect to the target server? Does it get a different
error?
From a DOS Command prompt, can you type "set > env.txt"
and post a listing of your environment variables?
Thanks,
Neal

[Neal Stack]

Hello,

That is correct, the newer ocscfg no longer has a
network driver tab.

I was hoping to have a look at your environment variables.
There are some variables like LANG and LC_ALL that can
cause problems that you might not be aware of.

Do you have multiple copies of Sybase installed on this PC?

I'm not familiar with MDI but does it have a way to set
which version of Sybase you are using?

Is MDI a 16bit application?

Thanks,
Neal

[Neal Stack]

Hello,

With 12.5.1 and higher, you really don't need to do
anything to configure the netlib stuff other than
make sure that the sql.ini has the correct host/port
and network protocol. If you are able to use the
dsedit "ping" function, that is a good indication
that things are configured correctly on the client
side.

In your other post you mention DirectConnect 12.6.
Is that the product raising the 999 error? Or is
there some product that uses Open Client that is
raising the error?

That error doesn't fall under the range of error numbers
that Open Client could raise. Doing a google search I
saw mention of PowerBuilder and some other products
possibly raising it when the version setting was
wrong (don't ask me how to configure PowerBuilder).

Paul who responded to your other post does some
DirectConnect support so he may have some other ideas
but it sounds like your basic Open Client is configured
correctly.

Your environment variables do look correct as well.

Ribo is a utility that is normally installed when you
do a "default" installation but if you did a custom
installation it is possible to choose not to install it.

Thanks,
Neal

[Paul]

Hi - I'm taking a wild guess here: Is this MDI gateway the OLD
MDI gateway that connects to the mainframe - to CICS and DB2, etc?
If so, what version? This is an old product and 2.03 didn't use open server
for connectivity and perhaps you're running into some compatibility problem.

Can you use the RIBO TDS utility to colect tds trace? Check in your sybase
folder under
jutils-2_0\ribo and check docs, etc. You might get more clues getting this
output and maybe posting here.

-Paul

Post by c***@comcast.net
Hi. I'm working with OC 12.5.1 on Win2k3, x64. When I log into my
application and the open client is invoked, I get an error: "Unable
to connect to the MDI gateway....sqldbcode is 999 Unable to
initialize client library context" I haven't been able to resolve
this one. Any help would be great. Thanks.

[unknown]

Hi, Paul. Yes, we are using MDI gateway to connect to the
mainframe. I think it's called DirectConnect 12.6. Does
that sound right? I couldn't find the directory
jutils-2_0\ribo under Sybase. Should it be there?

Post by Paul
Hi - I'm taking a wild guess here: Is this MDI gateway
the OLD MDI gateway that connects to the mainframe - to
CICS and DB2, etc? If so, what version? This is an old
product and 2.03 didn't use open server for connectivity
and perhaps you're running into some compatibility
problem.
Can you use the RIBO TDS utility to colect tds trace?
Check in your sybase folder under
jutils-2_0\ribo and check docs, etc. You might get more
clues getting this output and maybe posting here.
-Paul

... Hi. I'm working with OC 12.5.1 on Win2k3, x64.
When I log into my application and the open client is
invoked, I get an error: "Unable to connect to the MDI
gateway....sqldbcode is 999 Unable to initialize
client library context" I haven't been able to resolve
this one. Any help would be great. Thanks.

[Paul]

Hi

This error:

"Unable to connect to the MDI

Post by unknown

gateway....sqldbcode is 999 Unable to initialize
client library context"

Is it verbatum??? The MDI Gateway is not the DirectConnect. The
DirectConnect replaced the
MDI gw about 10 years ago.

Do you have some other system to connect to to make sure your client
environment
is setup OK?

-Paul

Post by unknown
Hi, Paul. Yes, we are using MDI gateway to connect to the
mainframe. I think it's called DirectConnect 12.6. Does
that sound right? I couldn't find the directory
jutils-2_0\ribo under Sybase. Should it be there?

Hi - I'm taking a wild guess here: Is this MDI gateway
the OLD MDI gateway that connects to the mainframe - to
CICS and DB2, etc? If so, what version? This is an old
product and 2.03 didn't use open server for connectivity
and perhaps you're running into some compatibility
problem.
Can you use the RIBO TDS utility to colect tds trace?
Check in your sybase folder under
jutils-2_0\ribo and check docs, etc. You might get more
clues getting this output and maybe posting here.
-Paul

... Hi. I'm working with OC 12.5.1 on Win2k3, x64.
When I log into my application and the open client is
invoked, I get an error: "Unable to connect to the MDI
gateway....sqldbcode is 999 Unable to initialize
client library context" I haven't been able to resolve
this one. Any help would be great. Thanks.

[unknown]

You guys have been a great help. I'm going to get the admin
for the gateway and see if he can respond. I don't know
that part of the system. Also, the application that is
trying to connect is a PowerBuilder application.

Hi
"Unable to connect to the MDI

Post by unknown

gateway....sqldbcode is 999 Unable to initialize
client library context"

Is it verbatum??? The MDI Gateway is not the
DirectConnect. The DirectConnect replaced the
MDI gw about 10 years ago.
Do you have some other system to connect to to make sure
your client environment
is setup OK?
-Paul

Post by unknown
Yes, we are using MDI gateway to connect to the
mainframe. I think it's called DirectConnect 12.6.
Does that sound right? I couldn't find the directory

jutils-2_0\ribo under Sybase. Should it be there? >

Post by unknown

Hi - I'm taking a wild guess here: Is this MDI gateway
the OLD MDI gateway that connects to the mainframe - to
CICS and DB2, etc? If so, what version? This is an old
product and 2.03 didn't use open server for

connectivity >> and perhaps you're running into some
compatibility >> problem.

Post by unknown

Can you use the RIBO TDS utility to colect tds trace?
Check in your sybase folder under
jutils-2_0\ribo and check docs, etc. You might get

more >> clues getting this output and maybe posting here.

Post by unknown

-Paul

... Hi. I'm working with OC 12.5.1 on Win2k3, x64.
When I log into my application and the open client is
invoked, I get an error: "Unable to connect to the

MDI >> > gateway....sqldbcode is 999 Unable to
initialize >> > client library context" I haven't been
able to resolve >> > this one. Any help would be great.
Thanks. >>

[Neal Stack]

Hello,

If I think you might be better off posting your question
to one of the PowerBuilder news groups like this one:
news://forums.sybase.com:119/sybase.public.powerbuilder.connectivity
or
news://forums.sybase.com:119/sybase.public.powerbuilder.general

When I search Google for "PowerBuilder 999 initialize client library context"
most of the hits suggest setting the "Release DBParm" or
"Database Profile" to the appropriate version.

Since I don't support PB, I don't exactly know where or
what these are and someone from a PB newsgroup would
probably be able to guide you.

Thanks,
Neal

[J]

On 26 Apr 2007 11:11:51 -0700, cswarr wrote:

The packaging switched around and now it it not distributed with the
SDK. Go to my.sybase.com->downloads->code sample and utilities->
jConnect 5.5/6.05 download jConnect 6.05 and Ribo will be in the
unzipped jutils-2_0 directory.

There should be documentation there. Basically you want to create a
new server in the sql.ini file that points to Ribo and then tell Ribo
to point to your MDI gateway.

I would not be surprised if the client tds level is too new for the
MDI Gateway.

Jay

Post by unknown
Hi, Paul. Yes, we are using MDI gateway to connect to the
mainframe. I think it's called DirectConnect 12.6. Does
that sound right? I couldn't find the directory
jutils-2_0\ribo under Sybase. Should it be there?

Post by Paul
Hi - I'm taking a wild guess here: Is this MDI gateway
the OLD MDI gateway that connects to the mainframe - to
CICS and DB2, etc? If so, what version? This is an old
product and 2.03 didn't use open server for connectivity
and perhaps you're running into some compatibility
problem.
Can you use the RIBO TDS utility to colect tds trace?
Check in your sybase folder under
jutils-2_0\ribo and check docs, etc. You might get more
clues getting this output and maybe posting here.
-Paul

... Hi. I'm working with OC 12.5.1 on Win2k3, x64.
When I log into my application and the open client is
invoked, I get an error: "Unable to connect to the MDI
gateway....sqldbcode is 999 Unable to initialize
client library context" I haven't been able to resolve
this one. Any help would be great. Thanks.