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;" & _
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.