pgsqlDataAdapter configuration
Posted: Sun 10 Jul 2005 01:35
Hi, i am new to postgresql database and i am using the latest trial version of the postgresqldirect.net prvider to connect it to .Net(1.1 - visual studio 2003).
I have been able to successfully establish a connection to the postgresql database, and i am now trying to configure a data adapter.
i have two tables in the database named User and Utility. When configuring the Dataadapter and on selecting tableDirect type, the tables appear in the table object name combobox as 'public.User' and 'public.Utility'. when i select any of these names and try and generate the insert ,update and delete commands, i get the error,
relation 'public.User' does not exist
Could you tell me if i am doing something wrong or there is some configuration i have left out.
any help whatsoever will be appreciated
I have been able to successfully establish a connection to the postgresql database, and i am now trying to configure a data adapter.
i have two tables in the database named User and Utility. When configuring the Dataadapter and on selecting tableDirect type, the tables appear in the table object name combobox as 'public.User' and 'public.Utility'. when i select any of these names and try and generate the insert ,update and delete commands, i get the error,
relation 'public.User' does not exist
Could you tell me if i am doing something wrong or there is some configuration i have left out.
any help whatsoever will be appreciated