How I can access Database running in UNIX OS using ASP.NET

Question

I'm new in ASP.NET Programming .. I want to build a simple program which communicates Informix-Database running on HP-UNIX server. I have the following information:

DB Name Server IP Username Password

I want to know how I can establish a connection through my ASP program?

Thank you for your help

Safraawi

Possible duplicate: stackoverflow.com/questions/192477/…

villecoder
– villecoder

2012-03-01 14:45:46 +00:00
Commented Mar 1, 2012 at 14:45 — villecoder
– villecoder, Commented Mar 1, 2012 at 14:45

Oded · Accepted Answer · 2012-03-01 14:44:40Z

3

Use an appropriate connection string in your configuration and whatever .NET database provider there is for your database of choice.

See Connection Strings and Configuration Files (ADO.NET) on MSDN.

connectionstrings.com is a good resource for connection strings - how they should be structured using the kind of data you have.

And here is a list of .NET data providers, though you should check for one from you database vendor. Infomix appears to have such a provider, based on the release notes.

answered Mar 1, 2012 at 14:44

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

safraawi Over a year ago

Dear Oded, Thank you very much. is this correct? SqlConnection sqlCon = new SqlConnection(@"Database=myDataBase;Host=192.168.2.1;[email protected];Service=9005; Protocol=onsoctcp;UID=root;Password=toor");

Oded Over a year ago

@safraawi - I don't know. I have no idea about informix. The sample for .NET on connectionstrings.com would suggest that it should be: Provider=Ifxoledbc;Data [email protected];User ID=myUsername;Password=myPassword;

Collectives™ on Stack Overflow

How I can access Database running in UNIX OS using ASP.NET

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related