[RESOLVED] Connecting to a SQLBase DB using VB6

hey

can someone give me a hand with a SQLBase connection string in VB6

cant seem to perform a connection for some unknown reason

thank you

regards

www.connectionstrings.com

Or http://www.carlprothman.net/Default.aspx?tabid=81.

VB Code:

oConn.Open "Provider=SQLBaseOLEDB;" & _
           "Data source=mySybaseServer;" & _
           "Location=mySybaseDB;" & _
           "User Id=myUserName;" & _
           "Password=myUserPassword"

10x for rating the posts ;)

Quote:

---

Originally Posted by BestS

www.connectionstrings.com

---

Cool link BestS! :thumb:

Quote:

---

Originally Posted by PilgrimPete

Or http://www.carlprothman.net/Default.aspx?tabid=81.

VB Code:

oConn.Open "Provider=SQLBaseOLEDB;" & _
           "Data source=mySybaseServer;" & _
           "Location=mySybaseDB;" & _
           "User Id=myUserName;" & _
           "Password=myUserPassword"

---

hey mate

if the data source is on another machine and not on my machine would i just put the server name or do i have to point to the path of the sql base engine???

thanx

hey can someone please help me and answer my question.....

thank you