Datasource enumerator cannot detect postgres servers

Datasource enumerator cannot detect postgres servers

Postby dghundt » Wed 03 Sep 2008 20:30

I have used the following code to detect postgreql hosts on my lan, but datatable remains empty. It compiles fine.

Code: Select all
               
PgSqlDataSourceEnumerator instance = PgSqlDataSourceEnumerator.Instance;
DataTable dtSQLServers = instance.GetDataSources();
foreach (DataRow drServer in dtSQLServers.Rows)
        {
                    String ServerName;
                    ServerName = drServer[0].ToString();
                               .....
         }


When I use VS 2005 data connection wizard, I cannot detect any postgres server Hosts after scanning the network either. If I type in the correct server name, I can then connect just fine. This makes me think that postgresqldirect.net cannot auto detect postgres hosts.

I can use similar mssql code to detect mssql hosts on my lan.

Using postgresql v 8.2
Using postgresqldirect.net 3.70.28.0
Last edited by dghundt on Wed 03 Sep 2008 23:02, edited 1 time in total.
dghundt
 
Posts: 38
Joined: Thu 24 Aug 2006 01:16

Postby dghundt » Wed 03 Sep 2008 23:01

upgrading to the most recent build fixed the issue.
dghundt
 
Posts: 38
Joined: Thu 24 Aug 2006 01:16


Return to dotConnect for PostgreSQL