SQL suite from Sybase
4
votes
3answers
766 views
Diagnosing I/O Bandwidth Performance in SQL Anywhere
While diagnosing performance issues with vendor software that runs off of SQL Anywhere (9.0.2), I stumbled upon some interesting data in regards to I/O Bandwidth. According to the 9.0.2 manual, the ...
3
votes
2answers
374 views
How do I control temporary file growth in SQL Anywhere?
We are currently experiencing a growing temporary file problem. Watching one of our sites we can see a growth of 100 - 200 MB a day at one site we are watching. At this site a failure occured when ...
2
votes
2answers
2k views
How to access a SQL Anywhere database?
Currently I have a SQL Anywhere (version 10) database (.db and .log files) - the idea is to extract the data and utilize it for a MS SQL database.
The problem is that I start a SQL Anywhere server ...
2
votes
1answer
238 views
SQL Anywhere 10 - Can you combine cache control commands?
So this may seem like a silly question but I have been unable to find documentation that supports either side of the question.
SQL Anywhere 10 - dbsrv10.exe has numerous startup options. I'm being ...
1
vote
1answer
226 views
Change a Database Properties On SQL Anywhere 9
i need to change the property (Casesnsitve = on To Casesnsitve = oFF ) for a Databse created on SQl Anywhere 9
1
vote
3answers
986 views
Sql Anywhere 9 cannot access on Network
heres the situation, i have a windows 2008 enterprise server (brand new) so far the only thing installed on it out of the box is SQL Anywhere 9.0.2 and Mysql 5.1 its all setup and working i have ...
1
vote
1answer
98 views
SQL AnyWhere, how do I set the database ReadOnly property to On?
Does anyone know in Sql AnyWhere, how can I set the ReadOnly property of any database to On?
I can only see the way to access the property, but cannot find the way to set it correctly at the first ...
1
vote
1answer
417 views
Script / command to drop all connections / locks in Sybase SQL Anywhere 9?
I've recently become responsible for administering an application which is essentially a front end to a Sybase SQL Anywhere 9 database, including the database itself. I'd like to use unload table to ...
0
votes
1answer
133 views
SQLANYWHERE10 PHP Module
I added the extension to php.ini to get the module to load but now I am getting this error
Warning: sasql_connect() [function.sasql-connect]: The SQLAnywhere client libraries could not be loaded. ...
0
votes
0answers
362 views
Configuring ODBC for Sybase on SqlAnywhere10 FOR Linux
I am trying to configure an ODBC for Sybase on Sqlanywhere10 for a Linux Machine.
When I reference the "ODBC Data Source Name" it finds the .odbc.ini file correctly but when it looks for the driver ...
0
votes
2answers
448 views
Listing tables on a SQL Anywhere using iSQL
Is there a way to list all the tables on a SQL Anywhere using iSQL?
-2
votes
1answer
753 views
how to set LD_LIBRARY_PATH on VPS red-hat linux to be visible by apache
Where and how should I set LD_LIBRARY_PATH to be visible by apache?
I tried to add following code to .bash_profile:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/folder_with_library/
export ...
