Which API to use ???

[glaeve]

Excuse for my english (I'm french ...)

I would like to connect a Sybase database without using ODBC!
What's the name of the API to use?

Thanks in advance...
glaeve

 

[Slugmaster]

I too would like to know this. I posted a similar question last week, but I still do not have any responses. If you find something, I would like to know.

 

[glaeve]

I heard about JConnect, Open Client, Ôpen Server,MainFrameConnect, ...
But what's the difference between them ???

Glaeve

 

[glaeve]

Hi Slugmaster !
These links refer the manual pages about Open Client et Open Server. It seems to be that library that we have to use...

Open Client/Server : Liste des manuel associés ->

http://manuals.sybase.com/onlinebooks/group-cn/cng1000e/@Generic__CollectionView;pt=cng1110e;lang=fr

Open Client-Library/C Programmer's Guide ->

http://manuals.sybase.com/onlinebooks/group-cn/cng1000e/prgguide/@Generic__BookView;lang=fr

Open Server-Library/C Reference Manual ->

http://manuals.sybase.com/onlineboo...795;lang=fr?target=%N_10556_START_RESTART_N%

Open Client-Library/C Reference Manual ->

http://manuals.sybase.com/onlinebooks/group-cn/cng1000e/ref/@Generic__BookView;lang=fr

-> Exemple présentant une connexion à un serveur et émission d'une requête SQL
Open Client DB-Library/C Reference Manual ->

http://manuals.sybase.com/onlinebooks/group-cn/cng1000e/dblib/@Generic__BookView;lang=fr

Open Client/Server quick Reference Guide ->

http://manuals.sybase.com/onlinebooks/group-cn/cng1000e/quick/@Generic__BookView;lang=fr

open Server Server-Library/C Reference Manual ->

http://manuals.sybase.com/onlinebooks/group-cn/cng1000e/srvrlib/@Generic__BookView;lang=fr

 

[rarubio1]

I know it has been almost a year since you posted this message. I find the easiest way to connect to a pervasive database is through ADO. I hope the following will be of some help:

'Connection Declaration
Dim cnConnection As ADODB.Connection

'Set Connection String
Public Function cnConnect()
Set cnConnection = New ADODB.Connection
With cnConnection
.Provider = "PervasiveOLEDB"
.CursorLocation = adUseClient
.Mode = adModeReadWrite
.Open "C:\FilePath"
End With
End Function


GOOD LUCK!!!
rarubio1