Re: ASP ODBC postgreSQL newbie problem - Mailing list pgsql-odbc

From nobody
Subject Re: ASP ODBC postgreSQL newbie problem
Date
Msg-id bqj0nb$1v3n$1@news.hub.org
Whole thread Raw
List pgsql-odbc
The ODBC driver does not have to be installed on the server.
"Mike_red" <haffi_get_beaten@hotmail.com> wrote in message
news:9813b8ce.0312010525.3db4aee4@posting.google.com...
> 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



pgsql-odbc by date:

Previous
From: mark@bravo.mcphersontimberlands.com
Date:
Subject: odbc and crypt authentication
Next
From: "Dave Page"
Date:
Subject: Re: odbc and crypt authentication