How can it be working??
843853Jun 15 2001 — edited Jun 18 2001(This is a re-post of a sub-topic that came up in a previous topic)
Does anybody know how this could be working, apparently without a database engine?
In the ODBC Data Source Administrator (in the Control Panel) I have a data source called (by reason of copying an example off the internet) magedb. The driver is "Microsoft dBase Driver (*.dbf)". In the java prog, I (with tries and catches added) do:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:magedb";
revGrpConnection = DriverManager.getConnection(url,"","");
and then go on to:
stmt=revGrpConnection.createStatement();
stmt.execute("CREATE table filename (frgNumber integer, frgDesc string);");
I can then INSERT and SELECT fine, but exactly how, I don't know - I was kind of assuming that ODBC was simulating a dbase database somehow - I've just done a search of my machine and the only dbase files are dbase.sql.dbx and a file called dBase Files (not shareable).dsn. There are, however, quite a lot of db*.* files, including dll's and various others. So how is it working? Is it spooky that it seems to work with no database engine?
(And why doesn't it work better, ie with DELETE I get "Could not delete from specified tables."?)
Thanks again,
Graham Rounce
PS: Can anyone recommend a book (or link) that deals particularly with all this?