Hi all,
We've got alot of legacy code and have been doing a major upgrade to our production system, and realzed that we may have to change possibly thousands of lines of code, and of course we're looking for a short cut. The newer ODBC Database we are using has the version 3 ODBC, while the older system has the version 2 ODBC. This machine is production and there is never any development on it or any planned in the future, we are upgrading the system due to being too far behind the current hardware/software versions for support by the vendor.
In C++ there is a function:
SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION, (void*) SQL_OV_ODBC2,SQL_IS_INTEGER);
Basically this statement tells the ODBC Driver manager to map the calls to an ODBC3 driver but exhibit ODBC2 behavior. This allows full backward comptability to older calls that may no longer be "supported" by the newer driver. Is there a similar way to do this in Access/VB?
Doing this would prevent many tedious code changes (it did with our C processes), any help would be greatly appreciated.
We've got alot of legacy code and have been doing a major upgrade to our production system, and realzed that we may have to change possibly thousands of lines of code, and of course we're looking for a short cut. The newer ODBC Database we are using has the version 3 ODBC, while the older system has the version 2 ODBC. This machine is production and there is never any development on it or any planned in the future, we are upgrading the system due to being too far behind the current hardware/software versions for support by the vendor.
In C++ there is a function:
SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION, (void*) SQL_OV_ODBC2,SQL_IS_INTEGER);
Basically this statement tells the ODBC Driver manager to map the calls to an ODBC3 driver but exhibit ODBC2 behavior. This allows full backward comptability to older calls that may no longer be "supported" by the newer driver. Is there a similar way to do this in Access/VB?
Doing this would prevent many tedious code changes (it did with our C processes), any help would be greatly appreciated.
