I am getting a "An address incompatible with the requested protocol was used" when trying to to do a domain build with Postgres. The environment :

Windows 7 32 bit. Visual Studio 2008 Postgres 8.4

As well as my application i have tried the consol sample and that gives the same error. I have diabled the firewall with the same result. Both pgAdmin and the command line sql utility can connect and work without errors.

I did the same thing with the consol sample on an xp machine and it works fine.

Any ideas.

10/11/2009 18:47:47 Error   General Error building DO4 Database - Npgsql.NpgsqlException:
An address incompatible with the requested protocol was used
   at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)
   at Npgsql.NpgsqlConnector.Open()
   at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
   at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
   at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
   at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
   at Npgsql.NpgsqlConnection.Open()
   at Xtensive.Sql.PostgreSql.DriverFactory.CreateDriver(UrlInfo url) in c:\TeamCity\buildAgent\work\6a5d81309423096e\Xtensive.Sql\Xtensive.Sql.PostgreSql\DriverFactory.cs:line 22
   at Xtensive.Sql.SqlDriver.GetDriver(UrlInfo url) in c:\TeamCity\buildAgent\work\6a5d81309423096e\Xtensive.Sql\Xtensive.Sql\SqlDriver.cs:line 246
   at Xtensive.Sql.SqlDriver.Create(UrlInfo url) in c:\TeamCity\buildAgent\work\6a5d81309423096e\Xtensive.Sql\Xtensive.Sql\SqlDriver.cs:line 196
   at Xtensive.Storage.Providers.Sql.Driver..ctor(UrlInfo url) in c:\TeamCity\buildAgent\work\6a5d81309423096e\Xtensive.Storage\Xtensive.Storage.Providers.Sql\Driver.cs:line 110
   at Xtensive.Storage.Providers.Sql.DomainHandler.Initialize() in c:\TeamCity\buildAgent\work\6a5d81309423096e\Xtensive.Storage\Xtensive.Storage.Providers.Sql\DomainHandler.cs:line 206
   at Xtensive.Storage.Building.Builders.DomainBuilder.CreateDomainHandler() in c:\TeamCity\buildAgent\work\6a5d81309423096e\Xtensive.Storage\Xtensive.Storage\Building\Builders\DomainBuilder.cs:line 148
   at Xtensive.Storage.Building.Builders.DomainBuilder.BuildDomain(DomainConfiguration configuration, DomainBuilderConfiguration builderConfiguration) in c:\TeamCity\buildAgent\work\6a5d81309423096e\Xtensive.Storage\Xtensive.Storage\Building\Builders\DomainBuilder.cs:line 52
   at Xtensive.Storage.Upgrade.UpgradingDomainBuilder.BuildStageDomain(UpgradeStage stage) in c:\TeamCity\buildAgent\work\6a5d81309423096e\Xtensive.Storage\Xtensive.Storage\Upgrade\UpgradingDomainBuilder.cs:line 113
   at Xtensive.Storage.Upgrade.UpgradingDomainBuilder.Build(DomainConfiguration configuration) in c:\TeamCity\buildAgent\work\6a5d81309423096e\Xtensive.Storage\Xtensive.Storage\Upgrade\UpgradingDomainBuilder.cs:line 66
   at Xtensive.Storage.Domain.Build(DomainConfiguration configuration) in c:\TeamCity\buildAgent\work\6a5d81309423096e\Xtensive.Storage\Xtensive.Storage\Domain.cs:line 286
   at NNet.Framework.DO.Configuration.DomainBuilder.Build() in D:\Project\NNet-Web\NNet\Framework\DO\Configuration\DomainBuilder.cs:line 15 {UserName}  {SiteName}  5
10/11/2009 18:47:47 Error   General System.Net.Sockets.SocketException: An address incompatible with the requested protocol was used
   at System.Net.Sockets.Socket.DoBind(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalBind(EndPoint localEP)
   at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)
   at System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)
   at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)    {UserName}  {SiteName}  5

Updated at 11.11.2009 11:43:48

Great thanks for the reply, I had googled before I submitted the request, but missed the solution that you replied with. When I get it working I'll post the solution as other people may have the same problem.

On a separate issue, I am changing from SqlServer 2008 which I used for DO3 to Postgres for DO4 (mainly due to cost) have you done any performance comparisons between Postgres and SQLServer 2008 for DO4.

tony

Updated at 11.11.2009 15:24:31

Thanks I'll give that provider a go.

I did notice two days a go when I was investigating my postgres there was a later version of the provider available then the one bundled with the DO4 install, I tried it but it did not make any difference. I don't know if this version contains your fix.

This thread was imported from our support forum. The original discussion may contain more detailed answer.