(How) can I connect Visual Studio 2012 (Visual Basic) to a PostgreSQL database via ODBC (psqlodbc35W)?

Question

Hi,

Here I stand at the ragged edge of my development knowledge again . . . 

On my 64-bit Window 7 desktop I have successfully installed PostgreSQL 9.2 and its ODBC driver, psqlodbc35W.  I can readily access my PostgreSQL database from Excel 2010 as "Data from other sources" via Microsoft Query.

My intention is to use newly-installed Visual Studio 2012 to build visual Basic 2012 applications that will access my PostgreSQL database BUT I HAVE BEEN UNABLE TO CREATE A DATA CONNECTION OR GET VISUAL STUDIO 2012 TO RECOGNISE THE POSTGRESQL ODBC DRIVER. 

As ever, any and all advice will be very gratefully accepted.

Rgds,

Paul J

Answer 1

This is not the best forum for issues associated with third party, non-Microsoft, software packages.  Perhaps this link can helps.

http://wiki.postgresql.org/wiki/Using_Microsoft_.NET_with_the_PostgreSQL_Database_Server_via_ODBC   

I would seriously doubt that many of the participants on this forum use that driver. 

Rudy  =8^D

---

Mark the best replies as answers. "Fooling computers since 1971."

http://thesharpercoder.blogspot.com/

Answer 2

Rudy,

Thanks for your response.

I take your point about "third party, non-Microsoft, software packages".

However, the link you provided is very useful and contributes to my understanding of use of ODBC from Visual Studio.

Thanks again.

Paul J