Questions tagged [sybase]
7 questions
2
votes
1 answer
Accessing a sybase db file
I Have a sybase sql anywhere '.db' file that is typically run on a database server engine. Is there anything out there that would let me just view the .db file without this server? I'm having so much trouble connecting to it and the command line…
Akshat
- 161
2
votes
0 answers
How do i find out which user/application deleted/removed System DSN from ODBC
We are having weird issue with our ODBC system DSN. With our application automatically system DSN is created but our client claims that after some time system DSN is deleted/removed. We couldnt find any logs for that but we assume that this is…
user1012360
- 21
0
votes
1 answer
Restrict sybase command stop_iq to certain linux users
I want to restrict access to stop_iq database shutdown utility to authorized users only under Linux, for example to the user 'dev' that belongs to group 'grp_dev'. I know the command is under this path:
/sybaseiq/IQ-15_4/bin64/stop_iq
And it could…
MSS
- 159
0
votes
1 answer
JZ0SJ: Metadata accessor information was not found on this database.
The complete message is:
(JZ0SJ: Metadata accessor information was not found on this database.
Please install the required tables as mentioned in the jConnect documentation
The server is
Adaptive Server Enterprise/15.5/EBF 18380 SMP…
Anthony Kong
- 5,318
0
votes
1 answer
How to enable remote connection in SQL Anywhere 17(windows)
I downloaded the trial version of SQL Anywhere 17. After the other databases, the interface does not seem very clear. I want to allow remote connection to this server. It seems strange that in tcp / ip listeners I can only select localhost ... How…
Fyzzys
- 101
0
votes
1 answer
Setting SQL Anywhere to Not Cross Join Automatically
In SQLAnywhere when designing queries with the query editor if I accidentally choose a table that cannot be joined to another table except by a cross join SQL Anywhere will automatically create a cross join and depending on the size of the tables…
0
votes
2 answers
SQL Combining Rows
I have a table that has three columns: ID, Date, Group. There are two rows for each unique ID (where Group = 1 or where Group = 2). How can I combine these into a table with one row per ID and the Date values sorted into two columns?
I have:
ID …
picobit
- 330