ADO Connecting to SyBase

[blweb]

I am developing a program that connects to Sybase. Is there a certain driver that I need to allos the connection?

My ODBC connection tells me there is no default driver.

g_sConnStg = "DRIVER={SYBASE ASE ODBC Driver};DB=master;UID=sa;PWD=;NetworkAddress=BWSYB,5000;"


Set PROJ_DB = New ADODB.Connection
With PROJ_DB
.ConnectionString = g_sConnStg
.Open
End With


My OLE DB connection gives me either a 3706 Provider error or '-2147467259 (80004005)': Unspecified error.

g_sConnStg = "Provider=Sybase.ASEOLEDBProvider;" _
& "Server Name=67.66.242.159,5000;" _
& "User Id=sa;" _
& "Password=;"


Set PROJ_DB = New ADODB.Connection
With PROJ_DB
.ConnectionString = g_sConnStg
.Open
End With


Is there a microsoft driver that can allow me to connect to Sybase?

Brian

 

[Swi]

Check out these links for connection string examples. They may be of some help:

http://www.able-consulting.com/ADO_Conn.htm

http://www.connectionstrings.com/

Swi

 

[blweb]

Swi,

Thanks for the response.

I modeled the connection strings above from

http://www.connectionstrings.com

giving me the results above. I found it as a great resource, but no luck. As for

http://www.able-consulting.com/ADO_Conn.htm,

it says that I need to create an .IDS file. Only problem is that it doesn't give any directions on how to do so and the link they give for the directions goes to another page that says the exact same thing with a broken link to Sybase.

My question is if there is a Microsoft Driver I can use as a work around to get a connection into a Sybase database.
I feel it would be most benefitial to be able to travel that routh if possible.

Brian