The ODBC driver does not have to be installed on the server.
"Mike_red" <haffi_get_beaten(at)hotmail(dot)com> wrote in message
news:9813b8ce(dot)0312010525(dot)3db4aee4(at)posting(dot)google(dot)com(dot)(dot)(dot)
> Hello,
> I am a newbie at programming asp with odbc. I usually write perl or
> php scripts, but now i need a asp script
>
> The asp script will run on a windows nt platform with an postgreSQL
> odbc against a PostgreSQL on a Debian Linux.
>
> I have tried several ways, but i can't open the connection.
> All help and suggestions appreciated.
>
> All the following tests have given nothing:
>
> 1-----
> dim connstr
> Set conn = Server.CreateObject("adodb.connection")
>
> connstr = "Provider=MSDASQL.1;" & _
> "Persist Security Info=False;Extended " & _
> "Properties=""DRIVER={PostgreSQL+ (Beta)};" & _
> "DATABASE=DB;SERVER=IP;PORT=5432;" & _
> "UID=USER;PWD=PASS;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;" & _
> "ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;" & _
> "ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;" & _
> "MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=0;" & _
> "CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;" & _
> "TextAsLongVarchar=1;UnknownsAsLongVarchar=0;" & _
> "BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;" & _
> "ExtraSysTablePrefixes=dd_;;LFConversion=1;" & _
> "UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"""
>
> conn.Open connstr
>
> 2 --------
> Set conn = CreateObject("adodb.connection")
> conns.ConnectionString =
>
"DRIVER={PostgreSQL};SERVER=IP;port=5432;DATABASE=DB;UID=USER;PWD=PASSWORD;"
> conn.Open
>
> 3 --------
>
> Set conn = CreateObject("adodb.connection")
> Dim connstr
>
> connstr = _
> "DSN=NAME;DATABASE=DB;" & _
> "SERVER=IP;PORT=5432;UID=USER;PWD=PASSWORD;"
>
> conn.Open connstr
>
> ------------------
>
> What can be wrong?
> As soon as i test the conn.open i the script fails
>
> / m