Adaptive Server Anywhere Problem

Tobias Mueller

Delphi Developer

Tue, 29 Jun 2004 23:36:13 GMT

Adaptive Server Anywhere Problem

Hi,

I'm trying to access a Adaptive Server Anywhere database. Everytime I try to
connect to the database I get the following database error:

"[Sybase][ODBC Driver][Adaptive Server Anywhere] Invalid user authorization
specification: Integrated logins are not permitted. Alias: EasyLog212?"

Until now I tried the following ways:

- Changed the Login type of the System DNS to "Use integreated login"
- Changed the specified User ID and Password for the login type "Supply
user ID and password"
- Used a TDatabase to specify USERNAME and PASSWORD
- Used a plain TTable to access the data via the System DNS alias

None of them worked. Does anybody know how to access such a db?
Thanks!
- tobias (tobi...@winkfz.de)

G Allen Castera

Delphi Developer

Wed, 30 Jun 2004 01:21:53 GMT

Re:Adaptive Server Anywhere Problem

1) Change "Use Integrated Login" to "Specify UserName and Password"
2) Make sure that your connection method (TCP/IP?) is correct
3) Make sure the database name is valid and the database server is running
4) Try to open the connection in the BDE. If it fails fix this before moving on
the Delphi

5) In Delphi, Drop a TDatabase and set the DatabaseAlias to your BDE Alias
6) Set the user name and password, set the LoginPrompt to FALSE
7) Change Connected to TRUE, if it doe not connect, then your TDatabase settings
are wrong

8) Now you can drop a TTable (bad idea) or a TQuery (better method) and set data
from the database.

I also suggest that you get NativeDB www.nativedb.com which provides the most
efficient link to SQL Anywhere.

Best Regards,

Allen.

Quote

Tobias Mueller wrote:
> Hi,

> I'm trying to access a Adaptive Server Anywhere database. Everytime I try to
> connect to the database I get the following database error:

> "[Sybase][ODBC Driver][Adaptive Server Anywhere] Invalid user authorization
> specification: Integrated logins are not permitted. Alias: EasyLog212?"

> Until now I tried the following ways:

> - Changed the Login type of the System DNS to "Use integreated login"
> - Changed the specified User ID and Password for the login type "Supply
> user ID and password"
> - Used a TDatabase to specify USERNAME and PASSWORD
> - Used a plain TTable to access the data via the System DNS alias

> None of them worked. Does anybody know how to access such a db?
> Thanks!
> - tobias (tobi...@winkfz.de)

Richard Biff

Delphi Developer

Wed, 30 Jun 2004 09:47:57 GMT

Re:Adaptive Server Anywhere Problem

Go into the ODBC Data Sources in Windows Control Panel, and change the
connection settings on the Login page so the data source is set up with your
user name and password for login, NOT "integrated login". Click the "Test
connection" button to make sure you can connect. Get the ODBC data source
working first, then move back to the BDE Administrator in Control Panel and
make sure the BDE can connect to the data source, then get your application
working through the BDE.

I use NativeDB as middleware in my Delphi applications, but BDE/ODBC should
work okay for you. Sybase has a white paper with some tips about ASA and
Delphi, including BDE/ODBC configuration, at
http://www.sybase.com/detail?id=1010193.

Richard

Quote

"Tobias Mueller" <tobi...@winkfz.de> wrote in message

news:3c3f0660_1@dnews...

Quote

> I'm trying to access a Adaptive Server Anywhere database. Everytime I try
to
> connect to the database I get the following database error:

> "[Sybase][ODBC Driver][Adaptive Server Anywhere] Invalid user
authorization
> specification: Integrated logins are not permitted. Alias: EasyLog212?"

Robert Cern

Delphi Developer

Sat, 03 Jul 2004 20:09:53 GMT

Re:Adaptive Server Anywhere Problem

Open ISQL and check the option LOGIN_MODE, it should be either MIXED or
STANDARD.
To get option use "get option" command, to change it use "set option"
command:
set option public.login_mode=mixed.
That's server side part.

--
Robert

Quote

Tobias Mueller wrote in message <3c3f0660_1@dnews>...
>Hi,

>I'm trying to access a Adaptive Server Anywhere database. Everytime I try
to
>connect to the database I get the following database error:

>"[Sybase][ODBC Driver][Adaptive Server Anywhere] Invalid user authorization
>specification: Integrated logins are not permitted. Alias: EasyLog212?"

>Until now I tried the following ways:

> - Changed the Login type of the System DNS to "Use integreated login"
> - Changed the specified User ID and Password for the login type "Supply
>user ID and password"
> - Used a TDatabase to specify USERNAME and PASSWORD
> - Used a plain TTable to access the data via the System DNS alias

>None of them worked. Does anybody know how to access such a db?
>Thanks!
> - tobias (tobi...@winkfz.de)

Other Threads

1. D4 / Sybase SQL Anywhere / Adaptive Server Anywhere 6.0

2. Adaptive Server Anywhere 7 SELECT Problem with ADO

3. Problems with connection to a Adaptive Server Anywhere (SQLAnywhere)

4. Problems with connecting to a Adaptive Server Anywhere

5. Problems with Delphi 5 and Adaptive Server Anywhere 7.0 OLE DB provider

6. Sybase Adaptive Server Anywhere ODBC driver BLOBsize setting problem

7. Problems With NULLS in Adaptive Server Anywhere

8. Problems with Sybase Adaptive Server Anywhere 6.0

9. Sybase Adaptive Server Anywhere

10. Adaptive Server Anywhere 6.0 Indexes