Home > Archive > SQL Anywhere Feedback > October 2005 > ODBC Test Connect should prompt for user id and password









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ODBC Test Connect should prompt for user id and password
Breck Carter [TeamSybase]

2005-10-27, 7:41 am

When an ODBC DSN is set up with Login - Supply user ID and Password
selected, but the User ID: and Password: fields are left empty, the
Test Connect does not prompt for a user id and password; it just gives
the error "Integrated logins are not permitted".

This happens even though the DSN is perfectly valid... Test Connect is
of no use in this case.

The ODBC Administrator interfaces for *other* DBMS products prompt for
user id and password, and SQL Anywhere should as well. Test Connect is
a valuable tool, and we should be able to use it without hard coding
passwords in DSNs.

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
Justin Willey

2005-10-27, 7:41 am

Seconded - this annoys me almost every day!

Justin Willey


"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:f9j7k1p26lu5d2l
2f3a2vlut7bm0p731ue@
4ax.com...
> When an ODBC DSN is set up with Login - Supply user ID and Password
> selected, but the User ID: and Password: fields are left empty, the
> Test Connect does not prompt for a user id and password; it just gives
> the error "Integrated logins are not permitted".
>
> This happens even though the DSN is perfectly valid... Test Connect is
> of no use in this case.
>
> The ODBC Administrator interfaces for *other* DBMS products prompt for
> user id and password, and SQL Anywhere should as well. Test Connect is
> a valuable tool, and we should be able to use it without hard coding
> passwords in DSNs.
>
> Breck
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:

http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com



Andrew Giulinn

2005-10-27, 7:41 am

I definitely agree (speaking, I understand, on behalf of another few hundred
people!).

"Justin Willey" <gjw@nospamatall.iqx.co.uk> wrote in message
news:4343d80c@forums
-2-dub...
> Seconded - this annoys me almost every day!
>
> Justin Willey
>
>
> "Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
> message news:f9j7k1p26lu5d2l
2f3a2vlut7bm0p731ue@
4ax.com...
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
>
>



Nick Elson

2005-10-27, 7:41 am

This sounds more like a bug posting than an issue worth voting on.

There is a checkbox for integrated logins in version 9, and that
should be respected.

Maybe that bug repro. should be submitted.


"Andrew Giulinn" <NO.oscar.SPAM@NOSPAM.dsa.com.au> wrote in message
news:43445d39@forums
-2-dub...
>I definitely agree (speaking, I understand, on behalf of another few
>hundred people!).
>
> "Justin Willey" <gjw@nospamatall.iqx.co.uk> wrote in message
> news:4343d80c@forums
-2-dub...
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com