PostGres SQL ODBC connector

[slaughter]

Thanks all for help or ideas or just saying "make it by your self"

this is in case somebody neads it.

Func postgres_query($query)

$oConn = ObjCreate("ADODB.Connection")
$oRS = ObjCreate("ADODB.Recordset")

;~ set your database ip user & pass 

$line2 =    "DRIVER={PostgreSQL ANSI};DATABASE=Incoming_rates;" & _
            "SERVER=localhost;PORT=5432;Uid=odbc_usr;" & _
            "Pwd=odbc_password;" & _ 
            "A0=0;A1=6.4;A2=0;A3=0;A4=0;A5=0;A6=;A7=100;A8=4096;A9=0;" & _
            "B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_"

$oConn.Open ($line2)
$oConn.execute ($query)
$oConn.Close

EndFunc

Query shuld lok smth like this one

This is only explame queries

INSERT INTO Incoming_rates_1 (Destination, Area_Codes, Price, Valid_From) VALUES ('Andorra', '003760, 003761, 003762, 003767, 003768, 003769', '0,0235', '19.11.07');

I had problem when creating table from pgAdmin but when runig sql line work just fine

use sql line to create table as well to avoid errors.

CREATE TABLE Incoming_rates_1(
Destination text,
Area_Codes text,
Price text,
Valid_From text,
accessed timestamp
);

[GEOSoft]

Looks fine slaughter.

When you were looking for help with this I'm sure your forum search turned up this UDF.

#300756

[slaughter]

Looks fine slaughter.

When you were looking for help with this I'm sure your forum search turned up this UDF.

#300756

I used Mysql UDF as primary sample to understand how oject method is working.

But later used documentation and VB examples provided with postgres.

[LupusX]

slaughter

I "Copy & Past" yours script to scite, RUN and I get error code:

The requested action with this object has failed.
$oConn.open($line2) 
$oConn.open($line2)^ ERROR

What I doing wrong?

Do I need to install additional modules, drivers ?

Regards