Re: IIS Postgres ASP ADO - Problem

I have not tried 2003 with 8.0.3 driver, but I did use 2003 with the 7.4
driver, so you may want to grab that driver just to see if there is any
difference.

Only other idea I might ask is how recent is your mdac stuff.
Not sure it makes a difference, but might if adding server and trying the
7.4 odbc drive don't help, but I am confused because your getting the error
before it is trying to use odbc, its erroring on the creation of the object.
What did the creation look like for the MDB?

I use
Set cConn = Server.CreateObject("ADODB.CONNECTION")
Not sure if server. Makes any difference?
At this point I don't think it knows anything about the connection its just
creating an object.

It does not need the connection info until it is opened.
Again I use this string for the connection (not dsn).
Session("StringConn") =
"DRIVER={PostgreSQL};DATABASE=wazagua;SERVER=192.168.123.121;PORT=5432;UID=p
ostgres;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersi
oning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=
0;MaxVarcharSize=254;MaxLongVarcharSize=16280;Debug=0;CommLog=0;Optimizer=1;
Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAs
Char=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;U
pdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBina
ry=0;UseServerSidePrepare=0"

And I open it using
cConn.Open Session("StringConn")
Joel Fradkin

-----Original Message-----
From: James Dornan [mailto:james(at)catch22(dot)com]
Sent: Monday, August 01, 2005 4:13 PM
To: Joel Fradkin
Subject: Re: [SPAM Score: 3.1] RE: IIS Postgres ASP ADO - Problem

I'm still in the same boat. ODBC does seem to work, but does not
load when accessing from an ASP page under IIS 6. I'm trying to
quickly convert an application from using MDB files to Postgres.
I wrote a quick little VB script and it was able to access Postgres
without complaint. But the ASP web pages are not able to load
the Postgres ODBC drive. ASP can use ODBC to access MDB files.
I'm not sure what part of IIS 6 prevents this.

Sadly if I fail in this the company will not continue down the path
of open source.

Here is the error message I get.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Specified driver could not be loaded due to system error 998
(PostgreSQL-libpq).

/test.asp, line 10

Here is line 10

Set cn = CreateObject("ADODB.Connection")

Joel Fradkin wrote:

>The stuff I send help you?
>If not I did get help switching from 7.4 to 8.0
>Basically it told me to look in registry for where it points for the odbc
>driver.
>I had issues myself, eventually I removed everything and installed from the
>odbc download (making sure there was no reference in the registry and no
>psqlodbc.dll on the system. I then installed from the download menu off
>postgres.org site. It installed and worked. The I could install postgres
>8.0.3 (not using the odbc from it). Finally I ended up building my own
>psqlodbc.dll using the csv, but I am still using the 7.4 drivers for my
>production as my data base is SQLASCII with French chars in it and I have
to
>get it converted to Unicode to use the new drivers.
>I have got Unicode databases and the latest drivers in test environments.
>I can appreciate the frustration, I lost the odbc when I tried a commercial
>driver for whatever reason my odbc got messed up and I spent most of the
day
>goofing around until the complete uninstall and just loading odbc seemed to
>get working again. I had postgres on a different computer as well so I
could
>see when the odbc started to work again, plus I already had working
>connections etc.
>
>What errors you getting?
>
>Joel Fradkin
>
>Wazagua, Inc.
>2520 Trailmate Dr
>Sarasota, Florida 34243
>Tel. 941-753-7111 ext 305
>
>jfradkin(at)wazagua(dot)com
>www.wazagua.com
>Powered by Wazagua
>Providing you with the latest Web-based technology & advanced tools.
>C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
> This email message is for the use of the intended recipient(s) and may
>contain confidential and privileged information. Any unauthorized review,
>use, disclosure or distribution is prohibited. If you are not the intended
>recipient, please contact the sender by reply email and delete and destroy
>all copies of the original message, including attachments.
>
>
>
>
>-----Original Message-----
>From: James Dornan [mailto:james(at)catch22(dot)com]
>Sent: Sunday, July 31, 2005 4:44 PM
>To: jfradkin(at)wazagua(dot)com
>Subject: IIS Postgres ASP ADO - Problem
>
>
> I noticed more than a few post from you about trying to get Postgres
>working with ODBC.
>I'm hoping that maybe you would share some of that information. I am
>running IIS under
>windos 2003 server, and the latest(8.0.3) Postgres server on the same
>machine. I cannot
>connect no matter what I do. I have tried everything.
>
> The funny part is that I'm not new to ODBC, or windows. I've worked
>with windows all
>the time, but just can't figure this one out. I've tried using a
>connection string, a DSN,
>reinstalling, IIS, Postgres, ODBC drivers, MDAC, Jet, and so on. I still
>have the same problem.
>The odbc drive and it's dependant DDLs are in the path. The permisions
>are wide open
>(for testing this specific problem).
>
> Is there any insight you could shed on the dark world of windows and
>ODBC, where feed-
>back is rare.
>
> Thanks for any help you can provide.
>
>-- James
>
>
>
>