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

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
oconnork00Author Commented:

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?


CWS (haripriya)Commented:
Can you post your asp connectionstring for the database
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

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

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
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
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?
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.
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,

CWS (haripriya)Commented:
Thanks for the points Kevin.
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.