| Author |
 Topic  |
|
|
Zephyrus
Starting Member
7 Posts |
 Posted - 14 March 2003 : 04:22:35
|
Since we are able to use DSN as strConnString I have trouble understanding why it sholud not be possible to use Oracle just doing that.
If all creation of tables and all INSERT, UPDATE and DELETE are standard SQL we should be able to do it without any conversion of the .asp files.
But perhaps I am wrong ??
_______________
Zephyrus< |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 March 2003 : 06:43:11
|
Who said it's not possible to use a DSN? I don't know whether it is or not, but I would think it is, because there is an ODBC driver for Oracle and if you have an ODBC driver, then you should be able to have the DSN.
Now, for the standard SQL. That's a good concept, standard SQL. Unfortunately it is a concept seldom found in practice. Even the SQL standards allow several levels of compliance and the entry level, usually the one supported by most DBMSes, is not enough to be of any use.
The problem sometimes is not one of standards. For example, in Access, SQL Server and MySQL DBs, there is field type that allows for automatic generation of values for primary keys (AutoNumber in Access, identity fields in SQL Server, don't know how it's called in MySQL). Oracle does not support this and though it provides a solution that allows this to be overcome, it's a specific Oracle solution. So, having a single ASP file for all the DBs is ... well I guess you must have understood it by now.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Zephyrus
Starting Member
7 Posts |
Posted - 16 March 2003 : 04:13:08
|
Well I am an educated Oracle Developer.
Oracle DO provide you with the possibilities of autoincrement numbers. Just use a generator together with a trigger.
And you won't need many changes to the snitz scripts to support this.
I guess in the create procedures you must check to see if strDBType = oracle, and if it is create generators and triggers.< |
|
|
|
Zephyrus
Starting Member
7 Posts |
Posted - 16 March 2003 : 04:17:26
|
Ok, sorry....didn't check the scripts before last post :)
I didn't know that there allready was 1 create script for each DB type.
Perhaps it should be made and be a part of the snitz package.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 March 2003 : 06:44:10
|
quote:
Originally posted by Zephyrus
Ok, sorry....didn't check the scripts before last post :)
I didn't know that there allready was 1 create script for each DB type.
Perhaps it should be made and be a part of the snitz package.
There are have been a couple posts about that, but the people who eventually did it did not post the changes to the scripts. If you want to do it, surely it will be appreciated.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Forum Locked
