Multi Database application

[Vittorio Pavesi]

Hello,
I'm wondering what are the usual problems developing multi database
application (e.g. Access, SQL, Oracle, MySQL..)
I only need to log informations on 3/4 tables (I don't use stored proceure,
view..).
Should I use ODBC ?
Regards

Vittorio

 

[Cor]

Hi Vittorio,

What are the usual problems depends on knowledge of the person who makes it.

With those databases you can choise for OLEDB
http://www.connectionstrings.com

Although tailoring on Oracle for Oracle, SQL for SQL server and OleDb for
the rest will give you as far as I know the best performance

Just my thougths

Cor

 

[Vittorio Pavesi]

Really thanks

Vittorio

 

[Vittorio Pavesi]

Ok I just experienced a small problem, my create table statements for MS SQL
doesn't work with Access, the problem appear with IDENTITY field (below the
query); do exist a common language ?

CREATE TABLE [CheckDisk] (
[ID] int IDENTITY (1, 1) NOT NULL ,
[ConfigName] char (50) NOT NULL ,
[Description] char (255) NOT NULL ,
[Threshold] int NOT NULL ,
[Type] char (15) NOT NULL ,
[LastDate] datetime NULL
)

Vittorio