Hi,
I have IIS 5.0 w/.NET FW installed, MDAC 2.7, running on a Windows 2000 Server w/SP2. I'm trying to connect to an Informix database running on another system. I am able to connect to it via ODBC connections (in the Data Source Manager in Windows), but I would like to be able to connect to it via OLE DB. The OLEDB provider does not seem to work on Win Server, but works fine on Pro. Has anyone been able to get this to work? If so, any ideas? When I am in the Data Link Properties program (directly from Windows), and I select Informix OLE DB Provider, it states "Provider is no longer available. Ensure that the provider is installed correctly." I have uninstalled, reinstalled, registered the DLL, called tech support ( they are not sure how it works with .NET yet so I'm waiting for a call back).
Can anyone help?!?!? If not, how do I use an ODBC connection to the data source? I've tried using the Microsoft ODBC.NET but it states that it cannot find the namespace (i'm not using the C# IDE yet).
Thanks!!!!!!!
Chris
I have IIS 5.0 w/.NET FW installed, MDAC 2.7, running on a Windows 2000 Server w/SP2. I'm trying to connect to an Informix database running on another system. I am able to connect to it via ODBC connections (in the Data Source Manager in Windows), but I would like to be able to connect to it via OLE DB. The OLEDB provider does not seem to work on Win Server, but works fine on Pro. Has anyone been able to get this to work? If so, any ideas? When I am in the Data Link Properties program (directly from Windows), and I select Informix OLE DB Provider, it states "Provider is no longer available. Ensure that the provider is installed correctly." I have uninstalled, reinstalled, registered the DLL, called tech support ( they are not sure how it works with .NET yet so I'm waiting for a call back).
Can anyone help?!?!? If not, how do I use an ODBC connection to the data source? I've tried using the Microsoft ODBC.NET but it states that it cannot find the namespace (i'm not using the C# IDE yet).
Thanks!!!!!!!
Chris