oracle, Microsoft, dbase

[robbedaya]

I need to access an Dbase database, an oracle database, an Microsoft sql database and an access (maybe DB2) database in one project.

and i doe have to gat some info out of it using sql statements. How can i do this without have to use different sql, and without accessing each dbase on another way.

I have to do it in VB.NET

[robbedaya]

i do not have to open them at the same time. The user selects a database (one of the 4 types I talked about)

[abhijit]

I don't think you can actually get away with using the same sql unless you are planning to use simple ANSI - Compliant sql statements. Then too I am not very sure if Dbase would support these.

I am working on an application which has both ORacle as well as SQL database servers and what I do is keep a global variable called gDBType to store the database type that I am connected to. Depending upon the gDBType, my code has a lot of if-then-else statements to take care of the various quirks of SQL and Oracle.

Cheers!
Abhijit

[robbedaya]

thx,
I already thought so, didn't know it for sure.