• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

Connecting to Sybase via ODBC

Hi,

I am trying to do an ODBC connection to a sybase database. The Sybase is setup on site and the BDE administrator shows the DSN and I can do a test connection to it. Unfortunately I have never connected to Sybase before so have been pulling hair out all day. Suffice to say that, after trying I don't know how many attempts with workspaces, connections and other things I am now hanging my head and going to ask if anyone can help me with this.

I have been given the DSN, UID, Password and DB-Servername for the Sybase but I don't know if the reason for me not connecting has to do with me just writing an incorrect connection string or just using the totally wrong tools.

Many thanks,
0
icontroldev
Asked:
icontroldev
2 Solutions
 
leonstrykerCommented:
Here are a few tutorials for using ADO:

http://www.timesheetsmts.com/adotutorial.htm
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=12050&lngWId=1

I would use this connection string if possible:

http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSybaseAdaptiveServerEnterprise

If this does not work then use the one above from Shauli.

Leon
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now