Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Enquriy

2 posts in Windows NT Last posting was on 1997-09-19 06:47:43.0Z
EDP Department Posted on 1997-09-19 03:21:04.0Z
From: "EDP Department" <saiho@hkabc.net>
Subject: Enquriy
Organization: Birkart East West Freight Ltd
Message-ID: <01bcc531$b762b4e0$a4fd49ca@jonathan>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlserver.nt
Date: Thu, 18 Sep 1997 23:21:04 -0400
Lines: 14
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5517
Article PK: 1081596

Dear Sir/Madam,

I am writing to you about the problem on connection between PowerBuilder
5.0 and MS SQL Server 6.5 via Database Painter in PowerBuilder 5.0.
When I tried to connect to a database, the connection was successful. And
I used "sa" to connect. But when I tried to retrieve data from system
tables or newly created tables. An error message was displayed to me. It
is "<Column-name>'s data type is not supported". I checked that the
database repository tables were created already.

Thanks,

Martin Yip


Tolga ULGEN Posted on 1997-09-19 06:47:43.0Z
Message-ID: <3422200F.4E84C123@info.com.tr>
Date: Fri, 19 Sep 1997 09:47:43 +0300
From: Tolga ULGEN <tulgen@info.com.tr>
Organization: InfoSybase
X-Mailer: Mozilla 4.01 [en] (WinNT; I)
MIME-Version: 1.0
To: EDP Department <saiho@hkabc.net>
Subject: Re: Enquriy
X-Priority: 3 (Normal)
References: <01bcc531$b762b4e0$a4fd49ca@jonathan>
Content-Type: text/plain; charset=iso-8859-9
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 26
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5515
Article PK: 1081593

I'm not sure but I think there' s a problem with the 'identity' column
type of MS SQL Server and Pb. You can't even get the data displayed if
you use quick select when creating a datawindow.
If you have a identity column you should be very careful, since
'identity' is the most buggy part of the MS SQL Server. You should check
the identity (I don't know the exact command) even in your application.

EDP Department wrote:

> Dear Sir/Madam,
>
> I am writing to you about the problem on connection between
> PowerBuilder
> 5.0 and MS SQL Server 6.5 via Database Painter in PowerBuilder 5.0.
> When I tried to connect to a database, the connection was successful.
> And
> I used "sa" to connect. But when I tried to retrieve data from system
>
> tables or newly created tables. An error message was displayed to
> me. It
> is "<Column-name>'s data type is not supported". I checked that the
> database repository tables were created already.
>
> Thanks,
>
> Martin Yip