XRS6008: ADO Data access error occurred

[Former Member]

Hi,

I have a evaluation license for a SQL Anywhere Personal Server edition version 12.0.0.2483. This is on a Windows Server 2008 R2 SP1 Standard Edition environment. I can create the SQL Anywhere 12 db via the wizard in Sybase Central with the following options maintained:

Maintain log files - Yes

Maintain transaction Mirror log files - Yes

Install jConnect Meadata suppoort - No

Enable encryption - Simple encryption of the entire database

Page Size - 8192 bytes

Default options taken for the rest of the installation options

When trying to create a service for the newly created database, the service will not start and there is an error in the windows event viewer.

Text of the error message is as follows: "XRS6008: ADO Data Access Error Occured. Database server not found. EXPLANATION: An error occured while attempting to access the logging database connection. The NT/ADO error code in the server log or the operating system event log may contain additional information about why the table could not be accessed. [DBAccess]

Anyone have an idea on what is causing this issue?

Thanks

[jeff_albion]

This appears to be an Sybase Afaria database server definition - is that correct...? I don't recognize the above error as a SQL Anywhere database error.

What is the service definition that you're using? How did you create the service, specifically? How do you start the service in order to see this error in the Windows Event Viewer?

[Former Member]

Hi, Thanks for the response. Yes you are correct. The SQL anywhere db was being created to be used for an Afaria 7.0 SP1 installation. After creating the SQL anywhere db I disconnected from the database in sybase central and went into the services tab (still in sybase central) to create the windows service for the database. While creating the windows service I set it to start now and it is then I got a generic error message. It is then I went into the event viewer to see if more detail could be found there.