I am trying to connect to an oracle 8i database from within visual basic 2005. The code i am using to try to connect is listd below
for the data source i am useing the name provided in the tnsnames.ora file.
I havent sent a query to it yet because I cannot get that far. I just ran the debugger to see if i got it to connect but I keep getting a pop box with this in it:
Request for the permission of type 'System.Data.Odbc.OdbcPerm
ission, System.Data, Version=126.96.36.199, Culture=neutral, PublicKeyToken=b77a5c56193
Am I using the right connection string? If not what would be the correct way of doing it. ODP.net is not available because according to oracle it is only for versions 9 or higher.
Dim connection As OdbcConnection
Dim sConnString As String = "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;"
connection = New Odbc.OdbcConnection(sConnString)