Sent: Monday, April 08, 2002 3:37
AM
Subject: RE: [pgadmin-support] first
time
Camila,
When
you created an ODBC connection to a database (in our case to a Postgresql
database) you told it a few things:
1.
The name of the host (this is the name of the machine where Postgresql server
is running)
2.
The port number (this is the number of the port where Postgresql is
listening for requests. The default value is 5432)
3.
Database Name. Here you write the name of the database you wish to connect to.
If you have several databases and you will be using this ODBC connection to
connect to any of them, then it is better that you leave this field
blank.
4.
User and Password: This is the user id that has privileges to access the
database.and its respective password. You can leave this two fields in blank
or you can enter the information.
The
ODBC connection that you created above was saved with a name. This name
is known as the DATASOURCE. For example if you saved the ODBC connection above
with the name "postgres" then every time your are asked for the datasource you
will have to write "postgres".
Once
you created an ODBC connection, you tell pgAdmin the information it
needs: DATASOURCE is the name of the ODBC connection that you created above.
If in the above connection you entered a user name and password then you do
not have to entered here in pgAdmin. If you did not entered a user id and
password in the ODBC connection then you will have to enter them
here.
NOTE: Remember that to be able to create an ODBC connection
to Postgresql you have to install an ODBC driver for Postgresql. To
create the ODBC connection you will go to the ODBC administrator in the
control pannel.
Hi!
I'm a student from brazil... i want to know
what should i write in the fields datasource, user and
password.
sorry for the bad english and the stupid
question!
thanx!
