OleDbConnection.Provider for Sybase

Posted on 2007-08-01
Last Modified: 2010-04-15
What would the OleDbConnection.Provider value be to make a connection to a Sybase data server?

Question by:jkavx
    LVL 142

    Accepted Solution


    Author Comment

    Thx.  Looking into this, I don't see any OleDb drivers on the desktops where the dll will be demo'd, so I may have to switch to using an OdbcConnection.  I want to build this so that it can connect to either SqlServer or Sybase databases.  The code will be executing stored procs that retreive data sets and do inserts/updates/deletes.  The result sets will be mapped immediately to objects; the transactions are lightweight and don't involve any open data sets.  

    Is there any reason not to use the OdbcConnection instead of the OleDbConnection?


    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    when the job is run stored procedures only, there is no apparent reason.

    Author Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 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

    9 Experts available now in Live!

    Get 1:1 Help Now