[fdo-users] FDO 3.5, .net and PostGIS

[Brent Robinson]

Hi Matteo,

The PostgreSQL provider handles the connection a bit differently. It maps the FDO datastore to a PostgreSQL database, and then exposes all the schemas that are present. Try the following for service and datastore:

objConnProp.SetProperty("Service", < server:port>)
objConnProp.SetProperty("DataStore", <DBName>)

A fix was made to the trunk to improve the connection error message (show the error generated by the PostgreSQL server). However, this will not show up until the next version after FDO 3.5

Which providers would you be using to create the datastore in 3.5 and access it in 3.4?

Brent.

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Matteo
Sent: Wednesday, April 14, 2010 12:22 PM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] FDO 3.5, .net and PostGIS


Hi all,
  I import a shp schema on PostGIS through FDO Toolbox 0.9.3 (FDO 3.5). Now
I must be connect to the PostGIS schema with VB.NET and FDO 3.5. I use this
code:
objConnMan = ClientServices.FeatureAccessManager.GetConnectionManager()
objConn = objConnMan.CreateConnection("OSGeo.PostgreSQL.3.5")

objConnInfo = objConn.ConnectionInfo
objConnProp = objConnInfo.ConnectionProperties
objConnProp.SetProperty("Username", <User>)
objConnProp.SetProperty("Password", <Pass>)
objConnProp.SetProperty("Service", <DBName at server:port>)
objConnProp.SetProperty("DataStore", <schema>) (ex public)

When I try to execute the istruction objConn.Open()  I get this error
"RDBMS: Not connected to the specified database"
Anyone can help me?

I have another question. Is possible to work with FDO 3.4 on a schema
created with FDO 3.5?

King Regards,
Matteo

-- 
View this message in context: http://n2.nabble.com/FDO-3-5-net-and-PostGIS-tp4902636p4902636.html
Sent from the FDO Users mailing list archive at Nabble.com.
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users