migrate to different DBMS using ODBC?
-
Hello! I am developing a database program using Access DB.. Now im using MFC ODBC classes to connect to Access.. Now at some point, i need to connect to a MS SQL Server DB Can I do it with little code change or no code change, recompilation at all? Do I just supply a different driver/connection string and thats it!?!? Im just trying to clarify since ODBC is supposed to do that.. Haven't installed a SQL Server on a PC yet, but i wanna know in advance how ODBC really works...
-
Hello! I am developing a database program using Access DB.. Now im using MFC ODBC classes to connect to Access.. Now at some point, i need to connect to a MS SQL Server DB Can I do it with little code change or no code change, recompilation at all? Do I just supply a different driver/connection string and thats it!?!? Im just trying to clarify since ODBC is supposed to do that.. Haven't installed a SQL Server on a PC yet, but i wanna know in advance how ODBC really works...
The only think that you'd have to do is to install the ODBC implementation for SQL Server (usually comes with SQL Server installation), create the new DSN and change the connection string. Depending on the versions of the DBMS you'd have to take care of the SQL implementation that they use because some statements couldn't be supported: transactions, ... but I don't think you'll have these kind of problems migrating from Access to SQL Server (on the other way probably). Marc Soleda. ... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.
-
Hello! I am developing a database program using Access DB.. Now im using MFC ODBC classes to connect to Access.. Now at some point, i need to connect to a MS SQL Server DB Can I do it with little code change or no code change, recompilation at all? Do I just supply a different driver/connection string and thats it!?!? Im just trying to clarify since ODBC is supposed to do that.. Haven't installed a SQL Server on a PC yet, but i wanna know in advance how ODBC really works...
Click on the link below to 'My Articles' and check out my QuickQuery project. I'm using ODBC, and so far, it's worked with every type of database I've had on my system. It may not be exactly what you want (I think it was the first or second program I ever made in C++), but I hope it can help you in some way. My articles www.stillwaterexpress.com BlackDice