Still can't figure out how to populate my Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks to the help I have received on this forum I was able to build my form
and install my DB
The form tells me it is confirmed and even gors to the actual Login page,but
does not place it into the database.
http://www.ultimateworkfromhomeguide.com/MSTutor/PasswordForm.asp
http://www.ultimateworkfromhomeguide.com/MSTutor/global.asa
http://www.ultimateworkfromhomeguide.com/MSTutor/_private/logon.mdb

I was reading through the posts and see often you ask for code so the links
above are the pages with the code behind it
anybody tell me what to do please, and yes I did use F1 first
I looked at PayPal but they require me to write a CGI script and I would not
know where to start. So if someone out there has a heart for a fast learning
novice I would apprecitae that very much.
 
We will need to see the asp code you used - this is not available from
the web page since the server changes the code to HTML.

These instructions apply to your live site:

The database (logon.mdb) is unlikely to work at all in the _private
folder - it needs the correct permissions to operate and these are not
usually applied to the _private folder.
Export the database to the desktop and delete it from the _private
folder.
Then use File->Import to bring it into the website from the desktop.
FrontPage will offer to place the database in the fpdb folder - accept
the offer and FP will apply the correct permissions to the folder and
database.
Also in Tools->Web Settings - database tag check that there is only one
database showing (unless you know of another) and verify the connection.
In PasswordForm.asp check that the database connection string matches
that in the global.asa and points to the database in the fpdb folder.
 
The programming group (where you have several post on this question) is the correct one for questions of this type
- posting it here too won't get you any answers sooner

PS
You need to study server side scripting and their use w/ a database
- a .asp coded page is processed server side so no one will see your ASP code in the page in a browser
- neither .asp or .mdb files are viewable in browsers
Start here http://www.w3schools.com/asp/default.asp
and also here http://www.w3schools.com/ado/default.asp


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Thanks to the help I have received on this forum I was able to build my form
| and install my DB
| The form tells me it is confirmed and even gors to the actual Login page,but
| does not place it into the database.
| http://www.ultimateworkfromhomeguide.com/MSTutor/PasswordForm.asp
| http://www.ultimateworkfromhomeguide.com/MSTutor/global.asa
| http://www.ultimateworkfromhomeguide.com/MSTutor/_private/logon.mdb
|
| I was reading through the posts and see often you ask for code so the links
| above are the pages with the code behind it
| anybody tell me what to do please, and yes I did use F1 first
| I looked at PayPal but they require me to write a CGI script and I would not
| know where to start. So if someone out there has a heart for a fast learning
| novice I would apprecitae that very much.
|
|
 
Ronx said:
We will need to see the asp code you used - this is not available from
the web page since the server changes the code to HTML.

These instructions apply to your live site:

The database (logon.mdb) is unlikely to work at all in the _private
folder - it needs the correct permissions to operate and these are not
usually applied to the _private folder.
Export the database to the desktop and delete it from the _private
folder.
Then use File->Import to bring it into the website from the desktop.
FrontPage will offer to place the database in the fpdb folder - accept
the offer and FP will apply the correct permissions to the folder and
database.
Also in Tools->Web Settings - database tag check that there is only one
database showing (unless you know of another) and verify the connection.
In PasswordForm.asp check that the database connection string matches
that in the global.asa and points to the database in the fpdb folder.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.
FrontPage Support: http://www.frontpagemvps.com/
http://www.rxs-enterprises.org/fp
Click to expand...
 
Thank you Ron,

now that I did all this I get this message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x1ba4 Thread 0xfb0
DBC 0x2b34fdec Jet'.

/MSTutor/_private/logon.inc, line 34

and this is line 34

objCN.Open "driver={Microsoft Access Driver (*.mdb)}; dbq=" & _

I hope this is my last whine
Michael
 
Back
Top