Connection to oracle 10g

how do you connect vb application to oracle 10g

Page 1 of 1

4 Replies - 35530 Views - Last Post: 09 February 2010 - 06:07 AM Rate Topic: -----

#1 oluwaseun_odufuwa  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 14-February 08

Connection to oracle 10g

Posted 14 February 2008 - 11:54 AM

how do you connect vb application to oracle 10g
Is This A Good Question/Topic? 0
  • +

Replies To: Connection to oracle 10g

#2 Jayman  Icon User is offline

  • Student of Life
  • member icon

Reputation: 418
  • View blog
  • Posts: 9,532
  • Joined: 26-December 05

Re: Connection to oracle 10g

Posted 14 February 2008 - 12:20 PM

Do you know how to connect to SQL server?

It is the same process.
Was This Post Helpful? 0
  • +
  • -

#3 Jayman  Icon User is offline

  • Student of Life
  • member icon

Reputation: 418
  • View blog
  • Posts: 9,532
  • Joined: 26-December 05

Re: Connection to oracle 10g

Posted 14 February 2008 - 12:20 PM

Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Post your code like this: :code:

Thanks.
Was This Post Helpful? 0
  • +
  • -

#4 RenatoCavs  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 19-June 08

Re: Connection to oracle 10g

Posted 19 June 2008 - 01:10 PM

View Postjayman9, on 14 Feb, 2008 - 12:20 PM, said:

Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Post your code like this: :code:

Thanks.


Hi Folks, It's a cliché, I know, but I need help! I created a simple application that used to read some tables in an Oracle 8i database. The problem is that the database now is an Oracle 10g running in a Xeon machine... Since they changed the DB, I can't connect to Oracle... I'm in serious trouble... I use VB6 sp6 in a windows 2000 professional OS.
Look at how I used to connect to Oracle Db:
' In my .bas

Public Const glbCntStr_ORA As String = "Provider=MSDAORA.1;User ID=cmpsto;Password=cmpsto;Data Source=DELL;Persist Security Info=False"

'I've already tried to connect using: 

Public Const glbCntStr_ORA As String = "Provider=OraOLEDB.1;User ID=cmpsto;Password=cmpsto;Data Source=DELL;Persist Security Info=False"


' then in my form...

'(general) (Declarations)
Private CnOracle As New ADODB.Connection

Private Sub Form_Load()
	If CnOracle.State <> 1 Then
		CnOracle.ConnectionTimeout = 400
		CnOracle.CommandTimeout = 400
		CnOracle.ConnectionString = glbCntStr_ORA  'the error occurs here!
		CnOracle.Open
	End If
	If Cn.State <> 1 Then
		Cn.ConnectionTimeout = 200
		Cn.CommandTimeout = 200
		Cn.ConnectionString = glbCntStr
		Cn.Open
	End If
End Sub



the Error message : "Run time error:3706 Provider cannot be found.It may not be properly installed"

Thanks in Advance,

Renato
Was This Post Helpful? 0
  • +
  • -

#5 Guest_alekya*


Reputation:

Re: Connection to oracle 10g

Posted 09 February 2010 - 06:07 AM

then what u did ?


View PostRenatoCavs, on 19 June 2008 - 12:10 PM, said:

View Postjayman9, on 14 Feb, 2008 - 12:20 PM, said:

Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Post your code like this: :code:

Thanks.


Hi Folks, It's a cliché, I know, but I need help! I created a simple application that used to read some tables in an Oracle 8i database. The problem is that the database now is an Oracle 10g running in a Xeon machine... Since they changed the DB, I can't connect to Oracle... I'm in serious trouble... I use VB6 sp6 in a windows 2000 professional OS.
Look at how I used to connect to Oracle Db:
' In my .bas

Public Const glbCntStr_ORA As String = "Provider=MSDAORA.1;User ID=cmpsto;Password=cmpsto;Data Source=DELL;Persist Security Info=False"

'I've already tried to connect using: 

Public Const glbCntStr_ORA As String = "Provider=OraOLEDB.1;User ID=cmpsto;Password=cmpsto;Data Source=DELL;Persist Security Info=False"


' then in my form...

'(general) (Declarations)
Private CnOracle As New ADODB.Connection

Private Sub Form_Load()
	If CnOracle.State <> 1 Then
		CnOracle.ConnectionTimeout = 400
		CnOracle.CommandTimeout = 400
		CnOracle.ConnectionString = glbCntStr_ORA  'the error occurs here!
		CnOracle.Open
	End If
	If Cn.State <> 1 Then
		Cn.ConnectionTimeout = 200
		Cn.CommandTimeout = 200
		Cn.ConnectionString = glbCntStr
		Cn.Open
	End If
End Sub



the Error message : "Run time error:3706 Provider cannot be found.It may not be properly installed"

Thanks in Advance,

Renato

Was This Post Helpful? 0

Page 1 of 1