How do I use web forms with ASE? 
Author Message
 How do I use web forms with ASE?

Hi

Could you help me with the following questions?

1. What is he difference between Sybase adaptive server enterprise and
Sybase SQL server?

2. Im constructing a web site and using a form I want to search a
database on a Sybase adaptive server. Is this possible?
For example, with MySQL I can connect to it and query the database with
Perl/CGI and PHP on the client side with embedded SQL statements. Is
any of this possible with Sybase?

Is it true that for a client to communicate with a Sybase server the
client must have open client?
Since clients on the web are unlikely to have open client, is there a
solution?

Basically, I will like to know how to communicate between a web client
and a Sybase adaptive server enterprise?

Thank you

Sent via Deja.com http://www.***.com/
Before you buy.



Fri, 25 Apr 2003 03:00:00 GMT
 How do I use web forms with ASE?

Quote:

> Hi

> Could you help me with the following questions?

> 1. What is he difference between Sybase adaptive server enterprise and
> Sybase SQL server?

Version number (and associated features, naturally).  11.0.3 was the last
version
Sybase marketing used the name "SQL Server" for, the name was then changed
to "Adaptive Server Enterprise".  Same product, just different name.  Many
people
(including myself, sometimes) still refer to ASE as "SQL Server".

Quote:

> 2. Im constructing a web site and using a form I want to search a
> database on a Sybase adaptive server. Is this possible?
> For example, with MySQL I can connect to it and query the database with
> Perl/CGI and PHP on the client side with embedded SQL statements. Is
> any of this possible with Sybase?

Yes, it is certainly possible.  You might want to check out the book
"Building Sybase Web Sites" by James J Hobus, Prentice Hall, ISBN
0-13-798357-3.

You should also check out the SybPerl interface described at
http://www.mbay.net/~mpeppler/

Quote:

> Is it true that for a client to communicate with a Sybase server the
> client must have open client?
> Since clients on the web are unlikely to have open client, is there a
> solution?

In this case, your web server application would be the "client" to the
ASE Server.  The "open client" involved could be an isql session,
an ODBC driver, a custom-progamed ct-library client, etc.

-bret



Fri, 25 Apr 2003 03:00:00 GMT
 How do I use web forms with ASE?

Lisa,

I can answer your questions generally: Adaptive Server Enterprise (ASE)
is what Sybase is now calling what used to be called Sybase SQL Server.
Originally, Sybase and Microsoft developed SQL Server collaboratively,
but then split up.  Microsoft now markets its DBMS as Sql Server, and
Sybase markets its DBMS as ASE.  Their code base has diverged over the
past few releases, but is still remarkably similar in many respects.

You can use CGI with Perl or C to connect a web page to a Sybase
database, the same as with MS Sql Server.  In ASE version 12, you can
write stored procedures in Java as well as Transact-SQL.  We use Sybase
on a Unix platform, so I don't really know anything about Sybase on an
NT platform.  It may be that, on an NT platform, you could use Active
Server Pages; somebody else in this forum will have to speak to this.

Hope this helps,

                              Larry Burns


Quote:

> Hi

> Could you help me with the following questions?

> 1. What is he difference between Sybase adaptive server enterprise and
> Sybase SQL server?

> 2. Im constructing a web site and using a form I want to search a
> database on a Sybase adaptive server. Is this possible?
> For example, with MySQL I can connect to it and query the database
with
> Perl/CGI and PHP on the client side with embedded SQL statements. Is
> any of this possible with Sybase?

> Is it true that for a client to communicate with a Sybase server the
> client must have open client?
> Since clients on the web are unlikely to have open client, is there a
> solution?

> Basically, I will like to know how to communicate between a web client
> and a Sybase adaptive server enterprise?

> Thank you

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Sent via Deja.com http://www.deja.com/
Before you buy.


Fri, 25 Apr 2003 03:00:00 GMT
 How do I use web forms with ASE?
Ok, so I could have a C/CGI script in an apache web server that
communicates with the open client, which in turn accesses ASE. Is this
right?
Could you possibly elaborate with an example?

Thanks
Lisa



Quote:


> > Hi

> > Could you help me with the following questions?

> > 1. What is he difference between Sybase adaptive server enterprise
and
> > Sybase SQL server?

> Version number (and associated features, naturally).  11.0.3 was the
last
> version
> Sybase marketing used the name "SQL Server" for, the name was then
changed
> to "Adaptive Server Enterprise".  Same product, just different name.
Many
> people
> (including myself, sometimes) still refer to ASE as "SQL Server".

> > 2. Im constructing a web site and using a form I want to search a
> > database on a Sybase adaptive server. Is this possible?
> > For example, with MySQL I can connect to it and query the database
with
> > Perl/CGI and PHP on the client side with embedded SQL statements. Is
> > any of this possible with Sybase?

> Yes, it is certainly possible.  You might want to check out the book
> "Building Sybase Web Sites" by James J Hobus, Prentice Hall, ISBN
> 0-13-798357-3.

> You should also check out the SybPerl interface described at
> http://www.mbay.net/~mpeppler/

> > Is it true that for a client to communicate with a Sybase server the
> > client must have open client?
> > Since clients on the web are unlikely to have open client, is there
a
> > solution?

> In this case, your web server application would be the "client" to the
> ASE Server.  The "open client" involved could be an isql session,
> an ODBC driver, a custom-progamed ct-library client, etc.

> -bret

Sent via Deja.com http://www.deja.com/
Before you buy.


Sat, 26 Apr 2003 09:31:55 GMT
 How do I use web forms with ASE?

Quote:

> Ok, so I could have a C/CGI script in an apache web server that
> communicates with the open client, which in turn accesses ASE. Is this
> right?
> Could you possibly elaborate with an example?

A C example would be a little verbose.

Here's a perl example. Assumes you have installed sybperl (and of course
OpenClient) on the web server.

#!/usr/local/bin/perl -w

use strict;

use CGI;
use Sybase::CTlib;

my $q = new CGI;
my $dbh = new Sybase::CTlib 'user', 'password', 'sybase-server';
my $restype;

print $q->header;
print $q->start_html('Just a little test');
$dbh->ct_execute("select * from sysusers");

while($dbh->ct_results($restype) == CS_SUCCEED) {
    next unless $dbh->ct_fetchable($restype);
    print "<h1>Listing sysusers...</h1>\n";
    print "<table>\n";

    print "<tr>\n";


        print "<th>$_</th>";
    }
    print "</tr>\n";

        print "<tr>";

            print "<td>$_</td>\n";
        }
        print "</tr>";
    }
    print "</table>\n";

Quote:
}

print $q->end_html;

__END__

Quote:

> Thanks
> Lisa




> > > Hi

> > > Could you help me with the following questions?

> > > 1. What is he difference between Sybase adaptive server enterprise
> and
> > > Sybase SQL server?

> > Version number (and associated features, naturally).  11.0.3 was the
> last
> > version
> > Sybase marketing used the name "SQL Server" for, the name was then
> changed
> > to "Adaptive Server Enterprise".  Same product, just different name.
> Many
> > people
> > (including myself, sometimes) still refer to ASE as "SQL Server".

> > > 2. I?m constructing a web site and using a form I want to search a
> > > database on a Sybase adaptive server. Is this possible?
> > > For example, with MySQL I can connect to it and query the database
> with
> > > Perl/CGI and PHP on the client side with embedded SQL statements. Is
> > > any of this possible with Sybase?

> > Yes, it is certainly possible.  You might want to check out the book
> > "Building Sybase Web Sites" by James J Hobus, Prentice Hall, ISBN
> > 0-13-798357-3.

> > You should also check out the SybPerl interface described at
> > http://www.mbay.net/~mpeppler/

> > > Is it true that for a client to communicate with a Sybase server the
> > > client must have open client?
> > > Since clients on the web are unlikely to have open client, is there
> a
> > > solution?

> > In this case, your web server application would be the "client" to the
> > ASE Server.  The "open client" involved could be an isql session,
> > an ODBC driver, a custom-progamed ct-library client, etc.

> > -bret

> Sent via Deja.com http://www.deja.com/
> Before you buy.

--


International Sybase User Group - http://www.isug.com



Sat, 26 Apr 2003 03:00:00 GMT
 How do I use web forms with ASE?
Thank you very much.
Do you know where I can get a copy of Open client?
Lisa.



Quote:

> > Ok, so I could have a C/CGI script in an apache web server that
> > communicates with the open client, which in turn accesses ASE. Is
this
> > right?
> > Could you possibly elaborate with an example?

> A C example would be a little verbose.

> Here's a perl example. Assumes you have installed sybperl (and of
course
> OpenClient) on the web server.

> #!/usr/local/bin/perl -w

> use strict;

> use CGI;
> use Sybase::CTlib;

> my $q = new CGI;
> my $dbh = new Sybase::CTlib 'user', 'password', 'sybase-server';
> my $restype;

> print $q->header;
> print $q->start_html('Just a little test');
> $dbh->ct_execute("select * from sysusers");

> while($dbh->ct_results($restype) == CS_SUCCEED) {
>     next unless $dbh->ct_fetchable($restype);
>     print "<h1>Listing sysusers...</h1>\n";
>     print "<table>\n";

>     print "<tr>\n";


>         print "<th>$_</th>";
>     }
>     print "</tr>\n";

>         print "<tr>";

>             print "<td>$_</td>\n";
>         }
>         print "</tr>";
>     }
>     print "</table>\n";
> }

> print $q->end_html;

> __END__

> > Thanks
> > Lisa




> > > > Hi

> > > > Could you help me with the following questions?

> > > > 1. What is he difference between Sybase adaptive server
enterprise
> > and
> > > > Sybase SQL server?

> > > Version number (and associated features, naturally).  11.0.3 was
the
> > last
> > > version
> > > Sybase marketing used the name "SQL Server" for, the name was then
> > changed
> > > to "Adaptive Server Enterprise".  Same product, just different
name.
> > Many
> > > people
> > > (including myself, sometimes) still refer to ASE as "SQL Server".

> > > > 2. I?m constructing a web site and using a form I want to
search a
> > > > database on a Sybase adaptive server. Is this possible?
> > > > For example, with MySQL I can connect to it and query the
database
> > with
> > > > Perl/CGI and PHP on the client side with embedded SQL
statements. Is
> > > > any of this possible with Sybase?

> > > Yes, it is certainly possible.  You might want to check out the
book
> > > "Building Sybase Web Sites" by James J Hobus, Prentice Hall, ISBN
> > > 0-13-798357-3.

> > > You should also check out the SybPerl interface described at
> > > http://www.mbay.net/~mpeppler/

> > > > Is it true that for a client to communicate with a Sybase
server the
> > > > client must have open client?
> > > > Since clients on the web are unlikely to have open client, is
there
> > a
> > > > solution?

> > > In this case, your web server application would be the "client"
to the
> > > ASE Server.  The "open client" involved could be an isql session,
> > > an ODBC driver, a custom-progamed ct-library client, etc.

> > > -bret

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

> --


> International Sybase User Group - http://www.isug.com


Sent via Deja.com http://www.deja.com/
Before you buy.


Sun, 27 Apr 2003 08:08:02 GMT
 How do I use web forms with ASE?
Thank you very much.
Do you know where I can get a copy of Open client?

Lisa.



Quote:

> > Ok, so I could have a C/CGI script in an apache web server that
> > communicates with the open client, which in turn accesses ASE. Is
this
> > right?
> > Could you possibly elaborate with an example?

> A C example would be a little verbose.

> Here's a perl example. Assumes you have installed sybperl (and of
course
> OpenClient) on the web server.

> #!/usr/local/bin/perl -w

> use strict;

> use CGI;
> use Sybase::CTlib;

> my $q = new CGI;
> my $dbh = new Sybase::CTlib 'user', 'password', 'sybase-server';
> my $restype;

> print $q->header;
> print $q->start_html('Just a little test');
> $dbh->ct_execute("select * from sysusers");

> while($dbh->ct_results($restype) == CS_SUCCEED) {
>     next unless $dbh->ct_fetchable($restype);
>     print "<h1>Listing sysusers...</h1>\n";
>     print "<table>\n";

>     print "<tr>\n";


>         print "<th>$_</th>";
>     }
>     print "</tr>\n";

>         print "<tr>";

>             print "<td>$_</td>\n";
>         }
>         print "</tr>";
>     }
>     print "</table>\n";
> }

> print $q->end_html;

> __END__

> > Thanks
> > Lisa




> > > > Hi

> > > > Could you help me with the following questions?

> > > > 1. What is he difference between Sybase adaptive server
enterprise
> > and
> > > > Sybase SQL server?

> > > Version number (and associated features, naturally).  11.0.3 was
the
> > last
> > > version
> > > Sybase marketing used the name "SQL Server" for, the name was then
> > changed
> > > to "Adaptive Server Enterprise".  Same product, just different
name.
> > Many
> > > people
> > > (including myself, sometimes) still refer to ASE as "SQL Server".

> > > > 2. I?m constructing a web site and using a form I want to
search a
> > > > database on a Sybase adaptive server. Is this possible?
> > > > For example, with MySQL I can connect to it and query the
database
> > with
> > > > Perl/CGI and PHP on the client side with embedded SQL
statements. Is
> > > > any of this possible with Sybase?

> > > Yes, it is certainly possible.  You might want to check out the
book
> > > "Building Sybase Web Sites" by James J Hobus, Prentice Hall, ISBN
> > > 0-13-798357-3.

> > > You should also check out the SybPerl interface described at
> > > http://www.mbay.net/~mpeppler/

> > > > Is it true that for a client to communicate with a Sybase
server the
> > > > client must have open client?
> > > > Since clients on the web are unlikely to have open client, is
there
> > a
> > > > solution?

> > > In this case, your web server application would be the "client"
to the
> > > ASE Server.  The "open client" involved could be an isql session,
> > > an ODBC driver, a custom-progamed ct-library client, etc.

> > > -bret

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

> --


> International Sybase User Group - http://www.isug.com


Sent via Deja.com http://www.deja.com/
Before you buy.


Sun, 27 Apr 2003 08:06:58 GMT
 How do I use web forms with ASE?

Quote:

> Thank you very much.
> Do you know where I can get a copy of Open client?

Talk to Sybase.
Or if your client is linux, go to http://linux.sybase.com where you can
download it for free.

Michael

Quote:



> > > Ok, so I could have a C/CGI script in an apache web server that
> > > communicates with the open client, which in turn accesses ASE. Is
> this
> > > right?
> > > Could you possibly elaborate with an example?

> > A C example would be a little verbose.

> > Here's a perl example. Assumes you have installed sybperl (and of
> course
> > OpenClient) on the web server.

> > #!/usr/local/bin/perl -w

> > use strict;

> > use CGI;
> > use Sybase::CTlib;

> > my $q = new CGI;
> > my $dbh = new Sybase::CTlib 'user', 'password', 'sybase-server';
> > my $restype;

> > print $q->header;
> > print $q->start_html('Just a little test');
> > $dbh->ct_execute("select * from sysusers");

> > while($dbh->ct_results($restype) == CS_SUCCEED) {
> >     next unless $dbh->ct_fetchable($restype);
> >     print "<h1>Listing sysusers...</h1>\n";
> >     print "<table>\n";

> >     print "<tr>\n";


> >         print "<th>$_</th>";
> >     }
> >     print "</tr>\n";

> >         print "<tr>";

> >             print "<td>$_</td>\n";
> >         }
> >         print "</tr>";
> >     }
> >     print "</table>\n";
> > }

> > print $q->end_html;

> > __END__

> > > Thanks
> > > Lisa




> > > > > Hi

> > > > > Could you help me with the following questions?

> > > > > 1. What is he difference between Sybase adaptive server
> enterprise
> > > and
> > > > > Sybase SQL server?

> > > > Version number (and associated features, naturally).  11.0.3 was
> the
> > > last
> > > > version
> > > > Sybase marketing used the name "SQL Server" for, the name was then
> > > changed
> > > > to "Adaptive Server Enterprise".  Same product, just different
> name.
> > > Many
> > > > people
> > > > (including myself, sometimes) still refer to ASE as "SQL Server".

> > > > > 2. I?m constructing a web site and using a form I want to
> search a
> > > > > database on a Sybase adaptive server. Is this possible?
> > > > > For example, with MySQL I can connect to it and query the
> database
> > > with
> > > > > Perl/CGI and PHP on the client side with embedded SQL
> statements. Is
> > > > > any of this possible with Sybase?

> > > > Yes, it is certainly possible.  You might want to check out the
> book
> > > > "Building Sybase Web Sites" by James J Hobus, Prentice Hall, ISBN
> > > > 0-13-798357-3.

> > > > You should also check out the SybPerl interface described at
> > > > http://www.mbay.net/~mpeppler/

> > > > > Is it true that for a client to communicate with a Sybase
> server the
> > > > > client must have open client?
> > > > > Since clients on the web are unlikely to have open client, is
> there
> > > a
> > > > > solution?

> > > > In this case, your web server application would be the "client"
> to the
> > > > ASE Server.  The "open client" involved could be an isql session,
> > > > an ODBC driver, a custom-progamed ct-library client, etc.

> > > > -bret

> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.

> > --


> > International Sybase User Group - http://www.isug.com

> Sent via Deja.com http://www.deja.com/
> Before you buy.

--


International Sybase User Group - http://www.isug.com



Sun, 27 Apr 2003 03:00:00 GMT
 How do I use web forms with ASE?

Quote:

> 2. Im constructing a web site and using a form I want to search a
> database on a Sybase adaptive server. Is this possible?
> For example, with MySQL I can connect to it and query the database with
> Perl/CGI and PHP on the client side with embedded SQL statements. Is
> any of this possible with Sybase?

It certainly is.
Our forms (http://www.mandoforms.com) replace traditional HTML forms and
are used with great success on sites such as
http://www.privatecapitalexchange.com to access a Sybase database via JRun
based JSP's

--
Michael Pickard,
Developer, NettGain Solutions Ltd.
Williams House, Manchester Science Park, Manchester, M15 6SE, United
Kingdom.
www.mandoforms.com

DISCLAIMER: This e-mail contains proprietary information some or all of
which may be legally privileged.  It is for the intended recipient only.If
an addressing or transmission error has misdirected this e-mail, please
notify the author by replying to this e-mail.  If you are not the intended
recipient you must not use, disclose, distribute, copy, print, or rely on
this e-mail.



Fri, 09 May 2003 03:00:00 GMT
 
 [ 9 post ] 

 Relevant Pages 

1. Anyone done Open Client programming on SUN (ASE 11.5) -- basic question

2. Record Locking using web forms ?

3. Icon path using web forms

4. Forms processing using Web Toolkit and/or ASPs.

5. Q: Auto-skip feature using Dev2000 forms on web not working

6. Deploying Forms on the Web using Developer 2000

7. Error when connecting to server using web form

8. Record Locking using web forms ?

9. Creting new records in an FMDB using web custom form

10. Form Text Limitation Using Web Companion

11. adding multiple rows in portal, using web form?


 
Powered by phpBB® Forum Software