SQL Anywhere database - Web application and ASA database?

Author

Web application and ASA database?

mct79c

2005-12-13, 8:24 pm

Hi,

I am developing a web application that will have a Sybase ASA version9
database.
For now, I want to have the database on the same server as the application
server.

What products do I need to buy and install on the server?

And if I was running the web application locally with a local ASA database,
is just having the ASA ODBC driver enough?

Thanks!
J

Chris Keating(iAnywhere Solutions)

2005-12-13, 8:24 pm

Your question would be best answered by a member of the iAnywhere
Solutions sales force For product or sales inquiries you can contact
iAnywhere Solutions by calling 1-800-801-2069 within North America.
Alternatively, you can contact us by email at contact.us@ianywhere.com

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

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

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

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

Greg Fenton

2005-12-13, 8:24 pm

mct79c wrote:
> I am developing a web application that will have a Sybase ASA version9
> database.
> For now, I want to have the database on the same server as the application
> server.
>
> What products do I need to buy and install on the server?

Arguably, you have everything you need for developing web applications
if you have SQLAnywhere 9.x

SQLAnywhere 9.0 introduced "web services", which means that SQLAnywhere
is able to service HTTP requests directly. One of our engineers has
built an entire "home web server" (blog, photo gallery, calendar,
etc...) using web services.

However, to answer your question more completely, the question we need
to throw back to you is "what do you want to code in?"

If SQL, then read up in the SQLAnywhere 9.x docs about "web services".

If Java, PHP, Perl, or Ruby, then you likely need an appropriate
language engine such as Tomcat or JBoss (for java), apache with mod_php
or mod_perl, Ruby On Rails, etc... Each of these will connect to
SQLAnywhere using one of the client libraries (DBD::ASAny, the
sqlanywhere PHP module, jODBC, jConnect, or ODBC).

Then there's that whole ".NET" thingy I've heard something about.

So, when you say "application server", what do you mean?

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

Jeff Gibson

2005-12-14, 3:23 am

Greg,

Any chance you can give us a link to this example? I would love to check
out a site that is being entirely served up via a SQL Anywhere Database and
not doing it within a Power Dynamo environment. Especially one that is
doing it via the Web Services infrastructure.

If you can't post it to the group, any chance you can send it to me via
personal e-mail?

Thanks Greg.

Jeff Gibson
Intercept Solutions
Nashville, TN

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:439f7e2c$1@foru
ms-1-dub...
> mct79c wrote:
application[color=da
rkred]
>
> Arguably, you have everything you need for developing web applications
> if you have SQLAnywhere 9.x
>
> SQLAnywhere 9.0 introduced "web services", which means that SQLAnywhere
> is able to service HTTP requests directly. One of our engineers has
> built an entire "home web server" (blog, photo gallery, calendar,
> etc...) using web services.
>
> However, to answer your question more completely, the question we need
> to throw back to you is "what do you want to code in?"
>
> If SQL, then read up in the SQLAnywhere 9.x docs about "web services".
>
> If Java, PHP, Perl, or Ruby, then you likely need an appropriate
> language engine such as Tomcat or JBoss (for java), apache with mod_php
> or mod_perl, Ruby On Rails, etc... Each of these will connect to
> SQLAnywhere using one of the client libraries (DBD::ASAny, the
> sqlanywhere PHP module, jODBC, jConnect, or ODBC).
>
> Then there's that whole ".NET" thingy I've heard something about.
>
> So, when you say "application server", what do you mean?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Breck Carter [TeamSybase]

2005-12-14, 9:23 am

FWIW the Foxhound utility is entirely encapsulated inside an ASA
database: http://www.risingroad.com/foxhound_beta_3.html

Breck

On 13 Dec 2005 22:48:22 -0800, "Jeff Gibson"
< jgibson@interceptsol
utions.com> wrote:

>Greg,
>
>Any chance you can give us a link to this example? I would love to check
>out a site that is being entirely served up via a SQL Anywhere Database and
>not doing it within a Power Dynamo environment. Especially one that is
>doing it via the Web Services infrastructure.
>
>If you can't post it to the group, any chance you can send it to me via
>personal e-mail?
>
>Thanks Greg.
>
>Jeff Gibson
>Intercept Solutions
>Nashville, TN
>
>"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
> news:439f7e2c$1@foru
ms-1-dub...
>application
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Pavel Karady

2005-12-15, 9:23 am

> FWIW the Foxhound utility is entirely encapsulated inside an ASA
> database: http://www.risingroad.com/foxhound_beta_3.html

Maybe that's why the download on the bottom page does not work :))
I'm kidding, I think of ASA as of my father.

Pavel

handheldmaster

2005-12-21, 9:23 am

Even I tried downloading but could not get the FoxHound download page . I
would say its the port :123456 thats causing us to not allow to download
behind a firewall.

"Pavel Karady" <pavel_ns. ns_karady@ns_kogerus
a.com> wrote in message
news:43a1876e$1@foru
ms-1-dub...
>
> Maybe that's why the download on the bottom page does not work :))
> I'm kidding, I think of ASA as of my father.
>
> Pavel
>

Breck Carter [TeamSybase]

2005-12-21, 9:23 am

I can send you the file via email if you want. Send *me* an email at
breck dot carter at gmail dot com

Breck

On 21 Dec 2005 05:56:28 -0800, "handheldmaster" <abc@456.com> wrote:

>Even I tried downloading but could not get the FoxHound download page . I
>would say its the port :123456 thats causing us to not allow to download
>behind a firewall.
>
>"Pavel Karady" <pavel_ns. ns_karady@ns_kogerus
a.com> wrote in message
> news:43a1876e$1@foru
ms-1-dub...
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Pavel Karady

2005-12-21, 11:23 am

"handheldmaster" <abc@456.com> wrote in message
news:43a95cb5$1@foru
ms-2-dub...
> I would say its the port :123456 thats causing us to not allow to download
> behind a firewall.

And even stranger as I've noticed, the port number is 12346 with number 5
missing, but apparently, adding the "missing" number didn't help :)

Pavel

Dmitri

2005-12-21, 11:23 am

Pavel Karady wrote:

> And even stranger as I've noticed, the port number is 12346 with number 5
> missing, but apparently, adding the "missing" number didn't help :)

It couldn't - port number is a 2-byte unsigned integer, that is, 65535
max :).

Dmitri.

Breck Carter [TeamSybase]

2005-12-21, 11:23 am

On 21 Dec 2005 08:10:50 -0800, "Pavel Karady"
<pavel_ns. ns_karady@ns_kogerus
a.com> wrote:

>the port number is 12346

That's the right port number. If you can't get to it, I will send you
the file by email.

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Greg Fenton

2005-12-23, 11:23 am

Breck Carter [TeamSybase] wrote:
> On 21 Dec 2005 08:10:50 -0800, "Pavel Karady"
> <pavel_ns. ns_karady@ns_kogerus
a.com> wrote:
>
>
> That's the right port number. If you can't get to it, I will send you
> the file by email.
>

Just an FYI, I am able to get to the download without issue. Since the
registration form lives on a non-standard port, there is the chance that
you are being blocked by a corporate (or ISP) networking/firewall
restriction.

Breck, if you want to get this working, I can send you the Apache
configuration commands to reverse-proxy the registration and download
service on port 80. Of course, this means you'll need to upgrade your
webserver from that "other" thing :-)

Alternatively, maybe:

http://www.google.com/search? q=iis...br /> 0proxy%22

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

Breck Carter [TeamSybase]

2005-12-23, 8:23 pm

It is an ASA webservice running on the same box as IIS, hence the use
of 12346 instead of 80. I am probably going to change to another port
since 12346 is also used by a trojan. In the meantime, anyone can get
the file by sending me an email request.

Breck

On 23 Dec 2005 09:07:21 -0800, Greg Fenton
<greg. fenton_NOSPAM_@ianyw
here.com> wrote:

>Breck Carter [TeamSybase] wrote:
>
>Just an FYI, I am able to get to the download without issue. Since the
>registration form lives on a non-standard port, there is the chance that
>you are being blocked by a corporate (or ISP) networking/firewall
>restriction.
>
>Breck, if you want to get this working, I can send you the Apache
>configuration commands to reverse-proxy the registration and download
>service on port 80. Of course, this means you'll need to upgrade your
>webserver from that "other" thing :-)
>
>Alternatively, maybe:
>
> http://www.google.com/search? q=iis...br /> 0proxy%22
>
>Hope this helps,
>greg.fenton

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Pavel Karady

2005-12-27, 7:23 am

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote

> Just an FYI, I am able to get to the download without issue. Since the
> registration form lives on a non-standard port, there is the chance that
> you are being blocked by a corporate (or ISP) networking/firewall
> restriction.

I've talked to our net-tech, it's exactly like that.

Even after downloading FoxHound, it works using the port 12347; and that
didn't show in my browser correctly. After setting bypassing the proxy for
localhost, FoxHound's work is flawless.

Thanks for lighting me up :)

Pavel

>
> Breck, if you want to get this working, I can send you the Apache
> configuration commands to reverse-proxy the registration and download
> service on port 80. Of course, this means you'll need to upgrade your
> webserver from that "other" thing :-)
>
> Alternatively, maybe:
>
> http://www.google.com/search? q=iis...br /> 0proxy%22
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Sponsored Links