I have been struggling with an odbc connection to a pervasive.2000 database that connects to an application called Maximizer (contact management app). It seems that the developers (Maximizer) have disabled access to the database via odbc so they can sell you an odbc connector to enable it. ($1000)
Perhaps postgress does something similar? Regards, Len Wright Plus International Corp www.plusinternational.com Direct: 604-415-2384 Fax:604-415-0830 >>> [EMAIL PROTECTED] 06/21/02 08:00AM >>> 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
