SQL suite from Sybase

learn more… | top users | synonyms

4
votes
3answers
853 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
418 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
255 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 ...
2
votes
1answer
584 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 ...
1
vote
1answer
234 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
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 ...
1
vote
1answer
146 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 ...
0
votes
1answer
175 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
535 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
886 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
2k 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 ...