All, After several months of not touching our databases I fired up Rapid SQL and get this error when I try and connect to a registered Sybase DB: "Layer (5) Origin (3), Severity (5), Number (3) ct_connect(): network_packet_layer: internal net library error: Unable to find an available protocol driver structure" Any ideas? I'm running...
I need to work with this db and would like to get a quick start. Would anyone recommend a decent documentation/tutorial/examples? I didn't find anything useful at the official website ...
I have a Sybase ASE server that I'm able to connect to with ASE iSql totally fine. The database definition in my sql.ini file looks like: [<NAME>] master=TCP,<servername>,<port> to connect with iSql, I can make the following command-line call and it works: isql -U <username> -P <password> -S <NAME> My ultimate goal is to use SQL An...
Using the .NET Framework 2.0 on a computer with the LCID set to 1033, I am connecting to a Sybase ASE 12.5.4 server which has its default character set to sjis. When I retrieve fields which contain Japanese text, I must, in code, convert each field from cp1252 to cp932 to display the text properly. However, when I set the computer to L...
Unfortunately searching for 'Sybase Post' doesn't get me the answers I'm looking for. I want to know what the actual function is of POST As in .. procedure lala POST procedure1() procedure2() I'm guessing in the above code, procedure2 would be executed before procedure1, that's fine. But when is it processed? After everything else ...
hi *, I need to trace changes on a record in database. I have some triggers on different tables that calls one stored procedure and this sp updates records in certain table (table1). I will trace records in table1 to find when and from where data are changed. Actually I use sybase 12.5 and I would know how to read LOG file by SQL qu...
I have linked Sybase database table with Access 2003. I only have read access to the Sybase database and created a pass-through query in access. Now what I need is, I need to create a temp table in Access with the data output of pass-through query. ...
Hello everyone: Does image data type be converted to byte array in sybase? I apply web service to get data set in sybase( image data type). I use byte[] to get returning of web service. Then i use the "response.binarywrite(byte[])" to show the image.(ASP.NET C#) But there' s a image distortion problem (When i zoon in the image, some poi...
Hi, I have a string like '2008-01-01 11:09:11' How do I convert this to a datetime ? ...
I have a Sybase SQL Anywhere 11.0.1 database that I am using to sync with an Oracle Consolidated Database. I know that the SQL Anywhere database keeps track of all of the changes that are made to it so that it knows what to synchronize with the consolidated database. My question is whether or not there is a SQL command that will tell y...
Hello, When connecting to a Sybase ASE database via ODBC using the code below, I'll occasionally get a '[IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed' error. Can this be caused by my code? I read here that I should be using the 'With' statement instead, but I don't understand how that would affect this. T...
Say I want to do this with SQL (Sybase): Find all fields of the record with the latest timestamp. One way to write that is like this: select * from data where timestamp = (select max(timestamp) from data) This is a bit silly because it causes two queries - first to find the max timestamp, and then to find all the data for that timest...
How would you convert a string like '2008-01-01 11:09:11' to a datetime ? The string is from outside of Sybase and I want to know how to insert it as a datetime ...
Database server is migrated from version 12.5x to version 15.03 Sybase.Data.AseClient version - 1.15.50.0 I am getting below exception when I run few stored procedures through .Net app (using AseClient) Internal Error :30016 Unknown Dataitem Dataitem Stack Trace - at Sybase.Data.AseClient.AseDataReader.CheckResult(Int32 res) ...
Please help me in writing SWIG interace. I want to open a database connection handle in C program. This handle must be passed to Perl, where I will use the Perl DB interface for interacting with the database. For security purpose we wanted to use this mechanism. I want to pass the database handle using SWIG interface. Added: We are ...
Hi, just having some headaches implementing something in a trigger on a old version of Sybase and wondered if anyone could help. In a nutshell, I want to write a trigger that will call another sproc for each of the affected records (whether it be inserted, deleted or both [updated]). One way to do this in T-SQL (SQL Server) would be to ...
I have been smashing my head against this for a while now. I am using iBatis with my JAVA code to run Stored Proc residing in Sybase DB. Stored procedure is expecting some parameters. few of them are declared as VARCHAR (6) So in my iBatis mapping i did the following for those parameters. <parameter property="searchUserId" jdbcTyp...
So I have this sql query select user_id, profile_id from user_groups join profile_groups on user_groups.group_id=profile_groups.group_id group by user_id, profile_id having count(user_groups.group_id) = (select count(*) from profile_groups as pg where pg.profile_id=profile_groups.profile_id) and count(profile_groups.group_id) = (se...
I have a sybase server on aix . Now I need to migrate it to windows . How should I do ? Thank you ...
I'm trying to connect to Sybase database from the web server using UnixODBC. Sybase is installed on windows server while the web server is on Unix Server. In order to connect to Sybase I'm using UnixODBC which requires the file libdbodbc.so for Sybase I'm trying to locate this file but I'm unable to find it anywhere. Anyone can tell ...