Creating tables from VB

From: Neil Ernstzen <nde(at)baxterslc(dot)uct(dot)ac(dot)za>
To: pgsql-novice(at)postgresql(dot)org
Subject: Creating tables from VB
Date: 2001-01-12 14:42:19
Message-ID: 3A5F17CB.4D6D7677@baxterslc.uct.ac.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

How do I create tables from VB6 to Postgresql data source which is
located on a network?

My programme bombs out at this stage:

Public Function CreateTables()

'First, connect to MSDE:
ocon.ConnectionString = "Provider=MSDASQL.1;Persist Security
Info=False;User ID=nernstzen;Data Source=PostgreSQL"
ocon.Open

'Define the database objects required:
'Dim oDatabase As sqldmo.Database
Dim oDatabase As Object
Set oDatabase = CreateObject("sqldmo.Database")

'Dim colUsername As New sqldmo.Column
Dim colUsername As Object
Set colUsername = CreateObject("sqldmo.Column")

'Select the database that tables will be added to:
' Get the XYZ database
Set oDatabase = ocon.databases("XYZ").....................

At this stage my programme says "Arguments are of the wrong type,are out
of acceptable range, or are in conflict with one another". Thanks

AND

What is the Postgresql equivalent of SQLDMO?

Browse pgsql-novice by date

  From Date Subject
Next Message mat 2001-01-12 15:35:42 problem with pg_dump
Previous Message Barry Stewart 2001-01-12 13:19:24 Pg subtracts one minute from time