Connecting with Visual Basic 6.0

I installed the Sybase Client 12.X and I'm trying to connect with VB6.0.  The current login string that I'm using is as followed:

strLogin = "Provider=Sybase ASE OLE DB Provider;" & _
"Srvr=Server,5000;" & _
"Catalog=DB;" & _
"User Id=user;" & _
"Password=pass"

But I keep getting "Invalid server name was specified."  I determined that it's coming from the Provider, it has to be because every other command that I remove comes down to the Provider generating it.  I've been having so much difficulty finding a good Sybase driver, without breaking my neck looking all over the country side.  I am wondering, maybe if the drivers that came with WinSQL would work if called apon?  I have tried it, but I got some odd error, that I was not sure about.

Please, I must get this working ASAP.
moorer2kAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

leonstrykerCommented:
I think the problem you are having is due to the fact that your server is named "Server". Other then that it looks fine to me. (http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSybaseAdaptiveServerEnterprise)

Leon

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
moorer2kAuthor Commented:
The server of course, is change correctly.  WinSQL tool connects ust fine, and I'm using those same perameters.
leonstrykerCommented:
>The server of course, is change correctly

I am not sure what you mean here.

> WinSQL tool connects ust fine, and I'm using those same perameters.

Maybe so, but the driver you are using with the VB app may not be ok with it, especially if it is a reserved keyword.
rabijCommented:
Go to this website to get the correct connection string: http://www.connectionstrings.com/ you'll be able to find what you need to connect to sybase
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.