Creating DLL to Connect to a Database
Hi baddies,
Could somebody help me with this. Is it possible to create a DLL that is able to accept parameters and connect to an Oracle Database?? Anysample code or advice will be appreciated.
:WAVE:
[218 byte] By [
wandera] at [2007-11-11 7:21:39]
# 1 Re: Creating DLL to Connect to a Database
Yes, it is possible; there are numerous examples of how to connect from VB to Oracle available on the Web. What problem are you having?
# 2 Re: Creating DLL to Connect to a Database
Hi Phil,
The problem i have is that when i try creating ADODB connections and Records sets in a DLL they are not accepted. So i want if theres a way to create a DLL that will connect to a DLL without declaring a Connection or how a connection can be created.In summation i really want to create a DLL that will connect to an Oracle Database. "Database name: smarthr, user: sysadm, PWd: sysadm. Although i would want a case where user and password are passed as parameters to that DLL.
# 3 Re: Creating DLL to Connect to a Database
I'm sorry, can you be more specific? When you say connections and recordsets are "not accepted," what do you mean? Does the code not compile? Do you get a runtime error? If you get an error message, what does it say?
