Thread: Help with setting Posgresql on Linux to work with ASP on win2k

I am running Postgresql on a Linux box. However I am also running ASP
on IIS on a Windows box.  How do I go about getting the ASP code to
talk to the Postgresql database?

I think there is a a ODBC driver for Postgressql, but do I install the
direr on the win2k box or on the Linux box?

Thanks for any help,

Arthur

On Tue, 2003-04-08 at 07:00, Arthur wrote:
> I am running Postgresql on a Linux box. However I am also running ASP
> on IIS on a Windows box.  How do I go about getting the ASP code to
> talk to the Postgresql database?
>
> I think there is a a ODBC driver for Postgressql, but do I install the
> direr on the win2k box or on the Linux box?

You install the ODBC driver on the Windows box. The ASP code talks via
the ODBC driver to the database.

--
Tim Ellis
Senior Database Architect and author, tedia2sql (http://tedia2sql.tigris.org)
If this helped you, http://svcs.affero.net/rm.php?r=philovivero

The easiest way I've found to do this was to just install pgAdminII
(http://pgadmin.postgresql.org/) on the Windows server... it comes with the
latest ODBC driver, and you get the benefits of pgAdminII :)

I do the same thing only with ColdFusion as my scripting language. Works
like a charm.

Brian

At 07:00 AM 4/8/2003 -0700, you wrote:
>I am running Postgresql on a Linux box. However I am also running ASP
>on IIS on a Windows box.  How do I go about getting the ASP code to
>talk to the Postgresql database?
>
>I think there is a a ODBC driver for Postgressql, but do I install the
>direr on the win2k box or on the Linux box?
>
>Thanks for any help,
>
>Arthur


_____
Brian Panulla                           brian@elmwoodmedia.com
Chief Information Officer               814.867.4087
Elmwood Media Group                     www.elmwoodmedia.com

hi,

look at http://gborg.postgresql.org/project/psqlodbc/

It has to be installed in win2k only and appropriate perm has to be given
in postgresql server (linux) to allow the client.

Regards,
S. Sukumar

On 8 Apr 2003, Arthur wrote:

> I am running Postgresql on a Linux box. However I am also running ASP
> on IIS on a Windows box.  How do I go about getting the ASP code to
> talk to the Postgresql database?
>
> I think there is a a ODBC driver for Postgressql, but do I install the
> direr on the win2k box or on the Linux box?
>
> Thanks for any help,
>
> Arthur
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>