[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

OleDbConnection.Provider for Sybase

What would the OleDbConnection.Provider value be to make a connection to a Sybase data server?

jkavx
0
jkavx
Asked:
jkavx
  • 2
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
jkavxAuthor Commented:
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?

jkavx

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
when the job is run stored procedures only, there is no apparent reason.
0
 
jkavxAuthor Commented:
Thx.
0

Featured Post

Industry Leaders: 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!

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