Alternatives to ODBC
ODBC, SQL, Database connectivity
Our db group wants to remove ODBC access. My application relies on ODBC to get data. What are the alternatives? Question
ODBC, SQL, Database connectivity
Our db group wants to remove ODBC access. My application relies on ODBC to get data. What are the alternatives? 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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:
http://www.ibprovider.com/eng/documentation/firebird_interbase_odbc_drivers.html
And an old article describing the methods to connect to SQL Server:
http://www.sommarskog.se/mssqlperl/alternatives.html
Hope this helps.
Michelle.
Browse more Questions and Answers on Database and Development.
Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
Brooklynegg | Apr 16 2008 1:25PM GMT
Ask them what the alternatives.
I would guess they want you to use SOAP.
Chany | Apr 16 2008 3:14PM GMT
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.
