Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Whats required on an ISP to run VBScript and ASP??

Status
Not open for further replies.

DougP

MIS
Dec 13, 1999
5,985
US
I am signing up with GTE to get DSL and I get 5 Megs of WEB space.<br>It say's to use and FTP program to upload to my site.<br>So I can create WEB apges in Notepad or Front Page 2000.<br><br>If I put <br>&lt;%@ Language=VBScript %&gt;<br>will that work?<br><br>Is something on the server that lets VBScript work or is that Browser independent or what?<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
The ISP just has to be able to run a ASP, typically this requieres at least an NT4.0 Server or higher, with IIS4 or higher Server.<br><br>but even then you have to ask your ISP if they allow ASP and serverside scripting, because Serverside takes up their server's CPU load, and they are able to disable ASP and serverside componets even if they have IIS4+<br><br>you can run Client-side vbscript though, but will require IE. If you want browser independant, and thats client side, check Javascript, most browsers support this. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>
 
thanks,<br>I am VB/Access guru but VBScript is completely new to me.<br>Plus I am a copy/paste programmer. I fiddle with something until it works then I save it so I can use it later.<br>If something already works I just copy it out and make a few changes and bingo I have a slightly newer one.<br><br>Whats the differnce in client side versus server side?<br>If I have an Access database on my 5 meg site and want to find something in it using VBscript, can I?<br><br>Here at work we are using SQL server for our database so our ISP who is not GTE has SQL running on an NT server.<br>I created a ODBC link to their SQL server and can do anything to the database using SQL' Enterprise Manager.<br>We maintain all of the data (Create tables, data, Add/Edit/Delete anything etc.etc.<br>Is that Server side?<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
I went to their WEB site and they have a scripts folder that you can use to create a mail form.<br>Here is the link for the form.<br>&lt;FORM ACTION=&quot;<A HREF=" TARGET="_new"> METHOD=&quot;POST&quot;&gt;<br><br>Now can I create my own .EXE to do something similar and have it somewhere else?<br><br>In other words, can the &quot;form Action&quot; be anywhere in the world?<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
Serverside is ran off the Server before returning to the user<br>for example a short ASP would be<br><br><FONT FACE=monospace><br>&lt;%@Language=Vbscript%&gt;<br>&lt;HTML&gt;<br>&lt;BODY&gt;<br>&lt;%=Time()%&gt;<br>&lt;/BODY&gt;<br>&lt;/HTML&gt;<br><br><i>same as</i><br><br>&lt;%<br>@Language=Vbscript<br>Response.write &quot;&lt;HTML&gt;&quot; & vbcrlf & &quot;&lt;BODY&gt;&quot; & vbcrlf<br>'For exact textual look as above<br>Response.write Time()<br>Response.write vbcrlf & &quot;&lt;/BODY&gt;&quot; & vbcrlf & &quot;&lt;/HTML&gt;&quot;<br>%&gt;<br></font><br><br>anything inside of the &lt;% %&gt; is proccessed by the server before it is returned, so the result you end up seeing if you look at the source code on the client is<br><br><FONT FACE=monospace><br>&lt;HTML&gt;<br>&lt;BODY&gt;<br>3:03:46 PM<br>&lt;/BODY&gt;<br>&lt;/HTML&gt;<br></font><br><br>none of the server side code is ever sent to the client, it's interpreted and sent back as if it were an HTML all along.<br><br>a VBscript, is on the client side, and runs off the client, also everything can be seen in code, as well as only be able to run on IE.<br><br>like your ususal:<br><br><FONT FACE=monospace><br>&lt;script language=&quot;VbScript&quot;&gt;<br>&lt;!--<br>&nbsp;&nbsp;&nbsp;&nbsp;sub sayhi()<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msgbox &quot;hi&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;end sub<br>--&gt;<br>&lt;/script&gt;<br></font><br><br>the code above runs only on the client, not the server, and is visible in the source of the HTML, and can only be run on IE, or a Browser that may have some kind of VBscript plugin. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>
 
also that exe, not quite, you cant do that, you can only submit to a webobject, in similar, a compiled serverside is also known on CGI/Bin, in asp if you post something, you can do it like this<br><br><FONT FACE=monospace><br><b> on ASP that sending data </b><br><br>&lt;Form action=&quot;second.asp&quot; method=&quot;post&quot;&gt;<br>&lt;input type=&quot;text&quot; name=&quot;myname&quot;&gt;<br>&lt;input type=&quot;submit&quot;&gt;<br>&lt;/form&gt;<br><br><b> on the ASP receiving (in serverside code) </b><br><br>&lt;%<br>...<br>Response.write Request.Form(&quot;myname&quot;)<br>...<br>%&gt;<br><br><i> that'll return the name you typed in the box onto the new page </i><br><br></font><br><br>you can use the vbscript to format your own HTML as well as if thens, and most of what vb does, except not visually, coding almost exactly the same on serverside scripting, and you can use ActiveX dlls in your ASP on serverside using the Server.CreateObject(&quot;ProjectName.ClassName&quot;)<br><br>through your ASP you can use ActiveX dlls, and other non-visual controls, to increase your functionality, there is also tons of scripting objects to help as well. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>
 
So, If I can upload a small Access database, can I use client side to save and get information from it?<br><br>here is some code I had laying around<br>&lt;%<br> Set Conn = server.CreateObject(&quot;ADODB.Connection&quot;)<br> Conn.Open=&quot;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=&quot; & server.mappath(test.mdb) & &quot;;uid=;pwd=;&quot;<br> Set RS = Conn.Execute(&quot;SELECT Counter FROM [HitCounter]&quot;)<br><br> Hit=RS(&quot;Counter&quot;)<br> Temp = RS(&quot;Counter&quot;) + 1<br> Response.Write Hit<br>%&gt;<br><br>My database is called Test.mdb <br>Can you help me with the syntax?<br>I know I need to change &lt;% to &lt;--<br>But I get an error on the following line<br><br>Conn.Open=&quot;DRIVER.....<br>------------------- which is as follows -----------------<br>Microsoft VBScript runtime error '800a01a8' <br><br>Object required: '' <br><br>/hitcounter.asp, line 11 <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
um, no, you can use server-side to grab the information, and stick it into your HTML<br><br>&lt;%<br><br>Dim Conn<br>Dim RS<br><br>Set Conn = Server.CreateObject(&quot;ADODB.Connection&quot;)<br>Set Rs = Server.CreateOBject(&quot;ADODB.Recordset&quot;)<br><br>Conn.Open &quot;SomeDSN&quot;, &quot;sa&quot;, &quot;&quot;<br>RS.Open &quot;Select * from SomeTable&quot;, Conn, 3, 1<br><br>Response.Write &quot;&lt;TABLE border=1&gt;&quot; & vbcrlf<br>while not RS.EOF<br>&nbsp;&nbsp;&nbsp;Response.Write vbtab & &quot;&lt;TR&gt;&quot; & vbcrlf<br>&nbsp;&nbsp;&nbsp;for each Field in RS.Fields<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Response.write vbtab & vbtab & &quot;&lt;TD&gt;&quot; & RS(Field.Name) & &quot;&lt;/TD&gt;&quot; & vbcrlf<br>&nbsp;&nbsp;&nbsp;next<br>&nbsp;&nbsp;&nbsp;Response.write vbtab & &quot;&lt;/TR&gt;&quot;<br>wend<br>Response.Write &quot;&lt;/Table&gt;&quot;<br><br>Rs.close<br>Conn.Close<br>set RS = nothing<br>set Conn = nothing<br>%&gt;<br><br>you'll get a table back on the client. but all information and logic is performed strictly on the server. you can use pure HTML to you advantage, and use Javascript as your Client side script for maxium browser compatibility, like for example lets say you have a list of files returned back from a FileSystemObject script routine, and lets say when you click on it, you want it to send that back to the ASP page so it can return that path, or file info, using Javascript and ASP in your ASP you can make it include the dynamic information to use in the Anchor, so that when you click on it, the Javascript cant navigate with the right parameter. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>
 
oh as far as your error, you dont use =, and you dont need to change &lt;% to &lt;-- , serverside uses &lt;% to reconize serverside script blocks, none of this code will be seen on the client, only the non-server side information will be seen on the client, or what you directly tell to send back. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>
 
oh btw if you want to test out your serverside script on your own computer, and you have Win9x, you can download PWS4(Personal WebServer) from microsoft, just look for the NT4 Service Pack for Win9x, and install that, you'll also need Visual Interdev, to publish your ASP onto the webserver. (not sure if just throwing a ASP into the root folder of the PWS will work)<br> <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>
 
Thanks for all the info:<br>I am using Front Page 2000 and after I connect to Our WEB site (Professional domain) I just create a blank page and save it as an .ASP. I copy and pastes most of the code then hit the &quot;Save floppy icon&quot; in FP.<br>Since I am connected live it saves the .ASP to our site. I then open a copy of IE 5 and just type the URL to the new page and it pops up and works fine.<br>I don't have Intenet DEV...<br>I am also testing on our Backoffice Smallbusiness Server 4.5 which is running SQL and Exhange an I guess IIS 4.<br>It does the same thing, just pops up and works.<br>Of course I get lots of sytax errors until I get it debugged. But IE 5 is real good about spelling out exactly what line and sometimes the exact spot on the line.<br>Like so:<br><br>Microsoft VBScript compilation error '800a03ea' <br><br>Syntax error <br><br>/hitcounter.asp, line 11 <br><br>Conn.Open=&quot;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=&quot; & server.mappath(test.mdb) & ;uid=;pwd=;&quot;<br>---------------------------------------------------------------------------------------^<br><br>See the caret pointer<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
Oh I forgot I need a DSN-Less connection.<br>I can't get my Free site to create an ODBC DSN..<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
um, you're still missing it, dont put a = after Conn.Open<br><br>also Its Microsoft InterDev not Internet Dev.<br><br>FrontPage is best when building regular non-server side pages, Interdev works best when developing Web Applications (lots of serverside and so forth) are you even sure that your site will allow certain Serverside ability, also what you are duing is DNS-Less, should work except try putting &quot;sa&quot; for the uid. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>
 
Still getting error<br>--------------<br>Microsoft VBScript runtime error '800a01a8' <br><br>Object required: '' <br><br>/hitcounter.asp, line 15 <br>----------------------<br>Line 15<br>as shown: <br>Conn.Open &quot;DRIVER={....<br><br>-------------- Entire code ---------------<br>&lt;%<br><br>Dim Conn<br>Dim RS<br><br>Set Conn = Server.CreateObject(&quot;ADODB.Connection&quot;)<br>Set RS = Server.CreateOBject(&quot;ADODB.Recordset&quot;)<br>Conn.Open &quot;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=&quot; & server.mappath(test.mdb) & &quot;;uid='sa';pwd=;&quot;<br><br>Set RS = Conn.Execute(&quot;SELECT Counter FROM [HitCounter]&quot;)<br><br> Hit=RS(&quot;Counter&quot;)<br> Temp = RS(&quot;Counter&quot;) + 1<br> Response.Write Hit<br>%&gt;<br>----------------------------<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
how are you running it?<br>it would appear that your site doesnt have ASP support, and is trying to run Raw VBscript, but thinks Open is an object that doesnt exist? <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>
 
I though about that last night after I left here.<br>I am runnig it on the Backoffice Small Businiess Server here.<br>I think you are right about not having .ASP support.<br><br>So I think I am answering my own question about My FREE 5 meg site on GTE.<br><br>It ain't gonna work there either.<br><br>Thanks a Million fo all your help!!!!<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
no prob, most site that would support ASP are usually the ones you have to pay for hosting it, or if you have a perm IP(and fast connection also, i've seen static 33.6 installed before) then you can either upgrade to NT4 w/ IIS4, or Win2k Server w/ IIS5, or you could just download PWS4 for Win9x(tho its free, its limitied to 5 users I think , and if you dont close a session or if they dont click loggoff it could take a while to let another user in, and not as stable as the IIS package)<br><br>now the webhosting thing, I've seen somehwere between 100-250$ a month for a company to host you a 100MB webspace with ASP, CGI-BIN, Perl so forth support, they usally do this since serverside technologies take up CPU powers of the server, rather than just spitting back HTML pages(and other links) to the request.<br><br>anyways PWS is a good way to learn on your local machine.<br><br>good Luck <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>
 
Wait a minute I have spent alot of time reading ASP books and from everything that I have read his error message is one that is thrown back by asp as a server side response if it were a client side response you would get a error dialogue box. Or you would get a server error of some sort like 405 or something. Get the book Begining ASP by WROX and you will thoroughly understand ASP like never before! <p>Steve Hagerman<br><a href=mailto:Admin@Advancedisp.com>Admin@Advancedisp.com</a><br><a href= ISP high speed internet access</a><br>I did it my way!
 
stingman1 if you noticed, we've determined that as saying that ASP is not supported off his Free website. which would be about the same conclusion you mentioned. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top