carl at carl-olsen.com
Fri May 13 23:23:35 EDT 2005
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
From: mono-list-bounces at lists.ximian.com
[mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Francisco
Sent: Friday, May 13, 2005 9:54 PM
To: mono-list at lists.ximian.com
Subject: Re: [Mono-list] Npgsql.dll
-----BEGIN PGP SIGNED MESSAGE-----
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
> 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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----
Mono-list maillist - Mono-list at lists.ximian.com
More information about the Mono-list