Update: Visual Studio 2005 not happy with postgresql - Mailing list pgsql-odbc

From Leendert Paul Diterwich
Subject Update: Visual Studio 2005 not happy with postgresql
Date
Msg-id 437ddf81.053031b8.7b2c.38dd@mx.gmail.com
Whole thread Raw
In response to Re: Visual Studio 2005 not happy with postgresql  ("P.M" <pmdanger@yahoo.com>)
List pgsql-odbc

Hi All,

 

I reported this bug to MS:

 

http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?FeedbackId=4fa8f136-cdce-446e-b657-1d849156db58

 

When you also experience this problem, I urge you to vote for this problem (you will need a ms passport).

 

Cheers,

 

Paul

 


Tobias Britz <tobias.britz@ersystems.ch> wrote:

Hi community!

 

Here is my problem:

  • Postgresql 8.1 installed on windows XP (machine 1) with DB up and running. I can access/change/see all my tables, etc with EMS Postgresql manager
  • On Machine 2 (windows XP) I've installed the pg ODBC drivers 8.01.01 and created a System DSN to machine 1
  • I tested this DSN with MS Access, and I could see my tables, add items, launch queries
  • Now, I need to use Visual Studio 2005 (with .Net 2.0) for our pr oject and would like to be able to create XSD files visually (using the VS2005 built-in tools). In VS2005 Server Explorer, I created a new Database Connection, using the Microsoft ODBC Data Source (ODBC) with the .Net ODBC Data Provider selected. Pointed the thing to my working ODBC DSN and tested the connection
  • Connection works (says VS2005)
  • Now I have a new Data Connection in the Server Explorer, with 3 tree entries; Tables, Views, Procedures. My problem is that "Tables" is empty, "Views" is empty but "Procedures" contains hundreds of postgres functions.
  • I would like to see my tables and views!

Remark:

  • I tried OLEDB, whitout success either. VS2005 says that there where "some" errors and that "no work could be done"... cool he?!

Can someone please help me, as I've lost already 2 days figuring out what is going wrong here. I google nearly every forum about that..

 

Thanks in advance,

 

Tobias Britz

ER Systems SA

 

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

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Windows, ODBC drivers and strange points ...
Next
From: Claus Scherschel
Date:
Subject: Re: Invisible tables in Access 2000