TwilightMan
New Member
I'm very new to ASP.NET and I am having some problems connecting to my Informix database using an ODBC data source and the OleDbConnection object. All the examples I've found relate to Sql Server or another Microsoft product. Can anyone help me get this straight?<BR><BR>Here is the beginning of my aspx page. I get an error on the MyConnection.Open() line saying 'Exception Details: System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Invalid connection string attribute'. <BR><BR>Any ideas why the error refers to SQL Server? Is SQLOLEDB the provider I should be using for the OLEDB provider for ODBC?<BR><BR>Thanks in advance for any information you can provide!<BR><BR>Erika<BR><BR><%@ Import Namespace="System.Data" %><BR><%@ Import Namespace="System.Data.OleDb" %><BR><%@ Page Language="VB" Debug="true" %><BR><BR><html><BR><script language="VB" runat="server"><BR><BR> Sub Page_Load(Sender As Object, E As EventArgs) <BR><BR> Dim DS As DataSet<BR> Dim MyConnection As OleDbConnection<BR> Dim MyCommand As OleDbDataAdapter<BR><BR> MyConnection = New OleDbConnection("provider=SQLOLEDB;DSN=FRANCE_RDS_DEV;")<BR> MyConnection.Open()Never mind, I mistakenly thought that SQLOLEDB was the OLE DB provider for ODBC. I have since found that for informix the provider should be 'ifxoledbc' and can now successfully connect to my db.<BR><BR>Erika