Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

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
0
oconnork00
Asked:
oconnork00
  • 5
  • 4
2 Solutions
 
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
 
bigbillydotcomCommented:
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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
 
CWS (haripriya)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:
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now