Created By
DMG Development
As Seen On

Main Page  |  Forums  |  Register  |  Active Topics  |  Members  |  Search

 
Username:
Password:
DMG Forums >> DMG Forums Discussion >> General Discussion >> Option to not use ODBC for connecting to MS SQL
Option to not use ODBC for connecting to MS SQL
Author Topic
evandixon


Newbie


Join Date: 3/18/2009
Posts: 5
Location: Far Away, to keep it simple.

Posted: 3/3/2010 4:11:20 PM

I recently switched hosts.
My new host is much cheaper than my old one, but restricts access to ODBC.
On my old host, your forum system was very stable and easy to use.
Could you add an option to not use ODBC?

-evandixon
grimmeissen


Administrator


Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio

Posted: 5/11/2010 12:34:35 PM

ODBC was chosen for its expandability. It's not necessarily the best connector, but it works on a lot of DB platforms and has numerous plugins in .NET.

However, it wouldn't be too difficult to change to something like OleDB. All you would need to do would be to change the Database class in Global.vb to use OleDb classes instead of ODBC and then search/replace any references in the rest of the code from OdbcDataReader to OleDbDataReader.

  Copyright DMG Development DMG Forums 3.2