ASE Database forum - Intersolv 3.01 & VB6

Author

Intersolv 3.01 & VB6

Antonio del Valle

2005-04-09, 8:26 pm

Hello everyone, this is my first post in this newsgroup I
hope have posted this in the correct one. Heres my
situation.

We have the intersolv 3.01.0004 driver installed and I want
to make a connection with the remote server via Visual Basic
6 using ADO, but I cant find the correct Connection string
for this, I have ran into the string for the 3.10 version
though, here it is:

conConnection.Open "Driver={INTERSOLV 3.10 32-BIT Sybase};"
& _
"Srvr=server-pruebas;" & _
"Uid=sa;" & _
"Pwd="

But this wont work with the 3.01 version, can you point me
to a useful site or perhaps make a suggestion?

Cheers

Muralidharan

2005-04-10, 7:23 am

Since this is related to client side utility ( ie ODBC Driver ),
you may get useful responses if you post to
sybase.public.connectivity.odbc newsgroup.

<Antonio del Valle> wrote in message
news:42570155.19f2.1681692777@sybase.com...
> Hello everyone, this is my first post in this newsgroup I
> hope have posted this in the correct one. Heres my
> situation.
>
> We have the intersolv 3.01.0004 driver installed and I want
> to make a connection with the remote server via Visual Basic
> 6 using ADO, but I cant find the correct Connection string
> for this, I have ran into the string for the 3.10 version
> though, here it is:
>
> conConnection.Open "Driver={INTERSOLV 3.10 32-BIT Sybase};"
> & _
> "Srvr=server-pruebas;" & _
> "Uid=sa;" & _
> "Pwd="
>
> But this wont work with the 3.01 version, can you point me
> to a useful site or perhaps make a suggestion?
>
> Cheers

Paul

2005-04-11, 8:25 pm

Hi Antonio,

Post odbc questions to the sybase.public.connectivity.odbc newsgroup in the
future

For this - this driver is way out of date, EOL, and may not work to well
with VB/ADO. The 3.01 driver is ODBC 3.0 compliant, but was an early
version. Since then VB/ADO now works with ODBC 3.51 API level and you might
run into problems.

As for this problem you have not posted any error messages, or odbc trace or
anything that might provide a clue as to the problem with connecting. For
one thing make sure on the same machine that the Open Client is installed
properly (Use ISQL to confirm that you can connect to "server-pruebas").

Lastly, you should upgrade ODBC to the 12.5.1 level. Since you indicate
"INTERSOLV" in the product name this means you are not using any Sybase ASE
ODBC Driver from any Sybase distribution that I know of. However, if you
have ASE 12.5.X you should have a cdrom for the pc client that will contain
the new driver. If you are getting this from some other means that could
be a problem.

pv

<Antonio del Valle> wrote in message
news:42570155.19f2.1681692777@sybase.com...
> Hello everyone, this is my first post in this newsgroup I
> hope have posted this in the correct one. Heres my
> situation.
>
> We have the intersolv 3.01.0004 driver installed and I want
> to make a connection with the remote server via Visual Basic
> 6 using ADO, but I cant find the correct Connection string
> for this, I have ran into the string for the 3.10 version
> though, here it is:
>
> conConnection.Open "Driver={INTERSOLV 3.10 32-BIT Sybase};"
> & _
> "Srvr=server-pruebas;" & _
> "Uid=sa;" & _
> "Pwd="
>
> But this wont work with the 3.01 version, can you point me
> to a useful site or perhaps make a suggestion?
>
> Cheers

Sponsored Links