Printable View
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
i do not have to open them at the same time. The user selects a database (one of the 4 types I talked about)
:(
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
thx,
I already thought so, didn't know it for sure.