[Mono-list] Npgsql.dll

[Carl Olsen]

I got around my problem by doing a "try ... catch" around the database
connection and doing a redirect back to the page in the "catch" section.
It's not perfect, but it keeps the page from throwing an error when I hit
the refresh button.

-----Original Message-----
From: mono-list-bounces at lists.ximian.com
[mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Carl Olsen
Sent: Friday, May 13, 2005 10:24 PM
To: 'Francisco Figueiredo Jr.'; mono-list at lists.ximian.com
Subject: RE: [Mono-list] Npgsql.dll

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
/usr/lib/mono/Npgsql/1.0.5000_0.5d8b90d52f46da7

Carl Olsen 
http://www.carl-olsen.com/

-----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

-----BEGIN PGP SIGNED MESSAGE-----
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
my
> 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
showing
> up on my page as an HTML table full of data.
> 

Very good to hear!

Please, let us know if you get any problem.


- --
Regards,

Francisco Figueiredo Jr.
Npgsql Lead Developer
http://gborg.postgresql.org/project/npgsql
MonoBrasil Project Founder Member
http://monobrasil.softwarelivre.org


- -------------
"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

iQEVAwUBQoVoZP7iFmsNzeXfAQK8KAf9HVzjuxvN9UL1ZReLH2en3VlRU28vVkuH
7l0tkonitbZKWrcF6e7pynZqjStUrXPynW4pCekrtU5dJBphktm1ACkC5XZWNuCB
MPPRpYT7rSlUmolPvN6p0U96kWLNSE7pmD2DXW+aXASXOGQ0NOyotAHi5xgzpRr/
6p9IzCVMg3PO91LEl5f8oqtj6GV09YFHWz5BvYrMM9ReqgNgwsQLP+1Bgfjct4td
k+Zq6KULFH35gIe5zPLEASHvQ0fxEahNFZSOKsxNlVBcFkrrA/hw9cAOTPLAMQ7g
w4vCHdphNlzEg9GRRzuI651qXLTfjjxd3DKf0qfuB1pt2290iNVo7A==
=KIp0
-----END PGP SIGNATURE-----

_______________________________________________
Mono-list maillist  -  Mono-list at lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list



_______________________________________________
Mono-list maillist  -  Mono-list at lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list