sqlanywhere
SQL error using sqlanywhere php API sasql_query()
I\'m having problem executing a specific query using php API from sqlanywhere 12. It only happens with SET OPTION query.[详细]
2023-04-11 00:09 分类:问答java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.BasicDataSource cannot be cast to org.apache.tomcat.jdbc.pool.DataSource
I\'m running Tomcat 7.0.22 and I wrote 开发者_开发技巧a simple servlet that connects to a SQL Anywhere 12.0 database. When I run the servlet I get java.lang.ClassCastException: org.apache.tomcat.dbcp.[详细]
2023-04-10 18:33 分类:问答Can I create a trigger that involves a cursor on a table that the trigger is not made for?
For example if I have a trigger for table employee. I want to create a cursor loop from thetable department. Then I want to take the attribute and insert it into the table company. I\'m guessing the a[详细]
2023-04-06 18:57 分类:问答Sybase stored procedure insert limit with JDBC driver
I\'m having issues with stored procedures that have a lot of insert statements when using Sybase\'s jdbc driver. After 50-60 inserts, the stored procedure stops execution and returns. See code below.[详细]
2023-03-28 09:01 分类:问答SQLServer on existing update
We are planning to convert an application from Sybase SQL Anywhere to SQL Server. At SA we use a lot of \"on existing update\", that checks by primary key, if l开发者_JS百科ine exists.[详细]
2023-03-26 00:40 分类:问答Dataimport into SQL server 2008 r2 EXPRESS from SQL Anywhere 11.0
Hello EveryoneIam trying to bulk insertdata from .dat file(unloaded from sybase) in to the开发者_Go百科 table i created.[详细]
2023-03-22 10:28 分类:问答Migrating from SYBASE SQLAnywhere 11.0 to SQL Server 2008 R2 Express
Hello everyone i have got a project to migrate from SQLAnywhere 11 to any new relational databases for our ship crew web application.The reasons for mi开发者_如何转开发grating is cost and support issu[详细]
2023-03-20 09:09 分类:问答How to export data from an ancient SQL Anywhere?
I\'m tasked with exporting data from an old application that is using SQL Anywhere, apparently version 5, maybe 5.6. I never worked with this database before so I\'m not sure where to start here. Does[详细]
2023-03-13 05:13 分类:问答SQL Error in SQLAnywhere with Ultralite Database on Windows CE 5.0 - VB.net
We are deploying a SQLAnywhere solution on Windows CE 5.0 devices and are running into an error in our first SQL statement.[详细]
2023-03-10 02:10 分类:问答Sybase IN and OUT parameters
I\'m going nuts about how the Sybase JDBC driver handles stored procedures with mixed IN and OUT parameters. Check out this simple stored procedure:[详细]
2023-03-02 05:36 分类:问答