Hi,
I just worked two days trying to connect to a PostgreSQL. So I thought
maybe someone is interested in the results.
At the moment I'm experimenting with the ProviderFactory from Mono. So I
tried to use it to connect to our PostgreSQL. The first problem was,
that I couldn't find a good .NET Data Provider. ByteFX
(
http://sourceforge.net/projects/mysqlnet/) doesn't have a
ConnectionString (which is needed for ProviderFactory and public
property of IDbConnection) and Npgsql
(
http://gborg.postgresql.org/project/...rojdisplay.php) is still in
a beta stadium and not ready to get imported in GAC (I'm glad if someone
can help me with an easy solution). So I switched to ODBC.NET. First I
didn't understand that I have to include the server in the
ConnectionString (eg:
"Driver={PostgreSQL};dsn=MyDSN;database=MyDB;uid=sa;pwd=sa;server=MyServer").
Without the server you always get "ODBCException ERROR - No
information", which gives you not very much information. ;-) Then I had
a lot of problems with the PostgreSQL ODBC (7.03.01.00). IIS crashed
every time. But when I switched back to version 7.02.00.05 everything
worked fine.
Comments are welcome.
Christoph
Similar Threads
