> 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
