How can one create a class (.dll) that can be used for connecting to different databases like SQL Server and Oracle so that it can be used with any application for dtabase connection. Plz help me come out of this.
Printable View
How can one create a class (.dll) that can be used for connecting to different databases like SQL Server and Oracle so that it can be used with any application for dtabase connection. Plz help me come out of this.
I know there are ways to create a DNS so that your application can connect to the Database via this DNS, but how, I don't know. Maybe this could solve your problem... It is not the solution to your question though.
Don't know if syntax is same on both db's.
To make your dll usable for both , don't hard code anything.
Add a form for the connection parameters to be entered by the user.
Like server, database, user, pwd.