Bonjour,

Je développe sous VS.NET 2002 FR (en VB.NET) et Oracle 9i.
J'ai bien ajouter la dll System.data.OracleClient et importer dans mon fichier aspx.vb System.data.OracleClient.
Mais quand j'ouvre ma connexion, j'ai une erreur me disant "Mot clé non pris en charge : 'provider'."

Voici mon code:

Dim oracleConnection As New OracleConnection()

Dim oracleCommand As New OracleCommand()

Dim oracleAdapter As OracleDataAdapter

Dim sqlString As String

sqlString = "Provider=MSDAORA.1;Password=pwd;User ID=user;Data Source=MaBase"

Try

      OracleConnection.ConnectionString = sqlString

      OracleConnection.Open()

      oracleCommand.CommandText = "SELECT * FROM MaTable"

      oracleCommand.Connection = OracleConnection

      oracleAdapter = New OracleClient.OracleDataAdapter()

      oracleAdapter.SelectCommand = oracleCommand

      ...

      ' Work with oracle data

      oracleReader.Close()

      oracleCommand.Dispose()

      Exit Function

Catch ex As OracleException

      'handle the exception

Catch ex As Exception

      'handle the exception

Finally

      If Not (oracleConnection Is Nothing) Then

               oracleConnection.Close()

       End If

End Try

End Function

Merci pour votre aide

Salut,

Tu utilises
System.Data.OracleClient
using System.Data.OracleClient;
...
OracleConnection oracleConn = new OracleConnection();
oracleConn.ConnectionString = "user id=scott;
                               data source=oracleSN;
                               password=tiger";
oracleConn.Open();
ou
Oracle.DataAccess.Client
using Oracle.DataAccess.Client;
...
OracleConnection oracleConn = new OracleConnection();
oracleConn.ConnectionString = "User Id=scott;Password=tiger;
                               Data Source=oracleSN;";
oracleConn.Open();


yopyop

Salut,

Tu utilises
System.Data.OracleClient
using System.Data.OracleClient;
...
OracleConnection oracleConn = new OracleConnection();
oracleConn.ConnectionString = "user id=scott;
                               data source=oracleSN;
                               password=tiger";
oracleConn.Open();
ou
Oracle.DataAccess.Client
using Oracle.DataAccess.Client;
...
OracleConnection oracleConn = new OracleConnection();
oracleConn.ConnectionString = "User Id=scott;Password=tiger;
                               Data Source=oracleSN;";
oracleConn.Open();


yopyop