Connecting to Sybase  using Sybase ASE Provider

Posted on 2007-07-24
Last Modified: 2009-07-29
I need a connection global module in VB 6 so that I can use it for connection to sybase from any function or program using ASE provider.

so in my function I want to just use the modules method and connect .
Question by:Joserip
    LVL 53

    Accepted Solution

    ODBC Driver for Sybase
    If using the Sybase System 12 (or 12.5) Enterprise Open Client ODBC Driver

    oConn.Open "Driver={SYBASE ASE ODBC Driver};" & _
               "Srvr=myServerName;" & _
               "Uid=myUsername;" & _
    If using the Sybase System 11 ODBC Driver

    oConn.Open "Driver={SYBASE SYSTEM 11};" & _
               "Srvr=myServerName;" & _
               "Uid=myUsername;" & _
    If using the Intersolv 3.10 Sybase ODBC Driver

    oConn.Open "Driver={INTERSOLV 3.10 32-BIT Sybase};" & _
               "Srvr=myServerName;" & _
               "Uid=myUsername;" & _
    For more information, see: Sybase System 10 ODBC Driver Reference Guide;pt=622?target=%25N%14_1044_START_RESTART_N%25

    To view Microsoft KB articles related to ODBC Driver for Sybase,
    LVL 53

    Expert Comment

    Recommendations: answered by dhaest
    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Training Course: Java/J2EE and SOA

    This course will cover both core and advanced Java concepts like Database connectivity, Threads, Exception Handling, Collections, JSP, Servlets, XMLHandling, and more. You'll also learn various Java frameworks like Hibernate and Spring.

    There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
    When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now