I often use MS-Access just to open tables and poke around. It's easy to view/edit/query tables.
Regards, Len Wright Plus International Corp www.plusinternational.com Direct: 604-415-2384 Fax:604-415-0830 >>> [EMAIL PROTECTED] 06/21/02 08:04AM >>> I am pretty sure you are right...i think my problem is out of Tango as Alexander mentioned it....so now i am trying to find out how to test my datasource though ODBC Control Panel which i don't really know how to do ;) -----Original Message----- From: Steve Smith [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 11:00 AM To: Dost, Farzana Cc: WiTango List Subject: RE: Witango-Talk: ODBC DataSource Problem I wish I knew more about PostgresSQL. I can guarantee that you need to leave the setting as a System data source type (I was with EveryWare/Pervasive for almost 5 years from Tango 1.0 to Tango 2000) but I can't provide any further assistance with regards to your database engine. Sorry, Steve Smith Skadt Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.skadt.com -----Original Message----- From: Dost, Farzana [mailto:[EMAIL PROTECTED]] Sent: June 21, 2002 10:37 AM To: 'Steve Smith' Subject: RE: Witango-Talk: ODBC DataSource Problem Thanks, Tried it but did not work.... -----Original Message----- From: Steve Smith [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 9:59 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Witango-Talk: ODBC DataSource Problem I am not familiar with PostgresSQL but I am familiar with WiTango. You must set up your datasource as a System datasource, not File. Hope this helps, Steve Smith Skadt Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.skadt.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dost, Farzana Sent: 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 ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
