Re: [ODBC] ODBC (win32) X PostgreSQL(Linux)
Hi Fabricio,
fbbsantos wrote:
What details do you need?
I need to know enough that if I sat down at your computer I could find
the problem.
For example, what language or application are you using?
Are you using a DSN, or a DSN-less connection?
What connection string have you used in your application?
What kind of error messages are you getting?
Perhaps a code sample?
Cheers,
EE
Show quoted text
I have a PostgreSQL version 7.3.2 installed in a Mandrake 9.0.
On the WindowsXP machine, I installed the driver psqlodbc-07_03_0200.But I don�t know how to make an application in XP see the database.
How can I configure the connection to do so?
Thanks a lot.
Em (12:21:40), Eric E escreveu:
Hi Fabricio, To provide any detailed help, folks will need to know more specifically what the problem is. However, some things I've come across are: + making sure the PG server is set to accept connections from your IP address. By defautl, pg_hba.conf is usually set only to allow connections from the server itself. + you'll may also need to to use an IP address rather than a hostname in your DSN, depending on how name resolution is set up in Windows and on your network.Can you give us some more details of your problems?
Cheers,
Eric
fbbsantos wrote:
Could someone help me? I have a PostrgreSQL in a Linux server and I'm
trying
to connect a ODBC driver in a WindowsXP to a database I've created.
I have consulted some manuals, but of no help. Someone have any tips?
Tutorial, howto, self experience...Thanks a lot,
Fabr�cio Bueno---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly----------
Import Notes
Reply to msg id not found: 20050125_234505_002012.fbbsantos@ig.com.brReference msg id not found: 20050125_234505_002012.fbbsantos@ig.com.br
On Wednesday 26 January 2005 07:07 am, Eric E wrote:
Hi Fabricio,
fbbsantos wrote:
What details do you need?
I need to know enough that if I sat down at your computer I could
find the problem.
For example, what language or application are you using?
Are you using a DSN, or a DSN-less connection?
What connection string have you used in your application?
What kind of error messages are you getting?
Perhaps a code sample?Cheers,
EE
I have a PostgreSQL version 7.3.2 installed in a Mandrake 9.0.
On the WindowsXP machine, I installed the driver
psqlodbc-07_03_0200.But I don´t know how to make an application in XP see the database.
How can I configure the connection to do so?Thanks a lot.
Em (12:21:40), Eric E escreveu:
Hi Fabricio, To provide any detailed help, folks will need to know more specifically what the problem is. However, some things I've come across are: + making sure the PG server is set to accept connections from your IP address. By defautl, pg_hba.conf is usually set only to allow connections from the server itself. + you'll may also need to to use an IP address rather than a hostname in your DSN, depending on how name resolution is set up in Windows and on your network.Can you give us some more details of your problems?
Cheers,
Eric
fbbsantos wrote:
Could someone help me? I have a PostrgreSQL in a Linux server and
I'mtrying
to connect a ODBC driver in a WindowsXP to a database I've
created.I have consulted some manuals, but of no help. Someone have any
tips? Tutorial, howto, self experience...Thanks a lot,
Fabrício Bueno---------------------------(end of
broadcast)--------------------------- TIP 3: if posting/reading
through Usenet, please send an appropriate subscribe-nomail
command to majordomo@postgresql.org so that your message can get
through to the mailing list cleanly----------
---------------------------(end of
broadcast)--------------------------- TIP 6: Have you searched our
list archives?
In Windows, run odbcad32.exe to define a Data Source Name for each
database. You can define User DSN's (for current user only) or System
DSN's (for any system user). If you've already installed the
postgresql odbc drivers, you should see the drivers listed under the
Drivers tab.
Best of luck,
Andrew Gould