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.

Help with connection. Keyword not supported: 'dsn'

3 posts in Appeon (partner product) Last posting was on 2010-04-09 07:38:51.0Z
Michael K Posted on 2010-04-08 07:11:55.0Z
Reply-To: "Michael K" <michael.kench@stiearc.com.au>
From: "Michael K" <michael.kench@stiearc.com.au>
Newsgroups: sybase.public.appeon
Subject: Help with connection. Keyword not supported: 'dsn'
Lines: 28
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bbd81bb$1@forums-1-dub>
Date: 8 Apr 2010 00:11:55 -0700
X-Trace: forums-1-dub 1270710715 10.22.241.152 (8 Apr 2010 00:11:55 -0700)
X-Original-Trace: 8 Apr 2010 00:11:55 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2466
Article PK: 21710

Hi,

I am trying to test a simple application using appeon 6.5 with a SQL SERVER
2000 database.
I am getting the popup error message below when I try to run the system.
Error 10999. Keyword not supported: 'dsn'

Does this look familiar to anyone?
Using powerbuilder 11.2 on vista 32 machine and the appeon demos are working
fine.

I believe I have setup the sqlca connection cache for gensol_payv4_0 and
have tested the connection OK.
Connection string is as follows
SQLCA.DBMS = "ODBC"
SQLCA.DBPARM=
"Connectstring='DSN=gensol_payv4_0;UID=DBA;PWD=SQL',Delimitidentifier=1"

When I "CONNECT USING SQLCA";
I get the following in the sqlca.errortext
Errors occurred in the Appeon communication layer.Possible causes: 1. The
network is unstable or disconnected. 2. Appeon Server does not work. 3. The
pb coding style is undefined.

Regards
Michael


Michael K Posted on 2010-04-09 01:34:32.0Z
Reply-To: "Michael K" <michael.kench@stiearc.com.au>
From: "Michael K" <michael.kench@stiearc.com.au>
Newsgroups: sybase.public.appeon
References: <4bbd81bb$1@forums-1-dub>
In-Reply-To: <4bbd81bb$1@forums-1-dub>
Subject: Re: Help with connection. Keyword not supported: 'dsn'
Lines: 35
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bbe8428@forums-1-dub>
Date: 8 Apr 2010 18:34:32 -0700
X-Trace: forums-1-dub 1270776872 10.22.241.152 (8 Apr 2010 18:34:32 -0700)
X-Original-Trace: 8 Apr 2010 18:34:32 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2467
Article PK: 13448

Figured out I couldn't use the ODBC driver with MSSQL. Once I changed the
connection to use the MS SQL SERVER native driver it connects.

"Michael K" <michael.kench@stiearc.com.au> wrote in message
news:4bbd81bb$1@forums-1-dub...
> Hi,
>
> I am trying to test a simple application using appeon 6.5 with a SQL
> SERVER 2000 database.
> I am getting the popup error message below when I try to run the system.
> Error 10999. Keyword not supported: 'dsn'
>
> Does this look familiar to anyone?
> Using powerbuilder 11.2 on vista 32 machine and the appeon demos are
> working fine.
>
> I believe I have setup the sqlca connection cache for gensol_payv4_0 and
> have tested the connection OK.
> Connection string is as follows
> SQLCA.DBMS = "ODBC"
> SQLCA.DBPARM=
> "Connectstring='DSN=gensol_payv4_0;UID=DBA;PWD=SQL',Delimitidentifier=1"
>
> When I "CONNECT USING SQLCA";
> I get the following in the sqlca.errortext
> Errors occurred in the Appeon communication layer.Possible causes: 1. The
> network is unstable or disconnected. 2. Appeon Server does not work. 3.
> The pb coding style is undefined.
>
> Regards
> Michael
>
>


Steven Posted on 2010-04-09 07:38:51.0Z
Sender: 381c.4bbed6d0.1804289383@sybase.com
From: Steven
Newsgroups: sybase.public.appeon
Subject: Re: Help with connection. Keyword not supported: 'dsn'
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bbed98b.3870.1681692777@sybase.com>
References: <4bbd81bb$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Apr 2010 00:38:51 -0700
X-Trace: forums-1-dub 1270798731 10.22.241.41 (9 Apr 2010 00:38:51 -0700)
X-Original-Trace: 9 Apr 2010 00:38:51 -0700, 10.22.241.41
Lines: 41
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2469
Article PK: 21708

Hi Michael,

The error is caused by using ODBC driver. Actually Appeon
.NET supports using SQL server native driver to connect with
SQL server databases.


Regards,
Steven

> Hi,
>
> I am trying to test a simple application using appeon 6.5
> with a SQL SERVER 2000 database.
> I am getting the popup error message below when I try to
> run the system. Error 10999. Keyword not supported: 'dsn'
>
> Does this look familiar to anyone?
> Using powerbuilder 11.2 on vista 32 machine and the appeon
> demos are working fine.
>
> I believe I have setup the sqlca connection cache for
> gensol_payv4_0 and have tested the connection OK.
> Connection string is as follows
> SQLCA.DBMS = "ODBC"
> SQLCA.DBPARM=
> "Connectstring='DSN=gensol_payv4_0;UID=DBA;PWD=SQL'
> ,Delimitidentifier=1"
>
> When I "CONNECT USING SQLCA";
> I get the following in the sqlca.errortext
> Errors occurred in the Appeon communication layer.Possible
> causes: 1. The network is unstable or disconnected. 2.
> Appeon Server does not work. 3. The pb coding style is
> undefined.
>
> Regards
> Michael
>
>