|
|
|
Software Central: MS Access | | How to write common code for MS Access and SQL Server? | |
| use ODBC specific code. And switch the datasource name(DSN) when you want to switch between Access/MySQL.
ODBC drivers will take care of converting your SQL from being complaint with the database system, you are going to run it on.
this works for any database system registered with ODBC/or has a ODBC driver.
Posted by: Mr. Suneel Kumar Kanuri At: 14, Oct 2004 3:23:46 AM IST
Can you guys suggest me ideas how to write common code for MS Access and Sql Server?
I mean, the code should not be changed if I change the database in future.
One thing I know is date. Access uses # as date delimiter. And sql server uses single quote, just like text string.
Are there any other considerations?
Posted by: Mr Suresh KVS At: 13, Sep 2004 8:47:39 PM IST
| |
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
