Problems with Databases that don't use Schema

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
lloyd
Posts: 1
Joined: Thu 24 Jan 2008 07:33

Problems with Databases that don't use Schema

Post by lloyd » Thu 24 Jan 2008 07:53

The problem is that 6 out of the 7 servers that I work with are setup without using schema. The one that uses it works great. The problem is that I am trying to write a program to connect to one that does not use schema.

Here is what I did.

Tools -> PostgreSQL -> DataSet Wizard

Click > to continue

Choose New Dataset "DataSet1"
Use Provider Specific Code is checked

Click > to continue

Check "Show all schemas" (does not matter if unchecked)
Check "Share connection"
Select either type of Data Source (it does not matter, tried both)
Click the button

Enter User ID
Enter Password
Enter Host
Enter Database
Leave Schema blank (also tried "." as I saw somewhere on the forums, but then the test connection will fail.)
Click button
Shows "Successfully connected.
Click the button.
Click the button.
Click the + sign in front of the pgSQLConnection1 (Newly created)

Then the error message appears.
Relation "pg_namespace" does not exist

The Info from the connection test is:
Client:
Encoding
Server:
Version PostgreSQL 7.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Encoding
Autocommit
Security:
Password Encryption
SSL
Any help would be appreciated.

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Fri 25 Jan 2008 11:54

We couldn't reproduce the error.
The Info from the connection test is:
...
SSL
Do you use SSL connections? Unfortunately PostgreSQLDirect .NET doesn't support encrypted connections. Try using connections without SSL if possible.

Please send me a small test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include the
definition of your own database objects.
Do not use third party components.
If it is impossible for you to create the test project, send us a piece of
your code where the error occurs.

Post Reply