Re: ASP ODBC postgreSQL newbie problem

this works:

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConnectionString

what's the error-message displayed ?
did you install the odbc-driver on the server ?

if you don't get an error message, you have to enable detailed error
reporting to the client on your asp server.



"Mike_red" <haffi_get_beaten@hotmail.com> schrieb im Newsbeitrag
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