PsqlODBC Error
От | Mohd Rasyidi |
---|---|
Тема | PsqlODBC Error |
Дата | |
Msg-id | 3.0.5.32.19981125103312.007975a0@aitpg.Adorna-RMIT.edu.my обсуждение исходный текст |
Список | pgsql-interfaces |
I got "could not connect to remote socket(#1)" when I tried to export my Access 97 database to postgresql 6.3 My config for datasource(psqlODBC) in control panel: Database = student #My database name in postgresql (Redhat 5.1) Server = hostname.domainname.edu.my User Name = rasyidi Port = 5432 (default) password = no password. (if I key in password also cannot connect) option(Advanced) datasource -- protocol = 6.3 In my redhat 5.1. I createuser rasyidi can create database can create user. using rasyidi, I createdb student and staff_info table with 4 fields: Name,email,post,department(TEXT). in pg_hba.conf, I add at the last line to allow all ip address in my place can connect to the server: host all xxx.xxx.xx.0 255.255.255.0 trust thats all for my database server. But I do not know the postmaster start with -i or not because I am using rpm package that come with redhat 5.1. My network environment. Domain name server is on AIX server(building A) and redhat 5.1 is on another server(Building B) Have subnet mask. Access 97 got 4 fields = name,email,post,department - no primary key with some data inside the table. database name simpledb and staff_info table. Can some one help me to make the connection. Thanks...
В списке pgsql-interfaces по дате отправления: