from DAO to ODBC

[rachelalfonso]

I need to migrate an application that relies on DAO data sources to use ODBC data sources. I will need to eradicate my Access MDBs and completely migrate to SQL server. This conversion should be permanent, and I do not know how to get started.
would this mean several changes in the source code (in the creation of databases and tables and in my query strings)?

any idea is appreciated.

thanx,
rachel

 

[Cagliostro]

In ODCB you'll have to write much more routines. But the logic is the same. John Fill

http://ournet.md/~ifilipski/1c.bmp

ivfmd@mail.md

 

[Karl Blessing]

you might want to try moving from DAO to ADO if you are wanting to move into ODBC (ADO still uses the ODBC drivers, but much easier to work with than raw ODBC) , check out the FAQ I belive I posted here, on basically how to get ADO going in VC++, and you can probally take it from there pretty easy. Karl Blessing aka kb244{fastHACK}

 

[cibrran]

It's so easy to manipulate!