Arí Ricardo Ody wrote: > At 13:40 21/3/2009, you wrote: > >> Try copying all the dll's in the postgres bin directory to >> C:\WINDOWS\system32 >> I have just created a test app with only TPQConnection filled in server >> name, database name, user and password and it connected without any >> hiccup. >> >> The messages you get are typically when Lazarus(and your app) can't see >> the dll's. >> > > I done. And it seems to solve the trouble. Thank you. At least, when > I change the connected property to true, no errors occur. > > > >> I also noticed that you are not running the postgres server locally >> (i.e. localhost - 127.0.0.1). Have you edited postgres.conf on the >> server to allow connections from machines other than localhost? Stated >> differently: Have you told the postgres server to allow connections from >> network machines? >> > > If I open the postgres databases with pgAdmin that runs in my > machine, I suppose that the connections from the netword machines is > allowed. Doesn't it? > That would seem so yes. > pgAdmin show that my table is in the schema "public" and in a > database named "Conversor". If the table I want to access is named > DATATYPES how should I write the sql command to acess the table in a > full browse? > > select * from Conversor.DATATYPES? > select * from public.DATATYPES? > If you have set TPQConnection to connect to the database "Conversor", you don't need to qualify the tablename with the schema name(although that is allowed) because schema "public" is the default schema. When you create other schemas though and want to access the tables in the new schema then you do have to qualify the tablename with the schema name as you have done above. > Or how? > > Thanks for your efforts and patience. > My pleasure > Ricardo > > > > _______________________________________________ > Lazarus mailing list > [email protected] > http://www.lazarus.freepascal.org/mailman/listinfo/lazarus > >
_______________________________________________ Lazarus mailing list [email protected] http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
