Home » Other » General » Connectivity of Oracle 8.0i with VB 6.0
Connectivity of Oracle 8.0i with VB 6.0 [message #103768] Tue, 09 March 2004 23:35 Go to next message
dheeraj tandon
Messages: 2
Registered: March 2004
Junior Member
How I create a databse in Oracle 8.0i. When the database is created than how I connect that database with the VB 6.0

Dheeraj
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #103806 is a reply to message #103768] Sun, 21 March 2004 23:53 Go to previous messageGo to next message
shuja
Messages: 3
Registered: March 2004
Junior Member
i want to know about how we can make connection between vb and oracle 8.0i please send me the code of this problem
thank you
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #103808 is a reply to message #103768] Tue, 23 March 2004 00:49 Go to previous messageGo to next message
vijay Kumar
Messages: 17
Registered: January 1999
Junior Member
pls give email how to connect vb projects to oracle database?
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #103835 is a reply to message #103768] Sat, 03 April 2004 04:35 Go to previous messageGo to next message
trilochan
Messages: 1
Registered: April 2004
Junior Member
hi
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #103836 is a reply to message #103768] Sat, 03 April 2004 04:37 Go to previous messageGo to next message
trilochan singh
Messages: 1
Registered: April 2004
Junior Member
hello
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #103889 is a reply to message #103806] Mon, 03 May 2004 11:21 Go to previous messageGo to next message
jhansi
Messages: 5
Registered: February 2003
Junior Member
i want to know about how we can make connection between vb and oracle 8.0i please send me the code and process.
thank you
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #103955 is a reply to message #103889] Wed, 02 June 2004 19:10 Go to previous messageGo to next message
abhimanyu bisoyi
Messages: 1
Registered: June 2004
Junior Member
process for odbc connectivity
process for update,add, search etc.
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #103973 is a reply to message #103808] Thu, 10 June 2004 04:19 Go to previous messageGo to next message
Achi Sharma
Messages: 1
Registered: June 2004
Junior Member
Please send the "Connectivity of Oracle 8.0i with VB6.0"

I am wants to create a project on a Pathology system as a MCA Project.

Thank you
Re: Connectivity of Oracle 8.0 with VB 6.0 [message #104002 is a reply to message #103955] Tue, 22 June 2004 02:51 Go to previous messageGo to next message
haroon
Messages: 1
Registered: June 2004
Junior Member
help me in the connectevity of Re: Connectivity of Oracle 8.0 with VB 6.0
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104030 is a reply to message #103768] Tue, 06 July 2004 21:15 Go to previous messageGo to next message
vaishali wangikar
Messages: 1
Registered: July 2004
Junior Member
please guide me for V.B. 6.0 and Oracle 8.0 odbc connectivity also guide me for oracle database creation
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104052 is a reply to message #104030] Tue, 13 July 2004 09:52 Go to previous messageGo to next message
hardik
Messages: 12
Registered: December 2001
Junior Member
dear,

i cannot unbound connected with vb with oracle through adodc contorl
Re: Connectivity of Oracle 8.0 with VB 6.0 [message #104208 is a reply to message #104002] Thu, 19 August 2004 21:17 Go to previous messageGo to next message
Rekha
Messages: 9
Registered: September 2000
Junior Member
help me in the connectevity of Re: Connectivity of Oracle 8.0 with VB 6.0
ThankYou.
Re: Connectivity of Oracle 8.0 with VB 6.0 [message #104339 is a reply to message #104208] Mon, 27 September 2004 01:31 Go to previous messageGo to next message
Vineela
Messages: 2
Registered: September 2004
Junior Member
Please send me the code
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104366 is a reply to message #103806] Wed, 29 September 2004 03:15 Go to previous messageGo to next message
sonu
Messages: 4
Registered: April 2002
Junior Member
I Also Want the code of Connection between Vb And Oracle.
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104390 is a reply to message #103836] Thu, 07 October 2004 07:53 Go to previous messageGo to next message
dipak
Messages: 4
Registered: October 2004
Junior Member
Dear
I too am facing the similar situation plz help me too if smmbdy can

thanx
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104391 is a reply to message #103973] Thu, 07 October 2004 07:56 Go to previous messageGo to next message
Deepak
Messages: 111
Registered: December 1999
Senior Member
hiii
plz send me too vb oracle connectivity infrmn if u can
Re: Connectivity of Oracle 8.0 with VB 6.0 [message #104393 is a reply to message #104339] Thu, 07 October 2004 08:01 Go to previous messageGo to next message
dipak
Messages: 4
Registered: October 2004
Junior Member
i too need the cod eplz send me too
thanx
Re: Connectivity of Oracle 8.0 with VB 6.0 [message #104441 is a reply to message #104393] Thu, 14 October 2004 19:36 Go to previous messageGo to next message
Manu
Messages: 5
Registered: February 2002
Junior Member
' DAO Example (Data Access Objects)
Dim wstemp As Workspace
Dim dbtemp As Database
Dim rstemp As Recordset

Set wstemp = DBEngine.Workspaces(0)
Set dbtemp = wstemp.OpenDatabase("", False, False, "ODBC;DSN=Oracle;USR=scott;PWD=tiger")
Set rstemp = dbtemp.OpenRecordset(myquery.Text, dbOpenDynaset, dbSQLPassThrough)
howmany = 0
Combo1.Clear
Do Until rstemp.EOF
msgbox rstemp(0)
rstemp.MoveNext
howmany = howmany + 1
Loop

' DAO Example (Data Access Objects)
Dim contemp As New rdoConnection
Dim rstemp As rdoResultset
Dim envtemp As rdoEnvironment
Set envtemp = rdoEngine.rdoEnvironments(0)
envtemp.CursorDriver = rdUseServer
' or rdUseOdbc, rdUseNone, rdUseIfNeeded, rdUseClientBatch
With contemp
.Connect = "ODBC;DSN=Oracle;USR=scott;PWD=tiger"
.EstablishConnection rdDriverNoPrompt, false, rdoForwardOnly
' or rdoStatic, rdoKeyset, rdoDynamic
End With

Set rstemp = contemp.OpenResultset("select ...") ' Your SQL here
End If

howmany = 0
With rstemp
Do Until .EOF Or howmany > 2000
msgbox .rdoColumns(0)
' Give a message box of the 1st column
.MoveNext
howmany = howmany + 1
Loop

ADO Example
dim conn as ADODB.Connection
dim rs as recordset
Conn.Open "...", "...", "..."
' ^DSN ^User ^Password
Set RS = Conn.Execute( "SELECT * FROM theTable" )
do while not rs.eof
msgbox RS(i).Value
rs.movenext
loop

Why are you guys repeatedly posting the same stuff? I guess the above code works fine. Try to learn from it & no double posts.
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104464 is a reply to message #104030] Fri, 22 October 2004 23:52 Go to previous messageGo to next message
gitanjali
Messages: 1
Registered: October 2004
Junior Member
hi
plz tell me how to conncct vb with oracle
thanking u
gitanjali
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104480 is a reply to message #104390] Wed, 27 October 2004 03:44 Go to previous messageGo to next message
kailash
Messages: 1
Registered: October 2004
Junior Member
DAO Example (Data Access Objects)
Dim wstemp As Workspace
Dim dbtemp As Database
Dim rstemp As Recordset

Set wstemp = DBEngine.Workspaces(0)
Set dbtemp = wstemp.OpenDatabase("", False, False, "ODBC;DSN=Oracle;USR=scott;PWD=tiger")
Set rstemp = dbtemp.OpenRecordset(myquery.Text, dbOpenDynaset, dbSQLPassThrough)
howmany = 0
Combo1.Clear
Do Until rstemp.EOF
msgbox rstemp(0)
rstemp.MoveNext
howmany = howmany + 1
Loop

' DAO Example (Data Access Objects)
Dim contemp As New rdoConnection
Dim rstemp As rdoResultset
Dim envtemp As rdoEnvironment
Set envtemp = rdoEngine.rdoEnvironments(0)
envtemp.CursorDriver = rdUseServer
' or rdUseOdbc, rdUseNone, rdUseIfNeeded, rdUseClientBatch
With contemp
.Connect = "ODBC;DSN=Oracle;USR=scott;PWD=tiger"
.EstablishConnection rdDriverNoPrompt, false, rdoForwardOnly
' or rdoStatic, rdoKeyset, rdoDynamic
End With

Set rstemp = contemp.OpenResultset("select ...") ' Your SQL here
End If

howmany = 0
With rstemp
Do Until .EOF Or howmany > 2000
msgbox .rdoColumns(0)
' Give a message box of the 1st column
.MoveNext
howmany = howmany + 1
Loop

ADO Example
dim conn as ADODB.Connection
dim rs as recordset
Conn.Open "...", "...", "..."
' ^DSN ^User ^Password
Set RS = Conn.Execute( "SELECT * FROM theTable" )
do while not rs.eof
msgbox RS(i).Value
rs.movenext
loop
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104496 is a reply to message #104030] Sun, 31 October 2004 23:30 Go to previous messageGo to next message
Preeti
Messages: 14
Registered: November 2000
Junior Member
hello

please tell me connectivity of oracle from very basic including how to generate dsn no.
thanku
how i can list the data in combobox if the data is retrive from the table or dat [message #104526 is a reply to message #103768] Tue, 16 November 2004 02:35 Go to previous messageGo to next message
Mukesh
Messages: 8
Registered: March 2002
Junior Member
how i can list the data in combobox if the data is retrive from the table or database.
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104540 is a reply to message #103973] Mon, 22 November 2004 19:28 Go to previous messageGo to next message
Rajendra
Messages: 23
Registered: September 2000
Junior Member
Please send the "Connectivity of Oracle 8.0i with VB6.0"

I am wants to create a project in MCA .
Thank you
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104547 is a reply to message #104391] Wed, 24 November 2004 03:14 Go to previous messageGo to next message
snehal bk
Messages: 1
Registered: November 2004
Junior Member
i am a software test engineer i have my prjects ion vb oracle i need connectivity code,so plz send me.
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104548 is a reply to message #104547] Wed, 24 November 2004 04:49 Go to previous messageGo to next message
depak
Messages: 1
Registered: November 2004
Junior Member
all those of u having problem in connectivity may send me mail fix an online meeting and can get their problem solved in vb6.0 connectivity with oracle or sql server.
connectivity of oracle 8i with ANSI C [message #104551 is a reply to message #104030] Wed, 24 November 2004 22:25 Go to previous messageGo to next message
nisahnt tyagi
Messages: 1
Registered: November 2004
Junior Member
sir, i wanna know that is it possible to use C as frontend and oracle as back end. if yes then please tell me how it is possible in C laguage
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104622 is a reply to message #104496] Thu, 16 December 2004 17:23 Go to previous messageGo to next message
yasir ballo
Messages: 1
Registered: December 2004
Junior Member
i want information about connectivity of visual basic with oracle
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104625 is a reply to message #104030] Thu, 16 December 2004 22:57 Go to previous messageGo to next message
Siddheshwar
Messages: 1
Registered: December 2004
Junior Member
Please tell me how to take Qurey In two Text Box.
Re: how i can list the data in combobox if the data is retrive from the table or [message #104654 is a reply to message #104526] Thu, 23 December 2004 22:11 Go to previous messageGo to next message
arsh_naqvi
Messages: 1
Registered: December 2004
Junior Member
Please let me know that how i can list the data in combobox if the is retrive from table.
Anybody Please- Connectivity of VB 6 with Oracle 8i [message #104802 is a reply to message #104366] Sun, 06 February 2005 22:23 Go to previous messageGo to next message
Chandra Bhushan Singh
Messages: 1
Registered: February 2005
Junior Member
Please tell me, how to connect Oracle8i with VB6.

Thanks
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104822 is a reply to message #104030] Thu, 10 February 2005 01:40 Go to previous messageGo to next message
tejal
Messages: 2
Registered: February 2005
Junior Member
how to connect oracle 8.0 with VB 6.0 ?
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #104823 is a reply to message #104822] Thu, 10 February 2005 01:44 Go to previous messageGo to next message
tejal
Messages: 2
Registered: February 2005
Junior Member
how to connect Oracle 8.0 with VB 6.0 ?
Re: Connectivity of Oracle 8.1.5i with VB 6.0 [message #104830 is a reply to message #103973] Thu, 10 February 2005 03:39 Go to previous messageGo to next message
harshada ghosalkar
Messages: 1
Registered: February 2005
Junior Member
i am getting a error

it says:
[[micrsoft]][[microsoft odbc for oracle]]
run time error :80004005
my front end is vb 6.0
backend is oracle 8.1.5
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #108950 is a reply to message #104547] Sun, 20 February 2005 09:58 Go to previous messageGo to next message
Sarvesh Chaudhary
Messages: 1
Registered: February 2005
Junior Member
Hello,
Please write me code of Connectivity of Oracle 8.0i with VB 6.0
thanx & regards
sarvesh
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #109244 is a reply to message #104030] Tue, 22 February 2005 23:42 Go to previous messageGo to next message
Mahesh
Messages: 90
Registered: January 2001
Member
sir tell me about connectivity of oracle 8.0i with microsoft visual basic plz............
Re: Connectivity of Oracle 8.0i with VB 6.0 [message #113299 is a reply to message #104480] Fri, 01 April 2005 02:54 Go to previous messageGo to next message
krishnapotturi
Messages: 2
Registered: April 2005
Location: Hyderabad
Junior Member
hai,

can u please tell me how to create data reports in vb6.0 with oracle back-end.
The resport is generated based on the user give date. how to pass the date from form to data report and how to generate data report.

Please Help me it is urgent.
thans
Connectivity of Oracle 8.0i with VB 6.0 [message #216528 is a reply to message #108950] Mon, 29 January 2007 03:59 Go to previous message
ajayrahi
Messages: 1
Registered: January 2007
Junior Member
Sarvesh Chaudhary wrote on Sun, 20 February 2005 10:58
Hello,
Please write me code of Connectivity of Oracle 8.0i with VB 6.0
thanx & regards
sarvesh


Dear Sir,
Please write me code of Connectivity of Oracle 8.0i with VB 6.0
thanx & regards
with warm regards,
Ajay Rastogi.
Previous Topic: How to extent the expiry_date? (via Reported Message)
Next Topic: postponed commits possible?
Goto Forum:
  


Current Time: Thu Dec 08 14:08:27 CST 2016

Total time taken to generate the page: 0.10599 seconds