FP98 or InterDev 6  to access SQL 7 database?

Posted on 1999-11-18
Medium Priority
Last Modified: 2013-12-24
Could somebody explain to me (like I'm 3 years old) how to access a SQL 7 database using FP98?  Or point me to a tutorial?
I have installed FP98, sql 7 locally, I even have Interdev 6 installed but it's kinda beyond me (and I don't have time to learn it right now).
I'm switching from Dreamweaver to FP because it's for an intranet on an NT network.  I have tried and tried but I cannot access the DB.
I will even use Interdev (that's the real goal down the road) if you can point me to a good tutorial on that.  I have PWS (v 3 i think) w FP98 extensions.
Question by:pcain

Expert Comment

ID: 2218902
Make sure you have the NT Option Pack for PWS.  You will need to point an ODBC link to the SQL database you wish to connect to from Control Panel.

Ultimately, you will probably need to use something like ASP to access your database.

Expert Comment

ID: 2220606
Providing you have the access rights to the SQL server, choose a new database project in interdev, and the wizard will walk you through the connection process. I know that saying it's very simple can offend, but it really is easy.

The samples that come with Interdev will indicate how a connection is made and how to query the database.



Author Comment

ID: 2221580
To NickRackham :
Yes I did create a global.asa file in Interdev and created a query and added a recordset control to the page.  I just can't get any data into the web page.  I've tried using a grid and simple text boxes. I've pointed the text box to 'recordset 1' and chosen the field to display.  Nothing comes over.  Maybe I don't have PWS installed correctly or something?  I can never get Asp Debugging to work.

To Joejans:
I have the option pack installed. NT4 SP4 IE5. I've created an ODBC connection in the control panel. I get an error like IUSR.... could not connect - does not have access permission to the database.
I am trying to log in SQL as username=sa pwd=  The web page seems to create its own user name and password to connect.
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.


Expert Comment

ID: 2236681
Not sure you can use ASP debugging on PWS, but I could be wrong.

In terms of your database access, are you specifying the SA account in the connection string of the global.asa?

You should also check the NT permissions on the directory for the database.  Unless I miss my guess, SQL server is very happy with the SA account, but NT is looking for a valid NT account to access the directory/file.  By default, the web server uses IUSR_machinename.  You will probably need to either add that account to the permissions on the database/directory or allow a more 'general' (i.e., Everyone) access.

(FWIW, granting Everyone access is not a real great idea unless your data is not at all sensitive.  In fact, granting Everyone ANY sort of access on your machine is not the best idea in the world, even though it is pretty much the Windows default.)



Author Comment

ID: 2245046
Thanks for your insights TTOM, I will give them a try as soon as I get the chance.  The rest of this week is busy for me and hopefully by friday or monday I can apply your suggestions.
PWS crashed and burned and I will re-install as I can.

Accepted Solution

TTom earned 200 total points
ID: 2245137
Best luck!  Understand busy.


Author Comment

ID: 2270565
Ttom, sorry I'm a week late getting back. I re-installed.  The problem I had turned out to be the DB. I didn't have the permissions set up correctly...
Thanks for your patience.

Expert Comment

ID: 2281471
No problem.  Glad it's working for you now.



Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
Suggested Courses

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question