SQL suite from Sybase

learn more… | top users | synonyms

-2
votes
1answer
3k 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 ...
0
votes
1answer
237 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. ...
1
vote
1answer
212 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 ...
2
votes
1answer
781 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
2answers
1k 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
2answers
3k 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 ...
1
vote
1answer
242 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
2
votes
1answer
269 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 ...
4
votes
3answers
958 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 ...
1
vote
3answers
1k 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 ...
3
votes
2answers
462 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 ...