General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have a problem when accessing a db in postgreSQL.
On my server i have 2 databases. On the first i can access without problems.
On the second i receive this message when i try to create a remote view on its connection. When i create the connection i have no problems
The message is:
"The Remote View Wizard was unable to obtain column information for this remote table.
This may be the result of an ODBC error, or the remote table may not be owned by the current user. or the table doesn't have columns"
In this database i have one simple take with two fields and i am using the user postgres like the other db
Thanks
In general you do not want to use postgres as the user for the login. In fact in a normal install you are prevented from using the postgres user as a normal user. Create a user in the role /group rule. Then use that user to create the database.
I'll assume you are using the windows version - since you are on a foxpro forum. First make sure you have installed the postgres client software which should include 'psql'. Once that is install you can use psql from the command line and connect to the database to create the new user. Review help on google. After creating the user create the database use the new user. Test the connection first using psql. I'll assume that works. Then copy the connection string to odbc and it should work. If by chance you are not using a localhost then you will need to insure that the remote datatbase is accepting a connection. You will need an admin user and the port. Please check with google on how to setup the postgresql.conf and pg_hba.conf.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only