-
Good Morning all,
I've been trying to figure out how to connect to and Oracle 8 database using VB 3. Is this even possible? I've read some help tips and stuff, but I can't figure out how to do it.
Can someone please help me.
Here is some info about the database I would like to connect to.
Server=Myserver
UID=APPS
Password=MYAPPS
Thanks,
JazzBass
------------------
21 yr old beginner VB Programmer
VB 6 Professional @ Home
VB 3 Professional @ the Office
-
Try this On ADO Connection:
Set you ODBC first..{Microsoft ODBC Oracle Driver}.
------------------------------
Set cn = New ADODB.Connection
cn.Open "dsn=COMS;UID=ComsAdmin;PWD=coms"
Set rs = New ADODB.Recordset
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
------------------------------------
I'm new in vb
-Khamal- :)
-
I think you need VB4/32 at the least.
------------------
smalig
[email protected]
http://vbcode.webhostme.com/
-
Thanks Guys,
I think Smalig is right. I just may need a later version. Thanks for the help.
JazzBass