connect to database and view results locally

Hi all,

I am using fp2003 and used the database import wizard to connect to a database.


I want to be able to publish and view the results locally on my laptop instead os having to publish to a web server.


What do I need to be able to view the results of the database as I am using asp pages and it keeps telling me to publish to a website with asp installed.

Is there something I can download to emulate the asp part?


I am connecting using ms sql

Thanks in advance guys


Kevin
LVL 2
oconnork00Asked:
Who is Participating?
 
CWS (haripriya)Connect With a Mentor Commented:
You can run this on IIS from your laptop.

I don't use frontpage wizard for connecting to the database. I manually code the connections. Also, I am not familiar with SQL. Let us leave this open for other experts to comment.

Good Luck
0
 
oconnork00Author Commented:
Hi,

I have managed to figure out that I needed IIS so installed that, and chose http://localhost as the path for my website.


So I have the database appearing in the web browser and I am getting this message:

Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator.



So I am not getting any results returning.

Can anyone suggest whats going on?


Regards,

Kevin
0
 
CWS (haripriya)Commented:
Can you post your asp connectionstring for the database
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
bigbillydotcomConnect With a Mentor Commented:
please check this howto on configuring IIS
http://www.bigbilly.com/bbdc/howto

once properly configured, you should have no problems running an asp website on your pc
0
 
oconnork00Author Commented:
My connection string (i hope!)

<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
      '==FrontPage Generated - startspan==
      Dim FrontPage_UrlVars(1)
      '--Project Data Connection
            Application("database1_ConnectionString") = "DRIVER={SQL Server};SERVER=work;DATABASE=frontpage test"
            Application("database1_ConnectionTimeout") = 15
            Application("database1_CommandTimeout") = 30
            Application("database1_CursorLocation") = 3
            Application("database1_RuntimeUserName") = ""
            Application("database1_RuntimePassword") = ""
      '--
      Application("FrontPage_UrlVars") = FrontPage_UrlVars
      '==FrontPage Generated - endspan==
End Sub
Sub Session_OnStart
      FrontPage_StartSession '==FrontPage Generated==
      FrontPage_ConvertFromODBC '==FrontPage Generated==
End Sub
0
 
CWS (haripriya)Commented:
Is your database "frontpage test" is in the same folder of your asp files?

Also, try changing the database name as a single word without any space and special characters.

Good Luck
0
 
oconnork00Author Commented:
Hi, yeah it is in the same folder and I also changed the name to a single word database.


Is it possible that I cannot run this on IIS from my laptop?
0
 
oconnork00Author Commented:
hey all,

Any one got any suggestions as to what to do with this post? it's run dry and was thinking of closing it out.
0
 
oconnork00Author Commented:
Hi folks,

I have managed to get this working after looking into the IIS feature as suggested by you both. As a result I am going to share the points between both of you for your inputs and as both of you have given me a collaborative answer to what I was looking for.

Bigbilly for pointing me to IIS first, then cyberwebservice for the follow ups and advice.

Thanks both,

Kevin
0
 
CWS (haripriya)Commented:
Thanks for the points Kevin.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.