Re: Visual Studio 2005 not happy with postgresql

Hi Greg,

Thanks for replying!

- As I said, I'm using the latest version 8.01.01.01 and even tried the
8.01.01.00 version without success. What do you mean by "Try a different
version" ?

- How would I add a new .Net Framework Data Provider for Npgsql to
Visual Studio 2005 (I'm speaking about the Server Explorer GUI part, not
in code, which works)

- I have a default public schema, but it's empty, as I've created my own
one. I even tried to fill the public schema with a test table, in order
to check if it was pointing there. Not the case. I checked if there was
a way to "direct" VS2005 to the right schema. I tried using "Set
search_path to" in the connection setting (page 2 of the ODBC config
dialog) without success.

Any other ideas?

Thanks in advance for your help and best regards from Switzerland,

Tobias Britz
ER Systems SA

-----Original Message-----
From: Campbell, Greg [mailto:greg(dot)campbell(at)us(dot)michelin(dot)com]
Sent: mardi, 15. novembre 2005 21:43
To: Tobias Britz
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Visual Studio 2005 not happy with postgresql

1. There is a lot going on with the pgODBC driver versions? You could
try a different version.
2. You could try Npgsql -- the .NET data provider for Postgresql.
3. It sounds like you do not have a default schema of public -- I think
that happened and/or was fixed in one of the very recent version of
pgODBC .

Tobias Britz 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
> project 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
>