SQL Anywhere database - Integrated login and permissions

Author

Integrated login and permissions

Jim

2005-05-24, 11:23 am

Hello, I am using ASA 9.0.2.3044

Using an integrated login, I'm expecting to have read/write permissions to
the server. In this case I want to run a LOAD TABLE statement that pulls in
data from a file on the server:

LOAD TABLE initial_import FROM 'S:\\Customer
Projects\\KLM\\Expor
t\\wb6510_4_26_05.txt'

Where S is a mapped network drive. I get this error:

Could not execute statement.
Cannot access file "S:\....."
No such file or directory.
SQLCODE = -602, ODBC 3 State="HY000"

The file *does* exist at that location. Here's how I created and logged in
with an integrated login that has DBA access:
In Sybase Central, I go to Integrated Logins
I create a new login with only my username, johnd.
(when I tried to include the domain in the integrated login,
mydomain\johnd or johnd@mydomain, I couldn't log in to the database)
I log in to the database selecting the integrated login option

Everything seems fine, except that the database can't access a file on the
network that my johnd user account *can* access. Is this expecting too
much?

Thank you.

Chris Keating $iAnywhere Solutions$

2005-05-24, 1:23 pm

From the LOAD TABLE documentation:

The path name is relative to the database server, not to the client
application. If you are running the statement on a database server on
another computer, the directory names refer to directories on the server
machine, not on the client machine.

"Jim" <jimsjbox@yahoo.com> wrote in message news:42935237$1@foru
ms-1-dub...
> Hello, I am using ASA 9.0.2.3044
>
> Using an integrated login, I'm expecting to have read/write permissions to
> the server. In this case I want to run a LOAD TABLE statement that pulls
> in
> data from a file on the server:
>
> LOAD TABLE initial_import FROM 'S:\\Customer
> Projects\\KLM\\Expor
t\\wb6510_4_26_05.txt'
>
> Where S is a mapped network drive. I get this error:
>
> Could not execute statement.
> Cannot access file "S:\....."
> No such file or directory.
> SQLCODE = -602, ODBC 3 State="HY000"
>
> The file *does* exist at that location. Here's how I created and logged
> in
> with an integrated login that has DBA access:
> In Sybase Central, I go to Integrated Logins
> I create a new login with only my username, johnd.
> (when I tried to include the domain in the integrated login,
> mydomain\johnd or johnd@mydomain, I couldn't log in to the database)
> I log in to the database selecting the integrated login option
>
> Everything seems fine, except that the database can't access a file on the
> network that my johnd user account *can* access. Is this expecting too
> much?
>
> Thank you.
>
>
>

Jim

2005-05-24, 1:23 pm

In this case the database server is running on the client machine. Also I
had the same problems when using UNC paths.

"Chris Keating (iAnywhere Solutions)" < Spam_NoThanks_keatin
g@iAnywhere.com>
wrote in message news:429360cd$1@foru
ms-1-dub...
> From the LOAD TABLE documentation:
>
> The path name is relative to the database server, not to the client
> application. If you are running the statement on a database server on
> another computer, the directory names refer to directories on the server
> machine, not on the client machine.
>
> "Jim" <jimsjbox@yahoo.com> wrote in message
news:42935237$1@foru
ms-1-dub...
to[color=darkred]
pulls[color=darkred]

the[color=darkred]
>
>

Greg Fenton

2005-05-24, 1:23 pm

Jim wrote:
> In this case the database server is running on the client machine. Also I
> had the same problems when using UNC paths.
>

How is the database engine started?
If it is run as a Service, then there is a very good chance that the
userid under which the engine is running cannot "see" your drive mapping
and would be restricted from accessing UNC paths.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Jim

2005-05-24, 8:23 pm

Greg,

Yes, I'm sorry I forgot that the service account doesn't have those
permissions.

I realized that in the Windows Services manager you can, in the Log On tab,
select the account you want the service to run under. I changed this to my
account, and was able to run my statement (but only with UNC paths, which is
fine).

Thank you.
Jim

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:429368cd$1@foru
ms-1-dub...
> Jim wrote:
I[color=darkred]
>
> How is the database engine started?
> If it is run as a Service, then there is a very good chance that the
> userid under which the engine is running cannot "see" your drive mapping
> and would be restricted from accessing UNC paths.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Sponsored Links