JZ0SJ: Metadata accessor information was not found on this database

Question

I have problem with my ColdFusion application. When I try to log into my account it generates the following error

JZ0SJ: Metadata accessor information was not found on this database.
Please install the required tables as mentioned in the jConnect documentation.

I am using SQL Anywhere 9 and also jConnect-6_0. Can anyone help me with this please.

Did you _install the required tables as mentioned in the jConnect documentation_? — Miguel-F, Dec 13 '13 at 17:00
Hi,No I did not install any talbes mentioned in jConnect...but why my other application and database works well without installing any tables in jConnect..can you please give me some links on this tables.and how do i install this tables.?Thanks — mathiascolebar, Dec 15 '13 at 07:15

score 9 · Answer 1 · edited Oct 25 '14 at 20:41

9

It seems no one ever properly answered this. Just in case it comes in handy (though I'd never recommend using this database), to solve the above problem, install the metadata tables. Run the following statement being the only account connected to the database:

ALTER DATABASE Upgrade JCONNECT ON

As mentioned in the Sybase documentation.

edited Oct 25 '14 at 20:41

Leigh

28,765
10
55
103

answered Oct 23 '14 at 14:42

svaens

649
7
23

2

I have read-only access to a database controlled by a vendor and am connecting using SQL Workbench. Is there a way of connecting without running that SQL Statement? – Aaron C. de Bruyn Dec 20 '18 at 15:33

JZ0SJ: Metadata accessor information was not found on this database

1 Answers1