In SQL Server and Sybase how exactly Server login, Database login work? what is the different?

Shawn

08-25-2004 10:34 AM
Ollie

Hi! Is it possible to convert an int field to datetime? In one of our Sybase ASE DB there is a field called "time" of type int, and it contains...

Kjell Pettersen

08-25-2004 10:07 AM
Bret Halford

Can anyone point me at an independent review of the Sybase IQ product? How it works, advantages and disadvantages, equivalent products, etc. By...

Tom Brehony

08-25-2004 06:51 AM
Tom Brehony

Hello everyone, We are looking for beta-testers for our new product - Scribe Report Generator. At this moment, Scribe supports 6 relational...

Alex Molochnikov

08-24-2004 10:29 PM
Febin

Hi, I'm using Sybase Adaptive Server Enterprise Edition ( ver 12.5.0.3 ). I have a big query that fetches about 128,000 records. Our application's...

Amit Gupta

08-24-2004 10:23 PM
Febin

I have procedure code something like the following. update t set ... where k = @k if @@rowcount = 0 insert into t ... This code is executed by a...

Brian Dick

08-24-2004 10:14 PM
Brian Ceccarelli

Hi all, I would like to know the list of currently executing query for a particular SPID. I guess "dbcc sqltext(SPID)" gives me this data but it's...

Amol Natekar

08-24-2004 01:09 PM
Bret Halford

Consider this: select 1 as oldid, 2 as id into #tmp; update #tmp set id=oldid, oldid=0; Is it guaranteed that id will be non-zero? I.e. is it...

Gregory Bond

08-24-2004 12:47 PM
Bret Halford

Hi, I install ASE 12.5.2 + HA on windows 2000. When I launch command sp_companion return error COMMAND sp_companion...

Luis

08-24-2004 03:15 AM
Luis

Hello We hv a Sybase 11.0.2 Installation on SGI IRIX6.2 The Storage is 12X1GB Drives with XLV. There are four DBs created on 8 raw partitions...

Charyulu

08-23-2004 11:51 AM
Me

Hello all , We are using Proxy Table to access remote server table. I know we have a server option for 'net password encrytion' but what abt data...

Mahesh Hardikar

08-23-2004 10:20 AM
Mahesh Hardikar

Hi, I know this is probably an easy question that has been answered before, but after crawling through google groups for two days now I find I...

Luke

08-23-2004 02:45 AM
Michael Peppler

Hello We have Sybase 11.0.2 Installation on SGI IRIX 6.2. Mirroring the master device is failing since PUBS2 db is corrupted. I am new to Sybase. Is...

Charyulu

08-20-2004 08:50 AM
Willie Kraatz

Hi All, I am asking this question for my MS web developers, as I know nothing about OLEDB connectivity ... is there an OLEDB driver...

Sara Law

08-19-2004 06:12 PM
Jim Douglas

The subject line says it all. We are currently upgrading our Sybase server, and I would like to know what the most stable version of 12.5.x that...

Tom Brehony

08-19-2004 12:26 PM
Tom Brehony

Group, Feel free flame away ;>P.I know little about Sybase.....I manage a small medical group's network.They use a Sybase database for their practice...

Adysthemic

08-19-2004 11:56 AM
Mark A. Parsons

Everything I'm trying to do here worked great in 7.0.4, and I'm trying to migrate to 9.0.1. I've got everything worked out except for calls to java...

David Kerber

08-19-2004 10:09 AM
David Kerber

Hello! I've got a problem with a sybase *.db database file. I like to convert it to a csv file or connect with access (via odbc) to that database....

Willi Baldt

08-19-2004 08:56 AM
Willi Baldt

Adding another 4GB RAM ( Total 8GB ) to improve performance. Sybase 12.5 2 dataserver on HP-UX ( 2 nodes ). My questions about reconfiguration of...

Shawn

08-18-2004 06:25 PM
Shawn

Hi, I am failed in installing ASE12.5.2 developer edition on to Redhat Enterprise Server 2.1. Could u giv me a suggestion? Kernel: 2.4.9-e.27smp...

Qi

08-18-2004 04:55 AM
Qi

I have searched the messages before,this issues seems is releated with glibc. The glibc version in my platform is: And the installation guide from...

Qi

08-18-2004 03:51 AM
Qi

How is the exact process to re-configure Sybase 12.5 memory allocation ( RAM increased already ) on a 4 CPU, 2 Dataserver , Cluster-based HP-UX...

Shawn

08-18-2004 01:27 AM
Shawn

How is the exact process to re-configure Sybase memory allocation ( RAM increased already ) on a 4 CPU, 2 Dataserver , Cluster-based HP-UX Sybase...

Shawn

08-18-2004 01:27 AM
Shawn

How Is the process of Shutdown sybase on Cluster machine? Is it going to fail over which I don't want? Spec: We have Sybase 12.5 on HP-UX Please...

Shawn

08-18-2004 12:54 AM
Shawn

Hi, I have to use an sybase driver into a C program. It's a little serveur which wait incoming connection then fork each client and create a db...

captain biceps

08-17-2004 08:32 PM
Brian Ceccarelli

I have an older Watcom SQL db file that I need to export the data that is contained inside the file. I know very little about the file except that...

Batman

08-17-2004 05:26 PM
Batman

We are on 12.5 HP-UX sybase server. Manager decide to add memory to box ( $G -> 8GB > and our HP Admin will increase HP SHMMEX parameter and we are...

Shawn

08-17-2004 05:20 PM
Shawn

Anyone here remember the old text based windowing front-end called APT? I'm still using it! If you do remember it, do you remember how to find out...

Tom Brehony

08-17-2004 05:43 AM
Tom Brehony

Hello All, QS1: --- In an Replication and HA SETUP,IF I change the password for sa,will it create any problem for replication and HA? QS2 --- I am...

Febin

08-17-2004 02:24 AM
Febin

Hi all, I would like to know the maximum number of "user defined caches" like 'default data cache' that can be created on a sybase server. Thanks in...

Amol Natekar

08-16-2004 02:14 PM
Larry Coon

Hello, i am a novice sybase user and need this aid for an maintenance task. I have only isql and bcp utilities, another utilities are not...

Fadel

08-16-2004 12:36 PM
Fadel

Hello, Has anyone else had a problem where sp_addmessage starts failing with: "Cannot run query--referenced object (name NAME NOT RECOVERABLE)...

Simon Andrew

08-16-2004 01:07 AM
Simon Andrew

two part problem here 1. It appears I can only have one sql stmt in a batch file that i referenced on command line call to dbisql. Can this be...

PowerHammer

08-13-2004 02:52 PM
PowerHammer

Hello, I came across this very strange behaviour on Sybase 12.5, ODBC drivers 4.10. Say you have an active statement, if you start/commit a...

TomTom

08-13-2004 01:22 AM
SerGioGio

Sorry if this is the wrong group but not sure where to post this. I am trying to get the average time from a number of rows. E.g Task ...

Chick

08-11-2004 06:36 PM
Sara Law

I have setup ASE and Monitor server according to manuals. Everything comes up fine. I can connect to ASE/Monitor via Sybase Central. I can view...

Kent Rademacher

08-11-2004 06:01 PM
Sara Law

I am working on Sybase 11.5.1 on Aix 4.2.1 As far as I know it is not possible to get bcp to output data in comma seperated variable length (CSV)...

Tom Brehony

08-11-2004 08:56 AM
Thomas Gagne

I have a Sybase server (11.5.1) running under AIX 4.2.1. I have changed the backup servers start script to output to a log file which corresponds to...

Tom Brehony

08-06-2004 08:41 AM
Pablo Sanchez

Currently we are using Sybase 12 and a Pogo wrapper to load data into Sybase databased. But recently there has been a requirement to handle special...

BenJose

08-04-2004 11:41 PM
BenJose

Hi, can user-defined role be granted to a group? i tried the following commands: ---------- create role my_role exec sp_addgroup my_group go

Lena

08-04-2004 04:20 PM
Bret Halford

HI all, I am trying to write few queries for fetching some usefull data from the system tables like sysprocesses,sysdatabases,sysusages etc. But I...

Amol Natekar

08-04-2004 04:16 PM
Bret Halford

Dear All, We are using ASE-12.5(32 bit) on AIX 5.2 . We are havine 3 CPU's and two engines. we are using datarows locking. Most of the...

suraj kumar

08-04-2004 04:09 PM
Bret Halford

When there are triggers present in the table, why does bcp default into the slow mode? The triggers are not getting fired anyway. So what is the use...

George

08-04-2004 11:49 AM
George

Hi, I need to update the phone numbers in a table. if the first 7 numbers are "(909)222-", I need to change them to "(909)333-", regardless what the...

eddie wang

08-03-2004 05:08 PM
eddie wang

Hi, I'm in big trouble.. Did you know if sybase 11.9.2 under NT and/or Linux is thread safe ? I mean I've done a simple little C program with 2...

captain biceps

08-03-2004 01:01 PM
Neal

When i execute a select statement with a group by. I get a worktable created. When i run sysmon on the system during this period I only see APL...

James Wright

08-02-2004 11:58 AM
James Wright

Hi, I hope someone out there can help. I have a web application that uses stored procedures extensively. Up until today, I never had a problem with...

Raj

08-01-2004 06:27 AM
Simon Andrew

Hi, We have a process that launches multiple BCP process. In this scenario, we have observed the following error: " Start loading,...

piponista

07-30-2004 02:41 PM
Sara Law

I'm trying to bcp a file from UNIX server to Sybase Database. I get the following error if I specify SYBASE variable in the Per script...

ane4ka

07-30-2004 03:02 AM
Minoru Aoki

Hi all, I have been using DBXRay to Monitor a sybase server but it fails when someone executes sp_sysmon. Is there any way to avoid such kind of...

Shweta

07-29-2004 01:40 AM
Shweta