I do not have experience with Postgress, but generally speaking I would recommend defining ODBC datasource using the ODBC control panel and testing the connection to db before going to Tango Editor. You can test the connection with tool like MS Query. Once you are sure that works, go to Tango Editor and try from there.
> -----Original Message----- > From: Dost, Farzana [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 21, 2002 9:16 AM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: ODBC DataSource Problem > > > > > Hi everyone, I have problem connecting to a database using > ODBC. I am > > pretty new to Tango so I will write all the steps and > problems I have: > > I want to connect to a PostgresSQL database on a different > machine(Linux) > > from my Windows machine. I am running Tango2000. > > The PostgerSQL database is created on the Linux box and the > postmaster is > > running. > > In my Tango Editor: > > > > 1. I chose Create new ODBC datasource, from DataSource menu. > > 2. Datasource Type: File Data Source(Mahine Independent) > > 3. I installed PostgreSQL driver so from driver list I > chose PostgreSQL > > 4. i typed "Test" for the file data source to save the connection > > 5. When i clicked finish "PostgrSQL Connection" window > popped up asking me > > to type in missing data > > a. For "Database" I typed the name of my db on Linux > which is MYDB > > b. For "Server" I typed the IP of the machine where the MYDB is > > c. For "User Name and Password" I entered the user name > and password > > that has access to MYDB > > d. Port 5432 (default port) > > > > Now I see the PostgreSQL DB under ODBC in the database > lists. When I try > > to open it ofcouse it asks for user name and password. I > entered the same > > user/password that I entered when i created the Datasource > but it does not > > connect I get this message, "Couldn't connect to data > source "PostgreSQL". > > Check the user name and password or the data source configuration." > > > > Does anyone have an idea of what I am missing here. Any help will be > > appreciated. > > > > Thank You, > > > > Farzana > > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
