Manifold Community Site: Question regarding VBscript, Manifold, and connecting to PostgreSQL

RE: Question regarding VBscript, Manifold, and connecting to PostgreSQL

t-crow — Tue, 29 Apr 2008 14:07:42 GMT

Hello,

i'm hoping somebody can lend me some advice on this. i'm trying to use a VBscript to create a new Manifold document, import some data into it from PostgreSQL, which i will export to a specified directory (*needs to be in .mif format, otherwise i would just use psql2shp batch program), then close the document. i will schedule this script to run so it updates the directory everynight. here is my question...when approaching manifold through scripting outside of an active manifold session, why can't i establish a connection to the PostgreSQL database? i can import a shp file from my system into the created document, then save it, but i cannot do the same from PostgreSQL. here is some example code so you can see what i'm trying to accomplish.

'VBscript

set Application = createobject("Manifold.Application")

set Newdoc = Application.NewDocument("", False)

set shpImporter = Newdoc.NewImport("SHP")

shpImporter.import "C:\SomeFile.shp"

Newdoc.saveas "C:\NewDocument.map"

this first simple piece of code works flawlessly, here is an example when trying to accomplish the same thing but from PostgreSQL....

'VBscript

set Application = createobject("Manifold.Application")

set Newdoc = Application.NewDocument("", False)

set ds = Newdoc.NewDatasource()

ds.connectionType = "PostgreSQL"

server = "localhost"

port = "5432"

username = "somename"

password = "somepsswrd"

database = "somedbase"

ds.ConnectionString = "host='" + server + "' port='" + port + "' user='" + username + "' password='" + password + "' dbname='" + database + "'"

ds.importtable("FileNameIndex")

Newdoc.saveas "C:\NewDocument.map"

this second example of code fails when trying to import from PostgreSQL, however the PostgreSQL import mechanism works great if i run it from the Manifold GUI.

I have also tried this using Python and i run into the same problem, connection to PostgreSQL fails

Note: i have both manifold 64bit and 32bit, both connect fine to postgreSQL from the GUI and i'm running build 8.0.6.0

hoping someone can understand what i'm trying to accomplish and shed some light on how i might be able to make this work

thanks

t-crow

RE: Question regarding VBscript, Manifold, and connecting to PostgreSQL

AR_Rick — Tue, 29 Apr 2008 14:22:38 GMT

Copy the PostgreSQL client DLL libraries into c:\windows\system32.

RE: Question regarding VBscript, Manifold, and connecting to PostgreSQL

t-crow — Tue, 29 Apr 2008 15:03:49 GMT

Rick,

thanks, this seems to have solved the problem, also seems to have cleared up my error with python also.

RE: Question regarding VBscript, Manifold, and connecting to PostgreSQL

lionel_ — Wed, 27 Aug 2008 06:49:46 GMT

1)seem there is a better way to register dll/ocx wihtout move the dll to C:\window\system32

is to use regsvr32 with option or use it with contextual menu after install the *.reg file

then when go to the directory where dll is locate you could use the contextual menu

2) this make me think about gacutil is look like very similar

http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=713

http://www.nirsoft.net/dot_net_tools/gac_viewer.html

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=718831&SiteID=1

Attachments:
regsevr0.jpg

RE: Question regarding VBscript, Manifold, and connecting to PostgreSQL

lionel_ — Wed, 27 Aug 2008 07:05:32 GMT

ocx dll

dll .net

.Net dll

RE: Question regarding VBscript, Manifold, and connecting to PostgreSQL

AR_Rick — Wed, 03 Sep 2008 07:25:04 GMT

The PostgreSQL DLLs aren't COM libraries or .NET assemblies, they're just regular procedural DLLs, so they need to be in the correct search path.

RE: Question regarding VBscript, Manifold, and connecting to PostgreSQL

lionel_ — Thu, 04 Sep 2008 07:56:05 GMT

yes see discover that don't work after i writing this .so was aware of the problem but can 't know the reason .is there tutorial on the net that explain how many type of dll exist ? don't have the good/suit words that ll return the best link in search engine .

""A procedural object is created by an algorithm that takes a set of parameters that define the object and produces the object representation from that set."""

=> all object is create by function ( initialisation affectation) so difficult to understand !

know language oriented and procedural but not dll !!

does it refer to the language/registry prameters ?