Member Avatar for ahirmayur

Hello Guys,
I am new to VB6 & Oracle too.
I have one got one Project from my friend.
He gave me some VB6 files & 2 SQL files for Oracle database.
Now i want to know that how can i connect my VB files to database??

I am also attaching my project file so i can get better help.

PROJECT.zip (24.42 KB)
  • 3 Contributors
  • 2 Replies
  • 332 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by abu taher

Dani AI

Generated

A concise, practical checklist that builds on ’s observation that the project already contains a connection entry in a code module and on ’s pointer to related threads. The full workflow has three parts: get the database schema created from the .sql files, ensure an Oracle client/data-source is available on the machine that will run the VB6 app, then locate and update the VB6 connection settings and verify connectivity.

Database preparation: run the two SQL files with an Oracle client tool (SQL*Plus or Oracle SQL Developer) while connected as the intended schema owner or as a DBA that creates the user/schema first. Confirm that the scripts create the expected tables, grants, and any seed data. Confirm the listener is running and that the schema username exists and is not locked; database credentials in the VB project must match the schema the scripts created.

Locating and testing the VB6 connection: search the project files (.vbp, .frm, .bas) for terms like ConnectionString, Conn, ADODB or UDL to find where the app sets its DB connection. If the project uses a DSN or UDL, update that system entry instead of editing many files. A minimal ADODB test using a DSN (example only) helps isolate problems:

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.Open "DSN=MY_ORACLE_DSN;Uid=MYUSER;Pwd=MYPASS;"

Troubleshooting tips and context: common errors include “invalid username/password” (verify user and password, unlock account), TNS/ listener errors (check tnsnames.ora and listener status), and “provider not found” (install the correct Oracle client/ODAC and match 32-bit drivers to VB6). Because the thread is old, note that modern OS/driver mismatches are a frequent source of failure. For clearer diagnostics, post the exact error text, which client/driver is installed, and which step (script run, connection test, app start) produced the error.

Recommended Answers

All 2 Replies

Member Avatar for manoshailu

hi,

Already Connection is done between VB and Oracle Database and the code is available in the "Code Module"

Conn.ConnectionString = "Provider=MSDAORA;User ID=scott;Password='tiger';Persist Security Info=False"

In your System, Find the User name and password of the Oracle and assign the User name and password in the Connectionstring and then run the project.

Shailaja:)


Hello Guys,
I am new to VB6 & Oracle too.
I have one got one Project from my friend.
He gave me some VB6 files & 2 SQL files for Oracle database.
Now i want to know that how can i connect my VB files to database??

I am also attaching my project file so i can get better help.

Member Avatar for abu taher

Please check thread 118202. i think u can better help from this thread. if u not get help please reply.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.