D
Dr. Network
A little background: I'm responsible for an application that distributes
default data for an application that my company produces. I'm testing this
default data application on Vista (build 5728). The application uses an SQL
Anywhere USER ODBC DSN to connect to a local copy of a SQL Anywhere database
in a folder in a Program Files sub-directory. The SQL Anywhere database is
versioned by a table called DATABASE_LEVEL in the file. My latest version is
2.6.0.263. I'm trying to test an earlier version 2.5.2.261. The application
has an InstallShield 10.5 installer that installs and uninstalls the
application. I uninstall the 2.6.0.263 version and the reference DB
disappears along with the sub-directory. I then install the 2.5.2.261
version. However, when I start the application, it reads a version of
2.6.0.263. Even if I delete the reference DB folder with the reference DB
the application still reads the 2.6.0.263 version. I have the source code
(in PowerBuilder) and I know that it is supposed to read this reference DB
to get the version number. I've traced the code back. Logically, there
should be no way that it is reading the 2.6.0.263 version number when the
2.5.2.261 version is installed or when it is manually deleted.
A few more facts:
1. When I look at the 2.5.2.261 reference database using a table viewer
(Embercadero's Rapid SQL), the version number is 2.5.2.261.
2. When I install the 2.5.2.261 in a different sub-directory structure than
the default where I normally install it, the application starts with the
2.5.2.261 version.
3. The SQL Anywhere 2.6.0.263 database file has a later date stamp than the
2.5.2.261 database file.
4. I copy the 2.5.2.261 database file to a different location. I manually
point the ODBC DSN to this second copy. The application starts and the
reference version is 2.5.2.261, not 2.6.0.263.
5. When I right click the 2.5.2.261 database file in the original location,
I can click an option called "Restore previous version". In the Previous
Versions tab, I can see the 2.6.0.263 version.
It appears that the OS is caching the 2.6.0.263 database file and using it.
It certainly appears this way based on the fact that when I totally delete
(not just recycle bin) the file, it still "finds" it and displays the later
version number.
Chuck
default data for an application that my company produces. I'm testing this
default data application on Vista (build 5728). The application uses an SQL
Anywhere USER ODBC DSN to connect to a local copy of a SQL Anywhere database
in a folder in a Program Files sub-directory. The SQL Anywhere database is
versioned by a table called DATABASE_LEVEL in the file. My latest version is
2.6.0.263. I'm trying to test an earlier version 2.5.2.261. The application
has an InstallShield 10.5 installer that installs and uninstalls the
application. I uninstall the 2.6.0.263 version and the reference DB
disappears along with the sub-directory. I then install the 2.5.2.261
version. However, when I start the application, it reads a version of
2.6.0.263. Even if I delete the reference DB folder with the reference DB
the application still reads the 2.6.0.263 version. I have the source code
(in PowerBuilder) and I know that it is supposed to read this reference DB
to get the version number. I've traced the code back. Logically, there
should be no way that it is reading the 2.6.0.263 version number when the
2.5.2.261 version is installed or when it is manually deleted.
A few more facts:
1. When I look at the 2.5.2.261 reference database using a table viewer
(Embercadero's Rapid SQL), the version number is 2.5.2.261.
2. When I install the 2.5.2.261 in a different sub-directory structure than
the default where I normally install it, the application starts with the
2.5.2.261 version.
3. The SQL Anywhere 2.6.0.263 database file has a later date stamp than the
2.5.2.261 database file.
4. I copy the 2.5.2.261 database file to a different location. I manually
point the ODBC DSN to this second copy. The application starts and the
reference version is 2.5.2.261, not 2.6.0.263.
5. When I right click the 2.5.2.261 database file in the original location,
I can click an option called "Restore previous version". In the Previous
Versions tab, I can see the 2.6.0.263 version.
It appears that the OS is caching the 2.6.0.263 database file and using it.
It certainly appears this way based on the fact that when I totally delete
(not just recycle bin) the file, it still "finds" it and displays the later
version number.
Chuck