sap-ase_开发者

why do I get HY000 pyodbc error for my query?

My Sybase query is quite simple for eg. select adjusted_weight from v_temp_idx_comp where ric_code=\'0005.HK\' and index_ric_code=\'.HSI\'[详细]

2023-04-11 16:49 分类：问答

Sybase ASE OLE DB Connection in SQL Server Integration Services 2005

I am building a SQL Server 2005 Integration Services package to migrate data from a Sybase Adaptive Server Enterprise 12.5.4 database to a SQL Server 2005 Database.The Sybase Database is the backend f[详细]

2023-04-11 07:08 分类：问答

How to get in one query an item and another item having one of its value nearest of the former one?

Imagine I have the following table : ID || Order ----------- 1|| 1 2|| 2 3|| 5 4|| 20 5|| 100 6|| 4000 (no specific rule applies to the order value).[详细]

2023-04-08 03:31 分类：问答

How do I capture this warning message when the query is blocking?

When I do a query with isql I get the following message and the query blocks. The transaction log in database foo is almost full.Your transaction is being suspended until space is made available in[详细]

2023-04-07 01:31 分类：问答

Need hints to optimise a sybase access over a big fat pipe

I have the need to access a sybase database (12.5) from oversea. The high latency is definitely a problem.[详细]

2023-04-06 14:14 分类：问答

What is the best way to manage "non-SQL Server" SQL objects within Visual Studio 2010?

Visual Studio has a Database Project for Sql Server. This has a number of advantages: it hosts configuration settings, and database objects in one place. 开发者_运维百科The .sql files are part of the[详细]

2023-04-06 09:26 分类：问答

Calling Sybase Adaptive Server Enterprise's "sp_help" from JDBC

In order to query the database meta data in Sybase ASE, I found this relevant answer (not the accepted one), to be ideal:[详细]

2023-04-02 02:13 分类：问答

Linked connection between MS SQL SERVER and Sybase ,Unicode problem

I added linked server on MS SQL SERVER 2008 with Sybase ASE 12.5 databases, everything works fine, but i\'ve got problem with开发者_JAVA百科 unicode strings.[详细]

2023-03-30 10:52 分类：问答

Sybase ASE Entity Framework - Error while updateing record to database -"incorrect syntax near '('.\n"

I am trying to simple update and existing record. And I am getting the error - incorrect syntax nea开发者_Go百科r \'(\'.\\n[详细]

2023-03-26 11:38 分类：问答

correct way to migrate a sybase database to new hardware

I have a small Sybase ASE 15 database on a box that is scheduled to be de-commissioned. What is the best way to \"clone\" or \"transfer\" my database to the new box?[详细]

2023-03-26 01:09 分类：问答