I spent 7 days trying install dbAnywhere under Windows-95 and JDK (Java Development Kit) 1.0.2 and another afternoon redoing it for JDK 1.1.3 and about an hour for database development edition. In the interest of saving you a little time, here are the magic incantations I discovered. I can’t guarantee all these steps are necessary, but they are sufficient. These instructions were written for the version of dbAnywhere that comes with Visual Café Database Development Edition 2.5a.
Unfortunatey dbAnywhere has been discontinued. Visual Cafe now uses the standard less intelligent JDBC interface.
C:\sqlany\win32\dbinit.exe -p1024 mydatabase.dbNone of the documented Sybase techniques for creating a database work:
start "sqlany" dbeng50.exe C:\MyDir\mydatabase.db -b -c 17000For Win95 you start the database engine like this:
CREATE TABLE PEOPLE | |
(ACCT | integer NOT NULL, |
SURNAME | char(30) NOT NULL, |
GIVEN_NAME | char(30) NOT NULL, |
CITY | char(18), |
PROV | char(2), |
POSTAL | char(6), |
PRIMARY KEY (ACCT)); |
SELECT table_name from SYS.SYSTABLE
LOAD TABLE PEOPLE FROM 'C:\MyOld\PEOPLE.LOD';You can then check that the data actually loaded with statements like this:
SELECT COUNT(*) FROM PEOPLE;or
SELECT * FROM PEOPLE;
In a simple case, here is how Symantec’s proprietary dbAnywhere/SQL interface works. The interface is quite a bit more advanced than JDBC or JSQL (Java Standard Query Language). There is considerable detailed documentation, but no overview of how it all fits together.
The component itself is no longer responsible for notifying dbAnywhere when the value changes or even of tracking if the screen value has changed via keystroke activity. dbAnywhere will invoke theComponent.getData or setData when it wants to using the ProjectionBeanHelper object which has a pointer to the component itself. This is quite a simplication for dbAware components over JDK 1.0.2.
This page is posted |
http://mindprod.com/jgloss/dbanywhere.html | |
Optional Replicator mirror
|
J:\mindprod\jgloss\dbanywhere.html | |
Please read the feedback from other visitors,
or send your own feedback about the site. Contact Roedy. Please feel free to link to this page without explicit permission. | ||
Canadian
Mind
Products
IP:[65.110.21.43] Your face IP:[18.97.14.80] |
| |
Feedback |
You are visitor number | |