Using ASP script to connect to SQL Server

B

Biddyman

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.
 
T

Tom Miller

Biddyman said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top