My Question:
Since we have a lot of calls to OpenRecordest in our application, that do
not assign these parameters explicitly, I would like to know if there's a way
(maybe through the registry or server configuration) to change this default
behavior on ODBC to match the one of a Jet linked table.
And...:
If you know of some wizard that can change my code automatically, or any
other way to solve this problem, I would also be happy to hear about it.
And...:
If you know about other problems that might arise from changing the
connection to an ODBC I would be happy to know about (I don't mean problems
regarding the data transformation into the sql server, but problems like the
one I mentioned which are discovered after the upsizing was completed, the
guides I used:
http://www.microsoft.com/technet/prodtechnol/sql/2000/Deploy/accessmigration.mspx
and http://www.azteccomputing.com/docs/Upsize.pdf didn't warn about that
problem explicitly)