Hello all,

I've had some experience in accessing a PostgreSQL database, running on
Linux, from remote clients with Perl (DBI, DBD), also on Linux. Only
Perl/Linux.

But know I need to know if it is possible to access PortgreSQL (running
on Linux) with the Microsoft Develpment Languages and API's on the
client side ????

.... is it possible to access PG (on Linux) from a Windows machine using
the 'traditional' Microsoft languages/API's (C#, VB, etc) ????

.... I really don't know the MS dev tools very well !!!... but I need to
help a student make some initial decisions on his project !!!


Thank you all.

Joao Ferreira




---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

jmf@estg.ipvc.pt (Joao Miguel Ferreira) wrote in
news:1141747974.2340.142.camel@sandoval:

> Hello all,
>
> I've had some experience in accessing a PostgreSQL database, running on
> Linux, from remote clients with Perl (DBI, DBD), also on Linux. Only
> Perl/Linux.
>
> But know I need to know if it is possible to access PortgreSQL (running
> on Linux) with the Microsoft Develpment Languages and API's on the
> client side ????
>
> ... is it possible to access PG (on Linux) from a Windows machine using
> the 'traditional' Microsoft languages/API's (C#, VB, etc) ????

It should at least work with ODBC. I haven't familiarised myself with
..NET so i am not really shure what that is, but i guess there is some
possibilites there also.

Here is a list of interfaces
<http://www.postgresql.org/docs/interfaces>

I think the main page for ODBC is
<http://pgfoundry.org/projects/psqlodbc/> but have look at
<http://www.postgresql.org/ftp/odbc/> also.

E.g. Microsoft Access VBA
===========================
Dim tstODBC As Workspace
Dim conODBC As Connection
Dim rcs As Recordset
Dim ConStr as string

ConStr = "ODBC;" & _
"DRIVER={PostgreSQL};" & _
"SERVER=servername;" & _
"READONLY=0;" & _
"DATABASE=databasename;" & _
"UID=username;" & _
"PWD=password"
Set tstODBC = CreateWorkspace("", "", "", dbUseODBC)
Set conODBC = tstODBC.OpenConnection("", dbDriverNoPrompt, _
False, ConStr )

Set rcs_login = conODBC.OpenRecordset("select username",dbOpenSnapshot)
============================

--
Rolf

--- Joao Miguel Ferreira <jmf@estg.ipvc.pt> wrote:

> Hello all,
>
> I've had some experience in accessing a PostgreSQL
> database, running on
> Linux, from remote clients with Perl (DBI, DBD),
> also on Linux. Only
> Perl/Linux.
>
> But know I need to know if it is possible to access
> PortgreSQL (running
> on Linux) with the Microsoft Develpment Languages
> and API's on the
> client side ????
>
> ... is it possible to access PG (on Linux) from a
> Windows machine using
> the 'traditional' Microsoft languages/API's (C#, VB,
> etc) ????
>
> ... I really don't know the MS dev tools very well
> !!!... but I need to
> help a student make some initial decisions on his
> project !!!
>
>
> Thank you all.
>
> Joao Ferreira

i have no experience here, but wanted to try and
answer your question. i woul dbe surprised if you
couldn't. i think ms dev tools support odbc - and i
think pgsql does, too.

you may find more information in the manual:

http://www.postgresql.org/docs/8.1/i...-accessdb.html

http://www.postgresql.org/docs/8.1/i...nterfaces.html

good luck.


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend