Thirt
asked on
How to use Npgsql by pgFoundry (.NET) in VS2005
Creating my first project in Visual Studio 2005 and having problems setting up a Data Connection to our Postgres SQL database. Originaly I tried to use the ODBC DSN that I have bee using to date for my Access applicaitons, but the table names are not displaying.
It was suggested to use Npgsql by pgFoundry (.NET). The directions call to place the npgsql dll into the project folder. But I do not see any options in the ADD COnnection wizard to pick a native .net driver for Postgres. I just see the option for ODBC and OLE-DB, which also fails.
Anyone using VS2005 against the Postrges SQL server with the native postgress .net driver?
It was suggested to use Npgsql by pgFoundry (.NET). The directions call to place the npgsql dll into the project folder. But I do not see any options in the ADD COnnection wizard to pick a native .net driver for Postgres. I just see the option for ODBC and OLE-DB, which also fails.
Anyone using VS2005 against the Postrges SQL server with the native postgress .net driver?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, testing the trial version and if it works, work the $$.
But since we are using schemes in PG, appears that each scheme gets it's own connection. Can I make a query that ties in data between two connections?
But since we are using schemes in PG, appears that each scheme gets it's own connection. Can I make a query that ties in data between two connections?
If you do not specify a schema in the connection string it will use the default schema public.
If you specify a schema that schema will be used by default.
If you need to reference a schema other than the default you need to specify the schema in your query.
For example.
select t1.*, t2.*
from
schema1.tablename t1
, schema2.tablename t1
where
t1.key = t1.key
If you specify a schema that schema will be used by default.
If you need to reference a schema other than the default you need to specify the schema in your query.
For example.
select t1.*, t2.*
from
schema1.tablename t1
, schema2.tablename t1
where
t1.key = t1.key
ASKER
Thanks!
I would like to use the connection string without the scheme and include the scheme name in the query. However, when I build the connection without the Scheme identified, it appears to be default to the Public Scheme, which just contains a test table. I don't see the other schemas.
I would like to use the connection string without the scheme and include the scheme name in the query. However, when I build the connection without the Scheme identified, it appears to be default to the Public Scheme, which just contains a test table. I don't see the other schemas.
ASKER
Ok, you were right, I will close this out.
But can you do me a favor and look at this issue: https://www.experts-exchange.com/questions/22695419/How-to-create-Update-SQL-for-Postgres-in-VS2005.html
I just can't seem to setup the Update SQL in VS2005 to work with Postgres.
But can you do me a favor and look at this issue: https://www.experts-exchange.com/questions/22695419/How-to-create-Update-SQL-for-Postgres-in-VS2005.html
I just can't seem to setup the Update SQL in VS2005 to work with Postgres.
ASKER