Re: Connection String in ASP.NET application

roslyn(at)crimsonworks(dot)com(dot)sg ("Roslyn Teo") wrote in message news:<002901c37b7a$e100abd0$5201a8c0(at)rospc>...

> Can anyone kindly enlighten me on how to write a connection string from
> an ASP.NET application to PostgreSQL db without the use of Npgsql or
> other data providers?

You can use odbc but I use npgsql:

using Npgsql;

String connstring = "Server=xx.xx.xx.xx;Port=5432;User
id=user;Password=password;Database=dbname";

NpgsqlConnection conn = new NpgsqlConnection(connstring);

conn.Open();

DataSet ds = new DataSet();
da.Fill(ds,"mydataset");
conn.Close();

You can do all the .net stuff with npgsql. They've done a good job
with it.

Just download the npgsql.dll and add it to your web bin directory and
add a reference in your project.

If you want to use odbc just do some searches on google. There a few
how to articles but it's more complicated than npgsql.

-David