cancel
Showing results for 
Search instead for 
Did you mean: 

Authenticating via ADO.NET Version 12.01

Former Member
3,152

SACommand cmd = new SACommand( "SET TEMPORARY OPTION connection_authentication='Company=XXX Inc;Application=XXXX;Signature=010fa55157edb8e14z813eb4fe3db41447846f1571g6470c2dce685f48eae9e472027825d02d41gc206';", connPC); cmd.ExecuteNonQuery();

above is how I have my .net app attempting to authenticate.... I always get a -218 error..

This is pretty much identical to the example in the Sybase documentation.....

Any ideas what is wrong...

Note: The Signiture above has been changed from my actual one.... I use copy and paste to get the proper one into my application thus I am sure I do not have a typo...

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member

I think this was my bad:

After going through this over again 3 times : being much more careful on the copy / paste. It appears to work. At least 3 test cases without error.

Keeping myfingers crossed....

It is definitly extreamly sensitive to being exact format........

Thanks for the feedback....

VolkerBarth
Contributor
0 Kudos

Been there, too - I remember to have fiddled around with a DSN with the authentication string as part of the InitString - and then to find out that I just had silently omitted the last character while copying the authentication string...

0 Kudos

We have also seen times where copying and pasting from a program where the text went more than one line copied the line breaks, which are not part of the string.

chris_keating
Product and Topic Expert
Product and Topic Expert

The error -218 indicates that there is some problem with the authentication string. Try the following:

  • restart the database after the DATABASE_AUTHENTICATION has been set
  • verify the authentication option values match those provided in the email (without additional characters or truncation)
  • ensure proper formatting of special characters such as quotation marks for the application development environment

If you continue to have problems, you will likely need to work with support who can review the option values in more detail.