Need Help regarding Authentication Violation.

1 Mar 2007 12:48 PM

Mani

Hi

Using ado.net i am trying to connect Sybase[SqlAnywhere-9]. The problem is i
am able to retreive data from the tables , but while inserting i am getting
exception as "Authentication Violation".The database is local and i am using
"iAnywhere.Data.AsaClient". The connection string i am using is
@"UID=ImgUsr;PWD=4ypIqwge6; .

Can you please provide help regarding this.
Regards,
Mani.

1 Mar 2007 6:21 PM

RobinS

Thanks for posting your userid and password. I'm sure someone will find
that helpful.

If you get no answers here, you might try posting this to a Sybase group.
Also, check out http://www.connectionstrings.com to check out connection
string.

Robin S.
---------------------------
Show quote

"Mani" <M***@discussions.microsoft.com> wrote in message
news:54675FED-BAD5-41FB-B016-AC67320FD7CB@microsoft.com...
> Hi
>
> Using ado.net i am trying to connect Sybase[SqlAnywhere-9]. The problem
> is i
> am able to retreive data from the tables , but while inserting i am
> getting
> exception as "Authentication Violation".The database is local and i am
> using
> "iAnywhere.Data.AsaClient". The connection string i am using is
> @"UID=ImgUsr;PWD=4ypIqwge6; .
>
> Can you please provide help regarding this.
> Regards,
> Mani.
>

1 Mar 2007 9:12 PM

William (Bill) Vaughn

It's not unusual to setup databases with read-only rights. I expect that
UIDImgUsr does not have sufficient rights.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

Show quote

"Mani" <M***@discussions.microsoft.com> wrote in message
news:54675FED-BAD5-41FB-B016-AC67320FD7CB@microsoft.com...
> Hi
>
> Using ado.net i am trying to connect Sybase[SqlAnywhere-9]. The problem is
> i
> am able to retreive data from the tables , but while inserting i am
> getting
> exception as "Authentication Violation".The database is local and i am
> using
> "iAnywhere.Data.AsaClient". The connection string i am using is
> @"UID=ImgUsr;PWD=4ypIqwge6; .
>
> Can you please provide help regarding this.
> Regards,
> Mani.
>