Connect Informix . NET via DSN

Question

Connect Informix . NET via DSN

Asked 6 years, 1 month ago

Viewed 89 times

0

Good afternoon,

I have been trying for days to connect an application to a Informix database, but I can not at all.

I am with Visual Studio 2017 using ASP.NET Framework 4.6. I tried to find solutions on the IBM site, but that site does not help in much, everything gets scattered and ends up getting even more confused.

I have installed the SDK 4.10.FC12 and managed to mount a connection through the Data Source Administrator ODBC (Windows native)

My question is: how can I access this DSN connection via visual studio in the . NET application?

If anyone knows, please help me! Thank you :)

1 answer

Browser other questions tagged asp.net-mvc informix

You are not signed in. Login or sign up in order to post.

by Lucas Miranda • **1,314** points · Answer 1 · 2018-11-05T15:23:29+00:00

1

You can try a connection using odbconnection :

 OdbcConnection conn = new OdbcConnection(@"DSN=suaconexaoodbc;UID={usuario};PWD={senha};");

More information:

https://docs.microsoft.com/pt-br/dotnet/api/system.data.odbc.odbcconnection?view=netframework-4.7.2

Hi Lucas, I’m trying to use this example and just below this line I put the Conn.Open(). The problem is that the program stops and talks that the variable Conn does not exist in the context, so it doesn’t even let me run the program. You know how I can fix this?

– Bruna Toledo

2018/11/05 at 18:15
shows your code, updates it on the question

– Lucas Miranda

2018/11/05 at 18:27
In fact, I just had to assemble a constructor and leave everything in methods (sorry for the questions, I’m starting to program now). Thanks for the help!

– Bruna Toledo

2018/11/06 at 09:43