Re: Using ASP script to connect to SQL Server


"Biddyman" <biddyman@xxxxxxxxx> wrote in message
news:EdydnRxqvM25ca_YnZ2dnUVZ_u6dnZ2d@xxxxxxxxxxxxxxxx
My provider only allows ASP to connect to SQL Server. They give a sample
script. I've made a form to input data. Where do I put code for the
script?
On the the same page as the Form? Also, What do I put in the option box
for
the send to box?

Thanks in Advance.

Do you know anything about Html? Seems to me I have a list of "Things I
wish I had known before I started using FrontPage...." The list is both
funny and rather sobering.

You do put the file name of the ASP script in the input Form. I assume the
sample script takes the information from the Form, connects to the Sql
server, retrieves the data and then formats it and has the IIS server send
it back to the user.

If you have setup your FrontPage on a Windows 2000 Professional workstation
or an XP Professional workstation you can can install IIS (Internet
Information Server) on that workstation and then use the database wizard to
generate samples of what you want. It will then demonstrate how you want to
stich the html and asp files to do what you want. Oh, yes. The asp code
needs to be saved in a file that has an extension of .ASP just like an
ordinary html page needs to have the extension of .HTM

I just check my notes. Get article 287993 from the Microsoft Knowlege-base
at Microsoft.com It should give you some idea of what your trying to do and
cross reference you into a couple of other useful articles.

If no one else chimes in with more useful information in a couple of days, I
suggest you re-post the question in the "other" newsgroup, the one that ends
in: .client it is VERY active and has several Microsoft VIP's in FrontPage
reading and posting on it.

Thanks,
Tom Miller


.

Relevant Pages

  • Re: ASP search Script
    ... that isn't an ASP script. ... It's an HTML form. ... microsoft search feature. ...
    (microsoft.public.frontpage.client)
  • Re: Hiding personal data in source code viewable on the internet
    ... Depends on which mail handler support your host provides for ASP ... |>> Re-create the form in pure HTML (do not use the FP Web components to ... In Script: grab the data submitted by the form. ...
    (microsoft.public.frontpage.programming)
  • Re: Design View for HTML or ASP Response.Write
    ... > Seeing script tags interspersed with plain HTML is very common but something ... Generally I write all HTML out using Response.Write. ... > work to be done by the ASP interpreter than when you render straight HTML. ...
    (microsoft.public.inetserver.asp.general)
  • Re: ASP error on rendering jpgs
    ... ASP error? ... But the example URL you gave didn't have a .html or .asp ... Therefore, God exists. ... Missing close of script delimiter ...
    (microsoft.public.frontpage.programming)
  • Re: ASP security in HTML pages
    ... never save script in a .html file. ... ASP security in HTML pages ... Although, to be sure, if you don't have your server configured properly, ...
    (Security-Basics)