Connect to Oracle

Anyone can help to specify an example to connect to Oracle 7.3 database
using VB 4?
MWarrenCAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
maheshsivakumarConnect With a Mentor Commented:
I have used this code to connect to Oracle data base and it works fine. I have used rdoconnection object. Try this.I hope VB4 supports this.Create a dsn name to Oracle database and try following code.
dim en as rdoenvironment,db as rdoConnection

Set en = rdoEnvironments(0)
Set db = en.OpenConnection(dsname:="trainora", Connect:="uid=train1;pwd=train1;", Prompt:=rdDriverNoPrompt)
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
1) Build a Alias using SQL Easy Config (coming with Oracle Client install)
2) Connectstring will go like
"DBQ=YourAliasName;Driver={Oracle73};UID=Username;PWD=pwd"


For the Name of the driver, look in the Control Panel-ODBC-Drivers and copy the name of the driver you want to use (case sensitive)

Hope this helps
0
 
szdenCommented:
ODBC?
No thanks.

ADO Yes, Yesy, Yes!

1.Put MS ADO data control on a form.
2.Click right mouse button and choose properties.
3.Click on Build... (connection string)
4.Choose MS OLE DB provider for Oracle
5.Click Next.
6.Enter data (serevr name is DB alias created using SQL easy config)
7.Test connection
8.OK

Now you can copy connection string from ADODC properties.
(Of course, after pasting Connection string into code, ADODC is not needed anymore)
0
 
VoodoomanCommented:
Ado - no thanks - to many bugs and too slow!!

Voodooman!

Also dont think VB4 supports ado - no controls - need VB6 to get that!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.