[Mono-list] Npgsql.dll

Carl Olsen carl at carl-olsen.com
Fri May 13 23:23:35 EDT 2005

Hi Francisco,

My web page is running on Apache and Linux using C# as the page language and
PostgreSQL as the database. I'm executing a stored procedure that creates a
temporary table and then returns the data from the temporary table to a
datagrid in the web page. A temporary table only exists while a connection
is open, so I open and close the connection in the page load event handler.
The problem I'm having is that when I hit the Refresh button in Internet
Explorer 6, I get an error message saying that the temporary table already
exists. I always thought the Refresh button reloaded the page, but
apparently not. How can I capture the event that occurs when the Refresh
button is selected? 

By the way, I thought Npgsql.dll was installed in the global assembly cache
by default in SUSE 9.2 Professional.  I just used Red Carpet to upgrade to
Mono 1.1.x, but it appears that Npgsql.dll is installed in the global
assembly cache.  That's where I copied it from to get it into the bin folder
of my web application.  I copied the Npgsql.dll file from

Carl Olsen 

-----Original Message-----
From: mono-list-bounces at lists.ximian.com
[mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Francisco
Figueiredo Jr.
Sent: Friday, May 13, 2005 9:54 PM
To: mono-list at lists.ximian.com
Subject: Re: [Mono-list] Npgsql.dll

Hash: SHA1

Carl Olsen wrote:
> I'm amazed.  I figured out how to connect to PostgreSQL and populate a
> datagrid today.

Hi Carl, congratulations!!

  The first problem I ran into was getting TCP/IP turned on
> in the postgresql.conf file.  The next problem was giving my IP address
> permission to connect in the pg_hba.conf file.  The biggest problem I ran
> into was calling the npgsql.dll assembly.  For some reason, it worked just
> fine from a console application written in C#, but it would not run from
> web page until I copied the npgsql.dll file in the bin folder of my web
> application.  I'm not sure if that is caused by the web application using
> the mod_mono.so file to run the compiler.

Did you add Npgsql.dll to global assembly cache?

If not, you must put your assemblies in bin folder in order to asp.net
find them.

> I'm not posting a link to the page, because I'm in the process of making
> changes to it, but it's a thrill to see an ASP.NET datagrid control
> up on my page as an HTML table full of data.

Very good to hear!

Please, let us know if you get any problem.

- --

Francisco Figueiredo Jr.
Npgsql Lead Developer
MonoBrasil Project Founder Member

- -------------
"Science without religion is lame;
religion without science is blind."

                  ~ Albert Einstein
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org


Mono-list maillist  -  Mono-list at lists.ximian.com

More information about the Mono-list mailing list