Thread: working with ODBC driver

working with ODBC driver

From
Robert Carbonari
Date:
Hi,

I'm using VBscript and ADO on my station to manipulate , via the ODBC
driver, a table on Postgres which is sitting in a Linux server.  
I can Read information from the table (which I entered manually through
PgAdmin), but I can't add new rows to the table through the script.  The
script abends after trying to execute the (ADO) AddNew method.  What's
wrong?  Does Postgres not understand this command?  Should I use ODBC
directly to work with the table?  


Robert Carbonari
Programmer
Optimal Robotics Corp.
e-mail: robertc@optimal-robotics.com
phone:  (514)738-8885 ext. 146




Re: [INTERFACES] working with ODBC driver

From
Herbert Ambos
Date:
i had the same problem, but i use MS Access 97 as an interface.  Could
somebody tell us on what procedures to embark (or script/code) just to
manipulate (add/delete/vacuum/create...) the database at the back end
server.  I tried to searc the net about this but i didn't got the info.
Thanks in advance.

Herbert Ambos
Iligan City, Philippines

> 
> Hi,
> 
> I'm using VBscript and ADO on my station to manipulate , via the ODBC
> driver, a table on Postgres which is sitting in a Linux server.  
> I can Read information from the table (which I entered manually through
> PgAdmin), but I can't add new rows to the table through the script.  The
> script abends after trying to execute the (ADO) AddNew method.  What's
> wrong?  Does Postgres not understand this command?  Should I use ODBC
> directly to work with the table?  
> 
> 
> Robert Carbonari
> Programmer
> Optimal Robotics Corp.
> e-mail: robertc@optimal-robotics.com
> phone:  (514)738-8885 ext. 146
> 
> 
>