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.

Connecting to a ver 5.5 sqlAnyWhere

12 posts in General Discussion Last posting was on 2007-08-29 16:59:13.0Z
Walter Levine Posted on 2007-08-27 18:05:32.0Z
Sender: 5f36.46c46d21.1804289383@sybase.com
From: Walter Levine
Newsgroups: ianywhere.public.general
Subject: Connecting to a ver 5.5 sqlAnyWhere
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46d3126c.5613.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Aug 2007 11:05:32 -0700
X-Trace: forums-1-dub 1188237932 10.22.241.41 (27 Aug 2007 11:05:32 -0700)
X-Original-Trace: 27 Aug 2007 11:05:32 -0700, 10.22.241.41
Lines: 59
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6236
Article PK: 4668

I am developing with SQL AnyWhere ver 10 which I downloaded
within the past 2 weeks. (windows)
I have a web service that I need to deploy on a remote
machine which appears to be using ver 5.5 build #1869
The db file is on a networked drive. When I try to execute
the code by browsing the asmx file, it just hangs on the
Open(). It does not even timeout,(the timeout is at 150)
I registered the dll in the GAC and do not get the dll error
My code is below:
I hope you can suggest a solution
Thanks in advance for your help
***************************************
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using iAnywhere.Data.SQLAnywhere;
using System.Data.SqlClient;
using System.Xml;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo =
WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
public Service () {
}

[WebMethod]

public DataSet sendPDS()
{
string ret = null;
DataSet ds = new DataSet();
iAnywhere.Data.SQLAnywhere.SAConnection
saConnection;
saConnection = new
iAnywhere.Data.SQLAnywhere.SAConnection(@"UserID=dba;Password=sql;
DatabaseFile=""d:\pdsdb\pds_apps.db""");
try
{
saConnection.Open();
ret = "OK";
}
catch (Exception ex)
{
ret = ex.Message;
}
finally
{

saConnection.Dispose();

}
return ret;
}

**************************************


"Frank Ploessel" <fpl... Posted on 2007-08-27 19:22:48.0Z
Subject: Re: Connecting to a ver 5.5 sqlAnyWhere
From: "Frank Ploessel" <fpl...@d_e.i_m_s_h_e_a_l_t_h.c_o_m>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
References: <46d3126c.5613.1681692777@sybase.com>
Content-Transfer-Encoding: Quoted-Printable
Message-ID: <op.txqf36szj0bybf@bonw00164.internal.imsglobal.com>
User-Agent: Opera Mail/9.21 (Win32)
NNTP-Posting-Host: mail.taskarena-software-engineering.net
X-Original-NNTP-Posting-Host: mail.taskarena-software-engineering.net
Date: 27 Aug 2007 12:22:48 -0700
X-Trace: forums-1-dub 1188242568 217.76.101.130 (27 Aug 2007 12:22:48 -0700)
X-Original-Trace: 27 Aug 2007 12:22:48 -0700, mail.taskarena-software-engineering.net
Lines: 100
X-Authenticated-User: sa_beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6238
Article PK: 2645

Walter,

I would suggest to start the database in a service when you access it from
another service (like IIS).
Then, instead of using a database file name, you would use a server name
and database name.

However, are you saying you want to run the ASA 5.5 database file from an
ASA10 engine? This is not possible. For the first time since version 1,
the database engine of version 10 cannot use older database files. You
could either use an ASA9 or older database engine, or reload the database
file to an ASA10 database file.

Are there other applications accessing the database as well that need this
old version? Then the first approach would be needed, maybe it would be
best in this case to start the ASA 5.5 service in case you have a full 5.5
installation. Otherwise, I would suggest the second.

Frank

On Mon, 27 Aug 2007 20:05:32 +0200, Walter <Levine> wrote:

> I am developing with SQL AnyWhere ver 10 which I downloaded
> within the past 2 weeks. (windows)
> I have a web service that I need to deploy on a remote
> machine which appears to be using ver 5.5 build #1869
> The db file is on a networked drive. When I try to execute
> the code by browsing the asmx file, it just hangs on the
> Open(). It does not even timeout,(the timeout is at 150)
> I registered the dll in the GAC and do not get the dll error
> My code is below:
> I hope you can suggest a solution
> Thanks in advance for your help
> ***************************************
> using System;
> using System.Web;
> using System.Web.Services;
> using System.Web.Services.Protocols;
> using System.Data;
> using iAnywhere.Data.SQLAnywhere;
> using System.Data.SqlClient;
> using System.Xml;
>
> [WebService(Namespace = "http://tempuri.org/")]
> [WebServiceBinding(ConformsTo =
> WsiProfiles.BasicProfile1_1)]
> public class Service : System.Web.Services.WebService
> {
> public Service () {
> }
>
> [WebMethod]
>
> public DataSet sendPDS()
> {
> string ret = null;
> DataSet ds = new DataSet();
> iAnywhere.Data.SQLAnywhere.SAConnection
> saConnection;
> saConnection = new
> iAnywhere.Data.SQLAnywhere.SAConnection(@"UserID=dba;Password=sql;
> DatabaseFile=""d:\pdsdb\pds_apps.db""");
> try
> {
> saConnection.Open();
> ret = "OK";
> }
> catch (Exception ex)
> {
> ret = ex.Message;
> }
> finally
> {
>
> saConnection.Dispose();
>
> }
> return ret;
> }
>
> **************************************


Walter Levine Posted on 2007-08-27 19:50:29.0Z
Sender: 5f36.46c46d21.1804289383@sybase.com
From: Walter Levine
Newsgroups: ianywhere.public.general
Subject: Re: Connecting to a ver 5.5 sqlAnyWhere
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46d32b05.5864.1681692777@sybase.com>
References: <op.txqf36szj0bybf@bonw00164.internal.imsglobal.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Aug 2007 12:50:29 -0700
X-Trace: forums-1-dub 1188244229 10.22.241.41 (27 Aug 2007 12:50:29 -0700)
X-Original-Trace: 27 Aug 2007 12:50:29 -0700, 10.22.241.41
Lines: 94
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6242
Article PK: 4669

> Thanks for your reply.
I just want to execute an SQL against the database with no
impact on that machine. I do not want to run from the ver 10
engine.
There is a service running: <SQL Anywhere - Pds_apps>
Can you give me the syntax to access using the service name
instead of the filename, or point me to some documentation?
Thanks for your help


Walter,

>
> I would suggest to start the database in a service when
> you access it from another service (like IIS).
> Then, instead of using a database file name, you would use
> a server name and database name.
>
> However, are you saying you want to run the ASA 5.5
> database file from an ASA10 engine? This is not
> possible. For the first time since version 1, the
> database engine of version 10 cannot use older database
> files. You could either use an ASA9 or older database
> engine, or reload the database file to an ASA10 database
> file.
>
> Are there other applications accessing the database as
> well that need this old version? Then the first approach
> would be needed, maybe it would be best in this case to
> start the ASA 5.5 service in case you have a full 5..5
> installation. Otherwise, I would suggest the second.
>
> Frank
>
>
> On Mon, 27 Aug 2007 20:05:32 +0200, Walter <Levine> wrote:
>
> > I am developing with SQL AnyWhere ver 10 which I
> > downloaded within the past 2 weeks. (windows)
> > I have a web service that I need to deploy on a remote
> > machine which appears to be using ver 5.5 build #1869
> > The db file is on a networked drive. When I try to
> > execute the code by browsing the asmx file, it just
> > hangs on the Open(). It does not even timeout,(the
> > timeout is at 150) I registered the dll in the GAC and
> > do not get the dll error My code is below:
> > I hope you can suggest a solution
> > Thanks in advance for your help
> > ***************************************
> > using System;
> > using System.Web;
> > using System.Web.Services;
> > using System.Web.Services.Protocols;
> > using System.Data;
> > using iAnywhere.Data.SQLAnywhere;
> > using System.Data.SqlClient;
> > using System.Xml;
> >
> > [WebService(Namespace = "http://tempuri.org/")]
> > [WebServiceBinding(ConformsTo >
> > WsiProfiles.BasicProfile1_1)] public class Service :
> > System.Web.Services.WebService {
> > public Service () {
> > }
> >
> > [WebMethod]
> >
> > public DataSet sendPDS()
> > {
> > string ret = null;
> > DataSet ds = new DataSet();
> > iAnywhere.Data.SQLAnywhere.SAConnection
> > saConnection;
> > saConnection = new
> > iAnywhere.Data.SQLAnywhere.SAConnection(@"UserID=dba
> > ;Password=sql; DatabaseFile=""d:\pdsdb\pds_apps.db""");
> > try
> > {
> > saConnection.Open();
> > ret = "OK";
> > }
> > catch (Exception ex)
> > {
> > ret = ex.Message;
> > }
> > finally
> > {
> >
> > saConnection.Dispose();
> >
> > }
> > return ret;
> > }
> >
> > **************************************


"Frank Ploessel" <fpl... Posted on 2007-08-28 08:11:08.0Z
Subject: Re: Connecting to a ver 5.5 sqlAnyWhere
From: "Frank Ploessel" <fpl...@d_e.i_m_s_h_e_a_l_t_h.c_o_m>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
References: <op.txqf36szj0bybf@bonw00164.internal.imsglobal.com> <46d32b05.5864.1681692777@sybase.com>
Content-Transfer-Encoding: Quoted-Printable
Message-ID: <op.txrfosikj0bybf@bonw00164.internal.imsglobal.com>
User-Agent: Opera Mail/9.21 (Win32)
NNTP-Posting-Host: mail.taskarena-software-engineering.net
X-Original-NNTP-Posting-Host: mail.taskarena-software-engineering.net
Date: 28 Aug 2007 01:11:08 -0700
X-Trace: forums-1-dub 1188288668 217.76.101.130 (28 Aug 2007 01:11:08 -0700)
X-Original-Trace: 28 Aug 2007 01:11:08 -0700, mail.taskarena-software-engineering.net
Lines: 133
X-Authenticated-User: sa_beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6244
Article PK: 4671

Walter,

Is this a SQL Anywhere 5.5 service? I would assume the best way to connect
to the database would then be via ODBC, as about 10 years ago when SQL
Anywhere 5.5 came out, there was no such thing as .net or ADO.net. So, as
Chris wrote in his parallel message, you will not be able to connect to
this old database via ADO.net.

If there is a service running, I would assume there are other applications
accessing the database, probably via ODBC. Then I just would look on a
computer running one of tehse applications, trying to find an ODBC source
to see how to connect to the database. Set up an ODBC source similar to
the existing one on your computer running the web service, making sure it
is a system source, not a user source.
Normally, when connecting via ODBC, there is a conenction string like
'DSN=data_source_name;UID=dba;PWD=sql'
where data_source_name is the name of the ODBC source.

Frank

On Mon, 27 Aug 2007 21:50:29 +0200, Walter <Levine> wrote:

> > Thanks for your reply.
> I just want to execute an SQL against the database with no
> impact on that machine. I do not want to run from the ver 10
> engine.
> There is a service running: <SQL Anywhere - Pds_apps>
> Can you give me the syntax to access using the service name
> instead of the filename, or point me to some documentation?
> Thanks for your help
>
>
> Walter,
>>
>> I would suggest to start the database in a service when
>> you access it from another service (like IIS).
>> Then, instead of using a database file name, you would use
>> a server name and database name.
>>
>> However, are you saying you want to run the ASA 5.5
>> database file from an ASA10 engine? This is not
>> possible. For the first time since version 1, the
>> database engine of version 10 cannot use older database
>> files. You could either use an ASA9 or older database
>> engine, or reload the database file to an ASA10 database
>> file.
>>
>> Are there other applications accessing the database as
>> well that need this old version? Then the first approach
>> would be needed, maybe it would be best in this case to
>> start the ASA 5.5 service in case you have a full 5..5
>> installation. Otherwise, I would suggest the second.
>>
>> Frank
>>
>>
>> On Mon, 27 Aug 2007 20:05:32 +0200, Walter <Levine> wrote:
>>
>> > I am developing with SQL AnyWhere ver 10 which I
>> > downloaded within the past 2 weeks. (windows)
>> > I have a web service that I need to deploy on a remote
>> > machine which appears to be using ver 5.5 build #1869
>> > The db file is on a networked drive. When I try to
>> > execute the code by browsing the asmx file, it just
>> > hangs on the Open(). It does not even timeout,(the
>> > timeout is at 150) I registered the dll in the GAC and
>> > do not get the dll error My code is below:
>> > I hope you can suggest a solution
>> > Thanks in advance for your help
>> > ***************************************
>> > using System;
>> > using System.Web;
>> > using System.Web.Services;
>> > using System.Web.Services.Protocols;
>> > using System.Data;
>> > using iAnywhere.Data.SQLAnywhere;
>> > using System.Data.SqlClient;
>> > using System.Xml;
>> >
>> > [WebService(Namespace = "http://tempuri.org/")]
>> > [WebServiceBinding(ConformsTo >
>> > WsiProfiles.BasicProfile1_1)] public class Service :
>> > System.Web.Services.WebService {
>> > public Service () {
>> > }
>> >
>> > [WebMethod]
>> >
>> > public DataSet sendPDS()
>> > {
>> > string ret = null;
>> > DataSet ds = new DataSet();
>> > iAnywhere.Data.SQLAnywhere.SAConnection
>> > saConnection;
>> > saConnection = new
>> > iAnywhere.Data.SQLAnywhere.SAConnection(@"UserID=dba
>> > ;Password=sql; DatabaseFile=""d:\pdsdb\pds_apps.db""");
>> > try
>> > {
>> > saConnection.Open();
>> > ret = "OK";
>> > }
>> > catch (Exception ex)
>> > {
>> > ret = ex.Message;
>> > }
>> > finally
>> > {
>> >
>> > saConnection.Dispose();
>> >
>> > }
>> > return ret;
>> > }
>> >
>> > **************************************


Breck Carter [Team iAnywhere] Posted on 2007-08-28 11:03:57.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Connecting to a ver 5.5 sqlAnyWhere
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <l008d3pksde1kguqidjeavjdrpvtkctk7c@4ax.com>
References: <46d3126c.5613.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 28 Aug 2007 04:03:57 -0700
X-Trace: forums-1-dub 1188299037 64.7.134.118 (28 Aug 2007 04:03:57 -0700)
X-Original-Trace: 28 Aug 2007 04:03:57 -0700, bcarter.sentex.ca
Lines: 94
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6245
Article PK: 2647

If you have a V10 database running, it is possible to define "proxy"
tables inside that database which refer to real tables on a V5.5
database. The performance of proxy tables is not the *very* best, but
if the queries are reasonable and the number of rows returned are
reasonable and the network between the two servers (V10 and V5.5) is a
decent LAN then it should not be an issue. The beauty of proxy tables
is they can be used as if they were real V10 tables, except the data
comes from/goes to a remote database.

FWIW there was an issue with early builds of V10 which prevented V5.5
from being used in this manner. This has been fixed; I cannot remember
the exact build number, but V10.0.1.3504 works (that's 10.0.1 plus a
downloadable EBF to 3504).

The V10 Help topic is "SQL Anywhere® Server - SQL Usage - Accessing
Remote Data". Here is a simple demo showing a proxy table pointing at
the V5.5 demo database:

CREATE SERVER sademo CLASS 'ASAODBC' USING 'SQL Anywhere 5.0 Sample';
CREATE EXISTING TABLE sademo_product AT 'sademo;sademo;dba;product';
SELECT * FROM sademo_product;

Let us know if you need any more information.

Breck

On 27 Aug 2007 11:05:32 -0700, Walter Levine wrote:

>I am developing with SQL AnyWhere ver 10 which I downloaded
>within the past 2 weeks. (windows)
>I have a web service that I need to deploy on a remote
>machine which appears to be using ver 5.5 build #1869
>The db file is on a networked drive. When I try to execute
>the code by browsing the asmx file, it just hangs on the
>Open(). It does not even timeout,(the timeout is at 150)
>I registered the dll in the GAC and do not get the dll error
>My code is below:
>I hope you can suggest a solution
>Thanks in advance for your help
>***************************************
>using System;
>using System.Web;
>using System.Web.Services;
>using System.Web.Services.Protocols;
>using System.Data;
>using iAnywhere.Data.SQLAnywhere;
>using System.Data.SqlClient;
>using System.Xml;
>
>[WebService(Namespace = "http://tempuri.org/")]
>[WebServiceBinding(ConformsTo =
>WsiProfiles.BasicProfile1_1)]
>public class Service : System.Web.Services.WebService
>{
> public Service () {
> }
>
> [WebMethod]
>
> public DataSet sendPDS()
> {
> string ret = null;
> DataSet ds = new DataSet();
> iAnywhere.Data.SQLAnywhere.SAConnection
>saConnection;
> saConnection = new
>iAnywhere.Data.SQLAnywhere.SAConnection(@"UserID=dba;Password=sql;
>DatabaseFile=""d:\pdsdb\pds_apps.db""");
> try
> {
> saConnection.Open();
> ret = "OK";
> }
> catch (Exception ex)
> {
> ret = ex.Message;
> }
> finally
> {
>
> saConnection.Dispose();
>
> }
> return ret;
> }
>
>**************************************

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Wa;ter Levine Posted on 2007-08-28 12:19:29.0Z
Sender: 6bfa.46d40498.1804289383@sybase.com
From: Wa;ter Levine
Newsgroups: ianywhere.public.general
Subject: Re: Connecting to a ver 5.5 sqlAnyWhere
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46d412d1.6d82.1681692777@sybase.com>
References: <l008d3pksde1kguqidjeavjdrpvtkctk7c@4ax.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Aug 2007 05:19:29 -0700
X-Trace: forums-1-dub 1188303569 10.22.241.41 (28 Aug 2007 05:19:29 -0700)
X-Original-Trace: 28 Aug 2007 05:19:29 -0700, 10.22.241.41
Lines: 112
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6247
Article PK: 4672

It seems to me that if I were to go the "proxy" route, I
might as well just upgrade the machines to v10. Do you have
any idea about the apps that are running on the v5.5
machine? Would they run, or need to be upgraded? I
definitly don't want to install v10 in parallel with v5.5.
There are as many as 15 machines involved. How would you
suggest to return data via a Web Service? Are you available
for consultation on this issue?
Thanks again
Walter

> If you have a V10 database running, it is possible to
> define "proxy" tables inside that database which refer to
> real tables on a V5.5 database. The performance of proxy
> tables is not the *very* best, but if the queries are
> reasonable and the number of rows returned are reasonable
> and the network between the two servers (V10 and V5.5) is
> a decent LAN then it should not be an issue. The beauty of
> proxy tables is they can be used as if they were real V10
> tables, except the data comes from/goes to a remote
> database.
>
> FWIW there was an issue with early builds of V10 which
> prevented V5.5 from being used in this manner. This has
> been fixed; I cannot remember the exact build number, but
> V10.0.1.3504 works (that's 10.0.1 plus a downloadable EBF
> to 3504).
>
> The V10 Help topic is "SQL Anywhere® Server - SQL Usage
-
> Accessing Remote Data". Here is a simple demo showing a
> proxy table pointing at the V5.5 demo database:
>
> CREATE SERVER sademo CLASS 'ASAODBC' USING 'SQL Anywhere
> 5.0 Sample'; CREATE EXISTING TABLE sademo_product AT
> 'sademo;sademo;dba;product'; SELECT * FROM sademo_product;
>
> Let us know if you need any more information.
>
> Breck
>
> On 27 Aug 2007 11:05:32 -0700, Walter Levine wrote:
>
> >I am developing with SQL AnyWhere ver 10 which I
> downloaded >within the past 2 weeks. (windows)
> >I have a web service that I need to deploy on a remote
> >machine which appears to be using ver 5.5 build #1869
> >The db file is on a networked drive. When I try to
> execute >the code by browsing the asmx file, it just hangs
> on the >Open(). It does not even timeout,(the timeout is
> at 150) >I registered the dll in the GAC and do not get
> the dll error >My code is below:
> >I hope you can suggest a solution
> >Thanks in advance for your help
> >***************************************
> >using System;
> >using System.Web;
> >using System.Web.Services;
> >using System.Web.Services.Protocols;
> >using System.Data;
> >using iAnywhere.Data.SQLAnywhere;
> >using System.Data.SqlClient;
> >using System.Xml;
> >
> >[WebService(Namespace = "http://tempuri.org/")]
> >[WebServiceBinding(ConformsTo =
> >WsiProfiles.BasicProfile1_1)]
> >public class Service : System.Web.Services.WebService
> >{
> > public Service () {
> > }
> >
> > [WebMethod]
> >
> > public DataSet sendPDS()
> > {
> > string ret = null;
> > DataSet ds = new DataSet();
> > iAnywhere.Data.SQLAnywhere.SAConnection
> >saConnection;
> > saConnection = new
> >iAnywhere.Data.SQLAnywhere.SAConnection(@"UserID=dba
> ;Password=sql;
>DatabaseFile=""d:\pdsdb\pds_apps.db""");
> > try
> > {
> > saConnection.Open();
> > ret = "OK";
> > }
> > catch (Exception ex)
> > {
> > ret = ex.Message;
> > }
> > finally
> > {
> >
> > saConnection.Dispose();
> >
> > }
> > return ret;
> > }
> >
> >**************************************
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
>
http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com


Breck Carter [Team iAnywhere] Posted on 2007-08-28 15:21:15.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Connecting to a ver 5.5 sqlAnyWhere
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <sne8d3pgqjc5m4f6qcpgen7njop1cpj1qi@4ax.com>
References: <l008d3pksde1kguqidjeavjdrpvtkctk7c@4ax.com> <46d412d1.6d82.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 28 Aug 2007 08:21:15 -0700
X-Trace: forums-1-dub 1188314475 64.7.134.118 (28 Aug 2007 08:21:15 -0700)
X-Original-Trace: 28 Aug 2007 08:21:15 -0700, bcarter.sentex.ca
Lines: 152
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6250
Article PK: 4674


On 28 Aug 2007 05:19:29 -0700, Wa;ter Levine wrote:

>It seems to me that if I were to go the "proxy" route, I
>might as well just upgrade the machines to v10.

All the proxy stuff is on the V10 database, zero changes are required
on the V5.5 databases, machines or applications using the V5.5
databases. You could have one V10 database receiving data from ten
V5.5 databases via ten remote server connections. That's how the
Foxhound performance monitor works, FWIW.

>Do you have
>any idea about the apps that are running on the v5.5
>machine?

Me? No, I thought *you* did :)

>Would they run, or need to be upgraded?

Leaping from V5.5 to V10 crosses a millennium boundary... it could be
easy, could be hard, depending on what features are used etcetera.
There are a LOT of "Behavior Changes" sections for you to read... in
fact, not all of the old ones are contained in the V10 Help, but I can
point you to them.

>I
>definitly don't want to install v10 in parallel with v5.5.
>There are as many as 15 machines involved. How would you
>suggest to return data via a Web Service?

At this point, it would serve your interests best to describe what you
want to accomplish, from a primarily-business-point-of-view, as well
as what the current setup looks like.

>Are you available
>for consultation on this issue?

Of course... here (for free) or directly.

Breck

>Thanks again
>Walter
>
>> If you have a V10 database running, it is possible to
>> define "proxy" tables inside that database which refer to
>> real tables on a V5.5 database. The performance of proxy
>> tables is not the *very* best, but if the queries are
>> reasonable and the number of rows returned are reasonable
>> and the network between the two servers (V10 and V5.5) is
>> a decent LAN then it should not be an issue. The beauty of
>> proxy tables is they can be used as if they were real V10
>> tables, except the data comes from/goes to a remote
>> database.
>>
>> FWIW there was an issue with early builds of V10 which
>> prevented V5.5 from being used in this manner. This has
>> been fixed; I cannot remember the exact build number, but
>> V10.0.1.3504 works (that's 10.0.1 plus a downloadable EBF
>> to 3504).
>>
>> The V10 Help topic is "SQL Anywhere® Server - SQL Usage
>-
>> Accessing Remote Data". Here is a simple demo showing a
>> proxy table pointing at the V5.5 demo database:
>>
>> CREATE SERVER sademo CLASS 'ASAODBC' USING 'SQL Anywhere
>> 5.0 Sample'; CREATE EXISTING TABLE sademo_product AT
>> 'sademo;sademo;dba;product'; SELECT * FROM sademo_product;
>>
>> Let us know if you need any more information.
>>
>> Breck
>>
>> On 27 Aug 2007 11:05:32 -0700, Walter Levine wrote:
>>
>> >I am developing with SQL AnyWhere ver 10 which I
>> downloaded >within the past 2 weeks. (windows)
>> >I have a web service that I need to deploy on a remote
>> >machine which appears to be using ver 5.5 build #1869
>> >The db file is on a networked drive. When I try to
>> execute >the code by browsing the asmx file, it just hangs
>> on the >Open(). It does not even timeout,(the timeout is
>> at 150) >I registered the dll in the GAC and do not get
>> the dll error >My code is below:
>> >I hope you can suggest a solution
>> >Thanks in advance for your help
>> >***************************************
>> >using System;
>> >using System.Web;
>> >using System.Web.Services;
>> >using System.Web.Services.Protocols;
>> >using System.Data;
>> >using iAnywhere.Data.SQLAnywhere;
>> >using System.Data.SqlClient;
>> >using System.Xml;
>> >
>> >[WebService(Namespace = "http://tempuri.org/")]
>> >[WebServiceBinding(ConformsTo =
>> >WsiProfiles.BasicProfile1_1)]
>> >public class Service : System.Web.Services.WebService
>> >{
>> > public Service () {
>> > }
>> >
>> > [WebMethod]
>> >
>> > public DataSet sendPDS()
>> > {
>> > string ret = null;
>> > DataSet ds = new DataSet();
>> > iAnywhere.Data.SQLAnywhere.SAConnection
>> >saConnection;
>> > saConnection = new
>> >iAnywhere.Data.SQLAnywhere.SAConnection(@"UserID=dba
>> ;Password=sql;
>>DatabaseFile=""d:\pdsdb\pds_apps.db""");
>> > try
>> > {
>> > saConnection.Open();
>> > ret = "OK";
>> > }
>> > catch (Exception ex)
>> > {
>> > ret = ex.Message;
>> > }
>> > finally
>> > {
>> >
>> > saConnection.Dispose();
>> >
>> > }
>> > return ret;
>> > }
>> >
>> >**************************************
>>
>> --
>> Breck Carter [Team iAnywhere]
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com
>> The book:
>>
>http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>> breck.carter@risingroad.com

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Chris Keating (Sybase iAnywhere) Posted on 2007-08-27 20:50:38.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Connecting to a ver 5.5 sqlAnyWhere
References: <46d3126c.5613.1681692777@sybase.com>
In-Reply-To: <46d3126c.5613.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-d620.sybase.com
X-Original-NNTP-Posting-Host: keating-d620.sybase.com
Message-ID: <46d3391e$1@forums-1-dub>
Date: 27 Aug 2007 13:50:38 -0700
X-Trace: forums-1-dub 1188247838 10.25.99.252 (27 Aug 2007 13:50:38 -0700)
X-Original-Trace: 27 Aug 2007 13:50:38 -0700, keating-d620.sybase.com
Lines: 70
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6243
Article PK: 4670

SA 5 databases do not have the gear (system procedures) required to
support a connection using the SAConnecton object. Also, your current
setup attempts to start the database file on a SA10 engine, which is not
possible.

If you need to connect to an existing SA5 environment (and cannot
upgrade the database file), you will need to use ODBC to connect.

Walter Levine wrote:
> I am developing with SQL AnyWhere ver 10 which I downloaded
> within the past 2 weeks. (windows)
> I have a web service that I need to deploy on a remote
> machine which appears to be using ver 5.5 build #1869
> The db file is on a networked drive. When I try to execute
> the code by browsing the asmx file, it just hangs on the
> Open(). It does not even timeout,(the timeout is at 150)
> I registered the dll in the GAC and do not get the dll error
> My code is below:
> I hope you can suggest a solution
> Thanks in advance for your help
> ***************************************
> using System;
> using System.Web;
> using System.Web.Services;
> using System.Web.Services.Protocols;
> using System.Data;
> using iAnywhere.Data.SQLAnywhere;
> using System.Data.SqlClient;
> using System.Xml;
>
> [WebService(Namespace = "http://tempuri.org/")]
> [WebServiceBinding(ConformsTo =
> WsiProfiles.BasicProfile1_1)]
> public class Service : System.Web.Services.WebService
> {
> public Service () {
> }
>
> [WebMethod]
>
> public DataSet sendPDS()
> {
> string ret = null;
> DataSet ds = new DataSet();
> iAnywhere.Data.SQLAnywhere.SAConnection
> saConnection;
> saConnection = new
> iAnywhere.Data.SQLAnywhere.SAConnection(@"UserID=dba;Password=sql;
> DatabaseFile=""d:\pdsdb\pds_apps.db""");
> try
> {
> saConnection.Open();
> ret = "OK";
> }
> catch (Exception ex)
> {
> ret = ex.Message;
> }
> finally
> {
>
> saConnection.Dispose();
>
> }
> return ret;
> }
>
> **************************************