Alternatives to ODBC

25 pts.
Tags:
Database connectivity
ODBC
SQL
Our db group wants to remove ODBC access. My application relies on ODBC to get data. What are the alternatives?
ASKED: April 15, 2008  7:52 PM
UPDATED: April 17, 2008  1:07 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

This depends on the tool/language you’re developing with (VB6, .NET, Access, etc.). Some tools cannot work with any connectivity type.

For example, if you are using .NET, it might be better to use .NET Provider or OLEDB.

Here is an article explaining the differences between OLEDB and ODBC:
<ul>

http://www.ibprovider.com/eng/documentation/firebird_interbase_odbc_drivers.html</ul>

And an old article describing the methods to connect to SQL Server:
<ul>

http://www.sommarskog.se/mssqlperl/alternatives.html</ul>

Hope this helps.
Michelle.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Brooklynegg
    Ask them what the alternatives. I would guess they want you to use SOAP.
    3,845 pointsBadges:
    report
  • Chany
    Hello Brooklynegg - Thank u first of all. I will look into SOAP. The group has suggested a DATAMART or a CRF type file. I don't think either would be realistic because we need more of a real time answer. Does that make sense? I would like to continue with our discussion if possible after I look into SOAP. Thank you again.
    25 pointsBadges:
    report
  • Chany
    Thank you Michelle.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following