Error with ASP...

From: "Lawren Benoit" <lawren(at)dymaxium(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Error with ASP...
Date: 1999-10-08 00:43:28
Message-ID: 000a01bf1126$2412bb20$580011ac@dymaxium.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hello,
I hope you can shed some light on my situation, perhaps. It's probably a simple thing I'm missing, but either way any help is really appreciated!

I am running a system with this configuration:
P-III 450, Win98, 64mb RAM
MS. Personal Web Server
PostgreSQL 6.4 installed.

Using Access, I was able to successfully link to an external db table and view it in Access through the PostgreSQL driver through ODBC. Now, I'd like to connect to this same database through ODBC in ASP 2.0 (VBScript) and pull a recordset out of it.

Using the standard Connection object setup (and also several different variations, trust me)...

Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=DSNNameInODBC;UID=;PWD"

... I always get this error message from the web server (quoting the 3rd line there as the source of the problem):

ADODB.Connection error '800a0e7a'
ADO could not find the specified provider.

Any ideas what I'm doing wrong here? Should I provide a provider name? Driver name? Use a DSN-less connection string? Is there anything special that I need to add to the connection string to make this connect in ASP?
Thanks again for any help you can provide,

Lawren

Browse pgsql-interfaces by date

  From Date Subject
Next Message Byron Nikolaidis 1999-10-08 01:32:26 [Fwd: PostgreSQL Help]
Previous Message Ravi 1999-10-07 20:53:23 Text type and ODBC driver