Home > Archive > PostgeSQL ODBC > November 2005 > Update: Visual Studio 2005 not happy with postgresql









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Update: Visual Studio 2005 not happy with postgresql
Leendert Paul Diterwich

2005-11-18, 11:23 am

Hi All,



I reported this bug to MS:



http://lab.msdn.microsoft.com/Produ...px?FeedbackId=4
fa8f136-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


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com