Board index » Visual Basic&database

All times are UTC



 access SQL database through netscape browser in NT 
Author Message
dud
#1 / 8
 access SQL database through netscape browser in NT

        Hi, how to write a CGI program to access SQL database in NT ?

        netscape ->  WWW   ->   CGI   ->   ODBC    ->   SQL
        browser  <- server <- program <- inferface <- database
                    in NT

        I have succeeded with writen a C program to access SQL database
        in NT. But when I port it to a CGI program, it become fail to
        connect SQL database!! How should I do for this?

        Another thing, is there any package or shareware which can do
        the same thing as I say above? I know one of them is COLD FUSION,
        and it return the result of query to the netscape browser directly.
        But I want to deal with the result of query , and then sent them
        to netscape browser.

        Any response is welcome !! Thanks a lot!!




Sun, 05 Apr 1998 03:00:00 GMT  
Brian C. Jeps
#2 / 8
 access SQL database through netscape browser in NT


Quote:
>        Hi, how to write a CGI program to access SQL database in NT ?

>        netscape ->  WWW   ->   CGI   ->   ODBC    ->   SQL
>        browser  <- server <- program <- inferface <- database
>                    in NT

Check out a freeware package that I've assembled. It is Windows NT based, and
requires the following:

Perl 5 (there are links to this in the README.HTM)
EMWAC's http server version .097 or above (there are links to this in the
README.HTM)
Lee Fe{*filter*}an's IODBC (this is included)
Windows NT (possibly will work on 95)

It's located on:
ftp://ftp.digex.net/pub/access/psii/iodbc.zip

Hope this helps,


Director of Advanced Technology, Prosoft Systems International, Inc.



Sun, 05 Apr 1998 03:00:00 GMT  
Towers Perr
#3 / 8
 access SQL database through netscape browser in NT

Quote:

>        Hi, how to write a CGI program to access SQL database in NT ?

>        netscape ->  WWW   ->   CGI   ->   ODBC    ->   SQL
>        browser  <- server <- program <- inferface <- database
>                    in NT

>        I have succeeded with writen a C program to access SQL database
>        in NT. But when I port it to a CGI program, it become fail to
>        connect SQL database!! How should I do for this?

>        Another thing, is there any package or shareware which can do
>        the same thing as I say above? I know one of them is COLD FUSION,
>        and it return the result of query to the netscape browser directly.
>        But I want to deal with the result of query , and then sent them
>        to netscape browser.

>        Any response is welcome !! Thanks a lot!!



On a related matter...

The NT implementaion of Perl 5 from hip communications (ftp://ntperl.hip.com/)
is supposed to have OLE Automation capabilities built-in, although I have not
been able to figure out how connect to a MS SQL Server 6.0 from Perl scripts.  
I would appreciate any help or comments!

Ruben Tsui



Sat, 11 Apr 1998 03:00:00 GMT  
Curt Spring
#4 / 8
 access SQL database through netscape browser in NT

Quote:


says...

>>        Hi, how to write a CGI program to access SQL database in NT ?

>>        netscape ->  WWW   ->   CGI   ->   ODBC    ->   SQL
>>        browser  <- server <- program <- inferface <- database
>>                    in NT

>>        I have succeeded with writen a C program to access SQL
database
>>        in NT. But when I port it to a CGI program, it become fail to
>>        connect SQL database!! How should I do for this?

>>        Another thing, is there any package or shareware which can do
>>        the same thing as I say above? I know one of them is COLD
FUSION,
>>        and it return the result of query to the netscape browser
directly.
>>        But I want to deal with the result of query , and then sent
them
>>        to netscape browser.

>>        Any response is welcome !! Thanks a lot!!

Towers,
Check this out:  http://www.w3spider.com (Spider Technologies).

We are going to download the trial today, and try to connect Sybase
SQL server and Netscape Commerce server on an HP-UX.

This product was recommended to us by Sybase.

I will post whatever findings I think might be of interest.

- Curt Springer
  Harvard Medical School



Sun, 12 Apr 1998 03:00:00 GMT  
sw..
#5 / 8
 access SQL database through netscape browser in NT

Quote:



>>>        Hi, how to write a CGI program to access SQL database in NT ?

>>>        netscape ->  WWW   ->   CGI   ->   ODBC    ->   SQL
>>>        browser  <- server <- program <- inferface <- database
>>>                    in NT

>>>        I have succeeded with writen a C program to access SQL database
>>>        in NT. But when I port it to a CGI program, it become fail to
>>>        connect SQL database!! How should I do for this?

>>>        Another thing, is there any package or shareware which can do
>>>        the same thing as I say above? I know one of them is COLD FUSION,
>>>        and it return the result of query to the netscape browser directly.
>>>        But I want to deal with the result of query , and then sent them
>>>        to netscape browser.

>>>        Any response is welcome !! Thanks a lot!!


>Try SSI+, it has database links right in the HTML so no programming is
>required at all. In addition it is faster than any other ODBC/WWW
>technology available.
>- Mark west

The name Mark West and SSI seem to ring a bell -  are you by any
chance plugging your product to the unsuspecting public ;)


Mon, 13 Apr 1998 03:00:00 GMT  
Maurice Szmur
#6 / 8
 access SQL database through netscape browser in NT

Quote:

says...

>>        Hi, how to write a CGI program to access SQL database in NT ?

>>        netscape ->  WWW   ->   CGI   ->   ODBC    ->   SQL
>>        browser  <- server <- program <- inferface <- database
>>                    in NT

>>        I have succeeded with writen a C program to access SQL
database
>>        in NT. But when I port it to a CGI program, it become fail to
>>        connect SQL database!! How should I do for this?

hi

on unix machines (at least on ours) the cgi program executed by the
www server belongs to the user 'nobody'. If this is the same on NT,
check out if 'nobody' is allowed to use the base...

maurice

--
---------- Maurice Szmurlo, Universite de Caen, France ----------
           Phone: (+33) 31.45.56.16   Fax: (+33) 31.45.58.14    

           WWW:      http://www.info.unicaen.fr/~szmurlo



Mon, 13 Apr 1998 03:00:00 GMT  
Eli Munze
#7 / 8
 access SQL database through netscape browser in NT
Try this:

Go into your control panel, open the ODBC Data source app,
make sure that your SQL app is listed there, select System DSN,
create a new data source relating to your back end and give it
a name, then call it by that name from your code.

Hope this helps

Regards

Eli Munzer
Tampa, FL



Sun, 19 Apr 1998 03:00:00 GMT  
Ferenc Math
#8 / 8
 access SQL database through netscape browser in NT

SQL database in NT ?>>>>        netscape ->  WWW   ->   CGI   ->   ODBC    ->   SQL>>        browser  <- server <- program <- inferf=
ace <- database>>                    in NT

This approach is used by VISIGATE. You can test it via:
http://203.13.55.80/lookfor/default.htm

The CGI functions are split to C++ and VB.
Access to ODBC databases is via VB.

Regards,

Ferenc Mathe, the Windows NT and Internet specialist.
Australia
Phone : 61 - 6 - 247 00 12



Sun, 26 Apr 1998 03:00:00 GMT  
 
 Page 1 of 1
  [ 8 post ] 

 Relevant Pages 

1. Access to an Access database through Netscape Browser

2. create an access database ou sql database

3. Access database to SQL server database

4. Response.Redirect + Netscape Browser + StyleSheets = Problem!

5. Netscape Browsers and VBScript

6. Netscape Browsers

7. I need help with SQL in a VB program to access an Access database

8. Using SQL To access Access 1.1 Database in VB

9. Capture Url and Title in Netscape browser

10. Launch Application from netscape Browser

11. VB script and netscape browser

12. Using VB to control Netscape as a Browser for HTML-files on disk

  

 
Powered by phpBB® Forum Software