Connecting to Informix using .net 2

[DaveMac1960]

I'm probably wasting breath here, but if anyone could help me out it would be much appreciated.

I'm trying to connect to an Informx 7.x database from a .net application. Below is the code in question:

Public Const VisionConn = "DSN=Vision;Provider=SQLOLEDB;user ID=userID;password=password;DATABASE=v001"

Dim cnn As New OleDb.OleDbConnection(VisionConn)
Dim cmd As OleDb.OleDbCommand
Dim rdr As OleDb.OleDbDataReader

cmd = New OleDb.OleDbCommand( _
"SELECT * FROM drmast " _
& "ORDER BY drno ", cnn)

cnn.Open()

When the code executes, I get a "Login failed for 'userID'; Invalid connection string attribute" error. Well the login is valid so I figure that part is bogus. Naturally .net does not give me any indication which connection attribute is invalid.

Thanks a bunch in advance,
Dave

 

[ca8msm]

First I'd make sure the connection string is valid for the database type:

faq855-5780


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[jmeckley]

http://www.connectionstrings.com/?carrier=informix

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[DaveMac1960]

Thanks to both of you for your help. I had already found the connection strings jmeckley pointed me to but I couldn't get them to work in .net.

The VBS script ca8msm gave me another connection string, but the provider MSDASQL.1 is not recognized in .NET (too old). Thank you for that Microsoft.

Thanks for your help guys but it looks like I may have to figure this out on my own.

Thanks again,
Dave