Thanks Philip, I thought that might be the case.

Hi all,

Thanks for your comments. It is good to hear how other organisations/people handle the SDLC in the database world.

I received an email recently about a new MS product,...

Hi Antares, yes I have read that ini files can be used and is something I am considering, however I run both dev, test and prod packages from my local machine....

I downloaded the new driver (released last week) and have found that the 3103 RDB driver resolved my issue. I just needed to remove the existing driver (3102), remove all existing...

I have just tried connecting to the database using Access and get the following error - 'ODBC--call failed'. [Oracle][ODBC][Rdb]%RDB-F-BAD_DB_HANDLE, invalid database handle (#-1)'

This is a little more helpful. I have since read the...

Hmmm.. you have got me thinking. I am trying to workout where the permissions come into effect.

We have one account (oracle) eg joeblogs/mypass that is used in the DSN entry on all...

I can run it as both, providing it is on the server that functions correctly with the driver (eg. Win 2000 server but not Win 2003 server).