Recent content by paulb@ccs.nl

Use the locksettings in your DSN settings (odbc driver settings). Use READ_UNCOMMITTED to ensure you wil use no locks.

There is no need for expensive hardware for an 50-user/10GB database configuration on a Windows server. A dual processor is fine, but an single will also do the job. Whe have installed lots of this configurations without any problem. Direct Attached Storage with fast disks in RAID-1 or RAID-10...

Did you use the 32 bit admin tool ODBCAD32.EXE to create the DSN? Shortcut ODBC Datasource in the Administrative Tools menu is the administration program for 64-bits DSN's. Mention the difference between 64-bit (HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI) and 32-bit ODBC drivers...

Which operating system are you using? On Windows server you will pass the maximum count of processes. I guess it won't work, otherwise you will see poor performance. The maximum count of databases on a Windows server is 100. Above 100 you will see too much disk-access and too much processes...

The easiest way to migrate your database is binary dumping and loading your database. If you plan to dump and load in v9, you can't use type II storage. The better way is to first migrate your old database to v10, and then perform the dump and load. Follow these steps: On your old database...

You can not use an 32-bit ODBC driver from an 64-bit application.

Incremental for Oracle Hello Thomas, I readed your message from july 02 about converting .df files to .sql files for an Oracle DB. We have exactly the same problem, we have build an tool for that conversion by ourself. However, it creates and copy tables instead of adding, renaming or...