connecting to Sybase SQL Anywhere from VB

[sdh]

Has any body within this forium had any experience of connecting to sybase sql anywhere. My boss has just challenged me to connect to a sybase database used on our machines by a commercial software package we are using. |Bit of a new one to me I have no odbc drivers or anything. Can somebody point me in the right direction for drivers etc and help with an ado connection string?
It would be much appreciated.
Many thanks
sdh :

 

[100watt]

if you are using "Adaptive Server Anywhere 8" with vb6 then you can use the following piece of code.

Private Sub GetConnection()
    
    Dim cnGolf As ADODB.Connection
    Dim rsRec As ADODB.Recordset

    Set cnGolf = New ADODB.Connection
    cnGolf.Provider = "ASAProv"
    cnGolf.ConnectionString = _
      "Data Source=CartManager"
    cnGolf.Open
    
End Sub
[Code]

Comments:

ASAProv - the provider which is installed with "Adaptive Server Anywhere 8"
CartManager - name of the ODBC driver

PS. May work with other versions of VB and Sybase

 

[100watt]

I just found a way to connect to a sybase database without using the ODBC. I don't entirely understand why this works but you could try the following piece of code to connect.
You will still need a provider for this connection.

Private Sub GetConnection()
Dim cnGolf As ADODB.Connection
Set cnGolf = New ADODB.Connection
cnGolf.Provider = "ASAProv"
cnGolf.ConnectionString = "uid=dba;pwd=sql;dbf" & _ App.Path & "\CartManager.db"
cnGolf.Open
End Sub