I am working on ASP.NET application. I try to connect to database in Adaptive Server Enterprise using Sybase.Data.AseClient dll. Connection string that I am using is 'Data Source='host';Port='5000';UID='user';PWD='password';Database='database';'. When Application tries to connect to database exception is thrown. 'Client can not establish...
After install Sybase v12.54, I tried TableViewer app under samples folder. But got exception:Connection to Sybase server has been lost. All active transactions have been rolled back. I added 'Connect Timout=300' to the connection string, it works, but slow... What's the problem here? Thanks in advance. ...
I am trying to connect to sybase ASE 15 and call a SP that does some DML. I was wondering if anyone has any pointers to a sybase helper class analogous to SQLhelper.cs or if someone has any pointers to any blog / sample code. Eventually I will be migrating the solution to SQl Server 2008 R2 (couple of months from now) so I want to creat...
I wonder any one is conneting Sybase ASE using pyodbc in Django? Any wrapper available for that? Any solution? Currently there are: - sqlany-django (http://code.google.com/p/sqlany-django/) for Sybase SQL Anywhere and not Sybase ASE - django-pyodbc (http://code.google.com/p/django-pyodbc/) for MS SQL Server through pyodbc Thanks. ...
I'm using Pdo_Mssql adapter against a Sybase database and working around issues encountered. One pesky issue remaining is Zend_Db's instance on quoting BIT field values. When running the following for an insert: $row = $this->createRow(); ... $row->MyBitField = $data['MyBitField']; ... $row->save(); FreeTDS log output shows: dbutil.c:...
1 Select id,count(*) as totalX FROM my_table WHERE x_factor = 1 GROUP BY id ResultSet: id totalX --------- -------------- 9 34 10 6 11 21 12 3 2 Select id,count(*) as totalY FROM my_table WHERE y_factor = 1 GROUP BY id ResultSet 2: id...
Hi, I need to update a column value in a table based on values from a Other 2 tables. I was able to write a update statement to achieve this: update T3 set col=T1.x from T1,T2,T3 where ... This takes lot of time since the table T3 has more than million records. I would like to get the value v1 from T1 and loop over them and get co...
Dear Friend I want to connect Sybase 12.5 using vb 6.0, then what should be provider i can use to connect the Sybase 12.5. thanks ...
Hey Everyone, If there are any Sybase ASE experts out there, I was wondering if there is a way to get Sybase to trace all the queries that it receives. I currently have a program running that usually begins displaying some strange behaviour after 7 hours from startup. I would like to find out what Sybase is doing at this time, so that...
Running on Adaptive Server Enterprise/15.0.3/EBF 17157 ESD#3/P/x86_64/Enterprise Linux/ase1503/2726/64-bit/FBO/ The below code should never enter the substring case, however I am presented with a Sybase Error 536. Is this a form of optimization where it evaluates all paths regardless of the actual value?? We can work around this but w...
I need to Retirve the following Details using Sybase SQL Query. 1) Database Data File Path 2) Database Transaction Log File Path 3) Path where SybaseSoftware Installed 4) Patch Installed on Sybase Thanks. ...
Dear Friends when i run sp_helpdb dbname query in sybase it return only following columns name,db_size,owner,dbid,created,status & not returning the following Columns device_fragments,size,usage,created,free kbytes I m using sybase Adaptive Server Enterprises Why this happend plz help me Thanks in advance ...
HI, I have a SP which returning more than 100 fields with 1000+ row. I need to to save all in temp table and and rum my customize query to get the appropriate data. I did many search but i am unable to find the right solutions for my project. I will appreciate if anyone can share his idea. create table #SP_Result (i need to create fie...