Sybase Error

Posted on 2009-02-12
Last Modified: 2012-05-06
Getting a "catastrophic failure" when trying to connect to a Sybase 11 database via ADO in ASP webpage. I'm able to query the db from within Sql Advantage. I've tried both DSN and DSNless connection strings.  This code worked on the previous server, both servers are Win2003 with IIS 6.0.
Any assistance would be appreciated.
'DSN Connection

'set objConn = Server.CreateObject("ADODB.Connection")

' "DSN=SERVER;UID=userid;Pwd=password"

'DSNless connection

set objConn = Server.CreateObject("ADODB.Connection") "Driver={SYBASE SYSTEM 11};Srvr=SERVER;Uid=userid;Pwd=password"

Open in new window

Question by:kevbob650
    LVL 28

    Accepted Solution

    Did you check for a connectionstring at ?
    Do you have the right drivers installed?

    Author Closing Comment

    I got it, I loaded new drivers and I'm up and running. Still rather fussy but it's getting there, still some occasional buflen = cs_unused

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    This is pretty cool.  The purpose of this VB Script is to help you document where JAR (Java ARchive) files and specifically java class files are located so that you can address issues seen with a client or that you can speak intelligently with a dev…
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now