QUOTE(jayman9 @ 14 Feb, 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:
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:
CODE
' 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
| 