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.

sqlstate=HY000

3 posts in General Discussion Last posting was on 2005-06-17 17:08:51.0Z
costas Posted on 2005-06-11 18:51:04.0Z
Sender: 3fe2.42aa243f.1804289383@sybase.com
From: costas
Newsgroups: ianywhere.public.general
Subject: sqlstate=HY000
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42ab3297.4556.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Jun 2005 11:51:04 -0700
X-Trace: forums-1-dub 1118515864 10.22.241.41 (11 Jun 2005 11:51:04 -0700)
X-Original-Trace: 11 Jun 2005 11:51:04 -0700, 10.22.241.41
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4552
Article PK: 8361

Hi all,

when i try to establish a second connection to a remote asa
database i get the error :
sqlstate=HY000
[SYBASE][ODBC Driver Loader] Not supported until driver
loaded.
with sqlcode is -1 and the dbcode is -134.

The dsn file of the 1st connection (local) is:
[ODBC]
uid=dba
pwd=sql
enginename=test_final
databasename=Test1
databasefile=\Program Files\Sybase\ASA\test1.db
start=\Program Files\Sybase\ASA\dbsrv9.exe -n test_final -gd
all

and the fir the 2nd connection (remote -wifi):
[ODBC]
uid=dba
pwd=sql
CommLinks=TCPIP(dobroadcast=DIRECT;host=192.168.1.2;port=2638)
enginename=test_final
databasename=test_final
driver=\Program Files\Sybase\ASA\dbodbc9.dll
LIVENESSTIMEOUT=90000

Any hint is appreciated

/costas


Greg Fenton Posted on 2005-06-12 02:09:55.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: sqlstate=HY000
References: <42ab3297.4556.1681692777@sybase.com>
In-Reply-To: <42ab3297.4556.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <42ab9973$1@forums-1-dub>
Date: 11 Jun 2005 19:09:55 -0700
X-Trace: forums-1-dub 1118542195 69.198.107.137 (11 Jun 2005 19:09:55 -0700)
X-Original-Trace: 11 Jun 2005 19:09:55 -0700, cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 26
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4553
Article PK: 8360


costas wrote:
>
> when i try to establish a second connection to a remote asa
> database i get the error :
> sqlstate=HY000
> [SYBASE][ODBC Driver Loader] Not supported until driver
> loaded.
> with sqlcode is -1 and the dbcode is -134.
>

Please always provide the version and build number of SQLAnywhere that
you are using (i.e. use the command "dbeng9 -v").

What is "dbcode" ? SQLCode -1 does not exist, but -134 is "Feature %1
not implemented".

Can you show us the code that creates this second connection?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


costas Posted on 2005-06-17 17:08:51.0Z
Sender: 18bb.42b09a54.1804289383@sybase.com
From: costas
Newsgroups: ianywhere.public.general
Subject: Re: sqlstate=HY000
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42b303a3.3417.1681692777@sybase.com>
References: <42ab9973$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Jun 2005 10:08:51 -0700
X-Trace: forums-1-dub 1119028131 10.22.241.41 (17 Jun 2005 10:08:51 -0700)
X-Original-Trace: 17 Jun 2005 10:08:51 -0700, 10.22.241.41
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4566
Article PK: 8371

Hi Greg,

Thanks for your time.I fixed it.
(the sqlcode and sqldbcode are the properties of the
transaction object).
Thanks again.

/costas

> costas wrote:
> >
> > when i try to establish a second connection to a remote
> > asa database i get the error :
> > sqlstate=HY000
> > [SYBASE][ODBC Driver Loader] Not supported until driver
> > loaded.
> > with sqlcode is -1 and the dbcode is -134.
> >
>
> Please always provide the version and build number of
> SQLAnywhere that you are using (i.e. use the command
> "dbeng9 -v").
>
> What is "dbcode" ? SQLCode -1 does not exist, but -134 is
> "Feature %1 not implemented".
>
> Can you show us the code that creates this second
> connection?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/