pcain
asked on
FP98 or InterDev 6 to access SQL 7 database?
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.
Tanks
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.
Tanks
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.
Regards
Nick
The samples that come with Interdev will indicate how a connection is made and how to query the database.
Regards
Nick
ASKER
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.
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.
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.)
HTH,
Tom
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.)
HTH,
Tom
ASKER
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.
PWS crashed and burned and I will re-install as I can.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Thanks for your patience.
No problem. Glad it's working for you now.
Thanks,
Tom
Thanks,
Tom
Ultimately, you will probably need to use something like ASP to access your database.