From: Michael Moss <michael@bstudios.com>
To: pgsql-interfaces@postgresql.org
Subject: Can't connect with ODBC
Date: Thu, 23 Apr 1998 09:34:35 -0700
Message-ID: <001201bd6ed5$b499a720$fa00a8c0@opus.bstudios-home.com> (raw)
I apologize if this is a repost, but it's been awhile since I posted it and
I haven't seen it in the newsgroup yet, so I'm afraid it didn't go through.
I tried to post directly to the newsgroup. Is that not allowed? Anyhow, on
to my problem.
I installed the Insight ODBC driver, but I can't seem to connect using
Access 97. I keep getting an error of "User authentication failed (#10)".
I'm not sure that I have everything setup properly. Is there a checklist of
some sort that I can use to test my configuration?
Here's what I've tested:
- I telnet to the Linux box on port 5432 and it connects, so postmaster
seems to be taking connections.
- I can use psql on the Linux box, under my username, to connect to a little
test database I created, so I think my privileges are setup properly
- I tried all three DSN types (user, system, and file) and they all had the
same result.
- Tried on an NT system and a Win95 system with no luck
I don't know enough about it to debug any more than that. Any suggestions
would be greatly appreciated.
Thank you,
Michael Moss
Blackbox Studios
(remove "-no-spam" from my address if you wish to reply by e-mail)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: michael@bstudios.com
Subject: Re: Can't connect with ODBC
In-Reply-To: <001201bd6ed5$b499a720$fa00a8c0@opus.bstudios-home.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox