Postgres Pro
Downloads
Home   >   mailing lists

Thread: no simple test in DSN configuration?

no simple test in DSN configuration?

From
"Bing Du"
Date:
I've ever configured the ODBC driver for both MS SQL server and MySQL
using ODBC Data Source Administrator on windows 2000.  Both have a test
button so you can know right away whether or not your DSN configuration
(e.g. database name, username, password, etc.) is right.  I don't see a
test like button when I configured PostgreSQL ODBC driver.  Any way I can
do a simple test?  I'm new to PostgreSQL, by the way.

Any ideas/suggestions would be appreciated,

Bing

Re: no simple test in DSN configuration?

From
"Dave Page"
Date:

> -----Original Message-----
> From: Bing Du [mailto:bdu@iastate.edu]
> Sent: 14 January 2004 20:45
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] no simple test in DSN configuration?
>
> I've ever configured the ODBC driver for both MS SQL server
> and MySQL using ODBC Data Source Administrator on windows
> 2000.  Both have a test button so you can know right away
> whether or not your DSN configuration (e.g. database name,
> username, password, etc.) is right.  I don't see a test like
> button when I configured PostgreSQL ODBC driver.  Any way I
> can do a simple test?  I'm new to PostgreSQL, by the way.
>
> Any ideas/suggestions would be appreciated,

Hmm, that one never came up before (surprisingly!). Do you have an ODBC
app you can try - Microsoft Query or Crystal Reports for example?

Regards, Dave.

Re: no simple test in DSN configuration?

From
Jon Willeke
Date:
DataDirect distributes a nice version of OdbcTest for Windows on the
following page:

   <http://www.datadirect-technologies.com/support/downloads/su-tools.asp>

At 1/14/2004, Dave Page wrote:
>
>
> > -----Original Message-----
> > From: Bing Du [mailto:bdu@iastate.edu]
> > Sent: 14 January 2004 20:45
> > To: pgsql-odbc@postgresql.org
> > Subject: [ODBC] no simple test in DSN configuration?
> >
> > I've ever configured the ODBC driver for both MS SQL server
> > and MySQL using ODBC Data Source Administrator on windows
> > 2000.  Both have a test button so you can know right away
> > whether or not your DSN configuration (e.g. database name,
> > username, password, etc.) is right.  I don't see a test like
> > button when I configured PostgreSQL ODBC driver.  Any way I
> > can do a simple test?  I'm new to PostgreSQL, by the way.
> >
> > Any ideas/suggestions would be appreciated,
>
>Hmm, that one never came up before (surprisingly!). Do you have an ODBC
>app you can try - Microsoft Query or Crystal Reports for example?

Re: no simple test in DSN configuration?

From
"Bing Du"
Date:
That's awesome!  Thanks so much for the pointer.

Bing

> DataDirect distributes a nice version of OdbcTest for Windows on the
> following page:
>
>    <http://www.datadirect-technologies.com/support/downloads/su-tools.asp>
>
> At 1/14/2004, Dave Page wrote:
>>
>>
>> > -----Original Message-----
>> > From: Bing Du [mailto:bdu@iastate.edu]
>> > Sent: 14 January 2004 20:45
>> > To: pgsql-odbc@postgresql.org
>> > Subject: [ODBC] no simple test in DSN configuration?
>> >
>> > I've ever configured the ODBC driver for both MS SQL server
>> > and MySQL using ODBC Data Source Administrator on windows
>> > 2000.  Both have a test button so you can know right away
>> > whether or not your DSN configuration (e.g. database name,
>> > username, password, etc.) is right.  I don't see a test like
>> > button when I configured PostgreSQL ODBC driver.  Any way I
>> > can do a simple test?  I'm new to PostgreSQL, by the way.
>> >
>> > Any ideas/suggestions would be appreciated,
>>
>>Hmm, that one never came up before (surprisingly!). Do you have an ODBC
>>app you can try - Microsoft Query or Crystal Reports for example?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>