SQLWindows 5.03/SQLAnywhere 5.0 via ODBC
We are using SQLWindows 5.03 with SQLAnywhere via ODBC.
Has anyone used Stored procedures with SQLWindows ? We have had problems
returning result sets to SQLWindows. OdrPrepareProc function doesn't get
the result set returned by SQLAnywhere. This works with MS SQLServer.
Inserting, updating and deleting works fine with SQLAnywhere.
Thanks in advance,
"ME" <email@example.com> wrote:
>We are using SQLWindows 5.03 with SQLAnywhere via ODBC.
>Has anyone used Stored procedures with SQLWindows ? We have had problems
>retur...Upgrade SqlAnywhere Server 5.0 auf SqlAnywhere 7.0
We want to upgrade our SqlAnywhere database server from 5.0
to 7.0. How does this work? Please help me.
You can either unload/reload or upgrade the database. The documentation
BTW ASA7 is currently in limited support. Current versions are ASA8 and ASA9
so it would be wise to consider going to a later version.
<Gerhard> wrote in message news:firstname.lastname@example.org...
> We want to upgrade our SqlAnywhere database server from 5.0
> to 7.0. How does this work? Please help me.
> Many th...Trouble sharing a dbclient ODBC connection between two processes on web server SQLAnywhere 184.108.40.206
I am trying to tie a whole bunch of legacy components together with a new
reporting engine and I've come across an interesting problem. I have a W2k
Web server that is connecting to an NT4.0 SQLAnywhere 220.127.116.11 database
server via an ODBC dbclient connection.
The web server is running classic ASP pages for the bulk of the web
site, with a single ASP.net section for viewing reports.
Everything works great and I can connect to the database as long as I
have only one of the connections active - either the ASP or ASP.net site.
As soon as I try to connect both at ...How do I migrate a SQLAnywhere 5.0 standalone database to ASA 6.0 ?
How do I migrate a SQLAnywhere 5.0 standalone database to ASA 6.0 ?
In the project I am working on I need to move a SQLAnywhere 5.0
standalone database to ASA 6.0. standalone.
The application accessing the data is written in Powerbuilder 5.0
In addition to the 6.0 connection I must also maintain a connection
to a SQLAnywhere Server 5.5.04.
1. Can this be done ?
2. Do I need to do anything with the database itself ?
3. What must I do to configure the database ?
4. What are the things I need to do to deploy ?
connect a SQLA 5.0 whit driver ASA ...Problem Upgrading SQLAnywhere 5.5 Databases to ASA 6.0.1
I have a few small databases in SQLAnywhere 5.5 Since I don't have the
driver or server available I wanted to convert them to ASA 6.0.1
However, the upgrade utility in Sybase Central 3.1.0 reports that the
databases are not a valid ASA database file. Is this a bug or am I
missing something here?
...error -83 using PB.6.0 and sqlanywhere 5.5.03
I have a SQL Anywhere server database sitting on a dedicated NT Server. I
run the application from my client and I connect to the server database
without any problems. However, a second developer attempts to run the
application from his workstation and tries to connect to the same database
the following messsage is received:
SQLSTATE = 08001
[Sybase] [ODBC Driver] Unable to connect to database server: specified
database not found
I can connect many processes to the same database from a single workstation,
but the moment I try and connect from another workstation...Error on Set Trans Object with PB 6.0 + SQLAnywhere 5.0
I want to select 1 of 5 data tables to read so I use code to
set the DataWindow DataObject to the data object I want to
This works fine for 2 of the 5, but on 3 of them I get an
error on the Set Trans Object command. Can anyone give me an
idea on what is wrong? Thanks. riley
Compile your application to pbd or use resource file (pbr) for those
datawindows that are assigned dynamically.
> I want to select 1 of 5 data tables to read so I use code to
> set the DataWindow DataObject to the data object I want to
> This works fine f...SQLAnywhere 9.0.0 (1108) with Clarion 5.5
I'm having an Identity crisis <g>. I have used code like this for several
years, and never with any problem. I insert a record and then use
@@Identity to retrieve the autoincremented sysid of the inserted record.
Last week, a user ran a process (which does generally work and has been
running very smoothly) and instead of retrieving the sysid from the inserted
record, @@Identity returned the sysid of a completely different record that
had been inserted several minutes earlier than the one just added. I can't
recreate the problem either. Any ideas? Thanks!!
Here is t...SQLAnywhere 5.0 ODBC Driver
Does anyone could help me? We have an old SQLAny where .db file and we need
to read it.
How can I get an ODBC Driver for a SQL Anywhere 5.0 DataBase?
Thanks in advance,
You can download the ASA version 6 evaluation version. It will read a
version 5 database file.
Jim Egan [TeamSybase]
Sybase Developers Network
The URL to get to the downloads is this:
But it's broken for now. Check it in a day or so.
Jim Egan...sqlanywhere 5.0 ODBC trouble
when i try to connect with my database when i am testing mi exe the
following error message is displayed:
SQLAllocHandle driver fail in SQL_HANDLE_ENV.
Thanks in advance.
In article <sWEb86R$9GA.email@example.com>, firstname.lastname@example.org
> when i try to connect with my database when i am testing mi exe the
> following error message is displayed:
> SQLAllocHandle driver fail in SQL_HANDLE_ENV.
> Any idea?
> Thanks in advance.
You can search for this on www.dejanews...Netware 5.0+Groupwise 6.0 -->> Netware 6.0+Groupwise 6.5
We've got a Netware 5.0 server running Groupwise 6.0 and we would like
upgrade it to Netware 6.0 with Groupwise 6.5. What's the safest way of
doing this? We've got a spare server where we can dump things
Should we upgrade Groupwise first or Netware?
Scott Le Brun
Computer Operations Co-ordinator
Mount Scopus Memorial College
> Should we upgrade Groupwise first or Netware?
Personally, I'd upgrade Netware first, make sure GW works in it's
current config and then upgrade GW....ASA6 or SQLAnywhere 5.5 on Netware 5.0?
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii
Does anyone know if either ASA6.0 or
SQLAnywhere 5.5x will run on Netware 5.0? I've
asked Sybase several times (in the past 3 month
period) and I still haven't received an answer.
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Description: Card for Bernard Mikowski
Content-Di...Will PD2.0 WORK WITH SQLAnywhere 18.104.22.168??
Does anyone know of any compatibility issues with using PD2.0 with this
newer version of SQLA?
What about the new Adaptive Server Anywhere 6??
Thanks for any input you can offer,
Works fine with 5.504 and I can't think of any reason why it wouldn't work
Carson Hager Dynamic Data Solutions
Team Powersoft http://www.dyn-data.com
MS Certified Professional
******** Are You Ready for ...Concurrent perl 5.6.0, 5.6.1, 5.8.0, and 5.8.0threaded
So, I'd like to have multiple versions of perl installed on my system,
for testing stuff, poking around, etc. It's not really that difficult,
actually - you just arrange that they have different @INC directories
(or that they overlap in the ways you want them to), and you make
/usr/bin/perl point as a symlink to whichever version you want to use
regularly (probably 5.6.1).
Here's what I think I'd have, creating a few fink packages to manage
things for me:
* /usr/bin/perl5.6.0 - Apple's perl, unmodified, @INC is: