Received: from titan.tcn.net (root@titan.tcn.net [199.166.4.2]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA65606 for ; Thu, 7 Oct 1999 20:43:36 -0400 (EDT) (envelope-from lawren@dymaxium.com) Received: from cinquante (hadrian.velocet.net [216.126.81.2]) by titan.tcn.net (8.8.5/8.6.9) with SMTP id UAA21500 for ; Thu, 7 Oct 1999 20:38:31 -0400 (EDT) Message-ID: <000a01bf1126$2412bb20$580011ac@dymaxium.com> From: "Lawren Benoit" To: Subject: Error with ASP... Date: Thu, 7 Oct 1999 20:43:28 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01BF1104.9C3F51C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 This is a multi-part message in MIME format. ------=_NextPart_000_0007_01BF1104.9C3F51C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 =3D Server.CreateObject("ADODB.Connection") Conn.Open "DSN=3DDSNNameInODBC;UID=3D;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'=20 ADO could not find the specified provider.=20 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,=20 Lawren ------=_NextPart_000_0007_01BF1104.9C3F51C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

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

I am running a system with this=20 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=20 external db table and view it in Access through the PostgreSQL driver = through=20 ODBC. Now, I'd like to connect to this same database through ODBC = in ASP=20 2.0 (VBScript) and pull a recordset out of it.

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

Dim Conn

Set Conn =3D=20 Server.CreateObject("ADODB.Connection")

Conn.Open = "DSN=3DDSNNameInODBC;UID=3D;PWD"

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

ADODB.Connection=20 error '800a0e7a'

ADO could = not find the=20 specified provider.

Any ideas what I'm doing wrong = here? Should I=20 provide a provider name? Driver name? Use a DSN-less = connection=20 string? Is there anything special that I need to add to the = connection=20 string to make this connect in ASP?

Thanks again for any help you can provide,

Lawren

------=_NextPart_000_0007_01BF1104.9C3F51C0--