shelbyinfotech
asked on
Visual Studio 2010 (64-bit) ORA-06413 error
I've got a vb.net web application that connects to the Oracle DB on my old PC (32-bit, XP Prof.), but now won't on my new PC (64-bit, Windows 7). All I get is an ORA-06413 "not connected" error
Visual Studio 2010 installed in C:\Program FilesX86\
- so this should avoid the whole parentheses/Oracle path issue
64-bit Oracle DAC asp.net 4 installed in C:\Oracle64
I can connect in Visual Studio using the Server Explorer ... MSDAORA.ServerName
Here is part of my code:
>>>>
Imports System.Data.OracleClient
Imports System.Data.OleDb
'64-bit - I think -
Dim myConnection As New OleDb.OleDbConnection("Pro vider=OraO LEDB.Oracl e.1;Data Source=XXXX;User ID=XXXX;Password=XXXX;")
Dim myCommand As OleDbCommand
Dim dr As OleDbDataReader
Try
myConnection.Open()
myCommand = New OleDbCommand(QRY5, myConnection)
dr = myCommand.ExecuteReader()
....read into some variables....
Catch ex As Exception
ex.Message.ToString()
Throw
Finally
dr.Close()
myConnection.Close()
>>>>
On the 32-bit PC, this works:
' 32 bit
'Dim myConnection As New OleDb.OleDbConnection("Pro vider=MSDA ORA.1;Data Source=XXXX;User ID=XXXX;Password=XXXX;")
TIA
Visual Studio 2010 installed in C:\Program FilesX86\
- so this should avoid the whole parentheses/Oracle path issue
64-bit Oracle DAC asp.net 4 installed in C:\Oracle64
I can connect in Visual Studio using the Server Explorer ... MSDAORA.ServerName
Here is part of my code:
>>>>
Imports System.Data.OracleClient
Imports System.Data.OleDb
'64-bit - I think -
Dim myConnection As New OleDb.OleDbConnection("Pro
Dim myCommand As OleDbCommand
Dim dr As OleDbDataReader
Try
myConnection.Open()
myCommand = New OleDbCommand(QRY5, myConnection)
dr = myCommand.ExecuteReader()
....read into some variables....
Catch ex As Exception
ex.Message.ToString()
Throw
Finally
dr.Close()
myConnection.Close()
>>>>
On the 32-bit PC, this works:
' 32 bit
'Dim myConnection As New OleDb.OleDbConnection("Pro
TIA
Since Visual Studio is 32Bit, I think you will need the 32Bit ODAC. I'm not sure VS can reference the 64Bit drivers.
If you can connect in server explorer using MSDAORA.ServerName,
then use the same MSDAORA.ServerName in provider, why did u use OLEBD in code?
then use the same MSDAORA.ServerName in provider, why did u use OLEBD in code?
I just saw the re-read "Visual Studio 2010 (64-bit) "
What threw me was "Visual Studio 2010 installed in C:\Program FilesX86\".
Do the Bit versions match?
What threw me was "Visual Studio 2010 installed in C:\Program FilesX86\".
Do the Bit versions match?
ASKER
I believe I have those in C:\Oracle817cl. When I ran it with the 32 bit connection string, I still get the exact same error.
ASKER
As far as I know, Visual Studio is only a 32 bit application. The 64-bit references the system the application is installed on. Sorry for the confusion.
>>C:\Oracle817cl
Were you using the Oracle 8 32Bit drivers? I can see where Oracle 8 will throw an error.
Were you using the Oracle 8 32Bit drivers? I can see where Oracle 8 will throw an error.
ASKER
Yes, these are the same drivers that I used on my 32 bit PC.
But were they Oracle 8? I would get newer/supported Oracle data access providers. 32Bit.
ASKER
Right now we are running an Oracle 8 server with intentions of upgrading to 10.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It sent to to the right sight to get answers, which was Oracle support