|
| |
|
|
WinlitGroup
Posts: 9
Joined: 6/10/2004
Status: offline
 |
I think I'm just an idiot... please help - 6/15/2004 14:21:13
how do I make a database on my website?
I use a remote webserver, which even provides me with stupid database software, compatible with ODBC. I entered in my local IP (wan), to allow me to access the database from "any application" but I can't connect from front page or access..
all I want to do is do a simple database query to search zips and states for a simple store locator... I have the table.... can anyone help?
-Adrian
Winlit Group, LTD
|
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: online
|
RE: I think I'm just an idiot... please help - 6/15/2004 14:34:12
So I assume the database does not reside on the same server as the web pages? If not, then you need to create a DSN to the webserver so that it knows how to connect to the other server. Also, on the server that the db resides on you will need to give read/write permissions to the db for the guest account of the web server. The account should look something like IUSR_MACHINENAME where MACHINENAME is the name of the web server.
I guess I should ask, are we talking about a Windows environment? What type of web server?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
WinlitGroup
Posts: 9
Joined: 6/10/2004
Status: offline
|
RE: I think I'm just an idiot... please help - 6/15/2004 14:59:26
well here's the deal, the web server (webnethosting.net) supports mySQL and unlimited databases... I'm not exactly sure what that means, but if I could keep the database on there, it would be great. If it's easier to use one of the servers here (which the SA said he can let me use one of the terminal servers for this purpose, and give it it's own wan IP, then I can. The web server is running Red Hat 7.2, my local machine is running XP, and the terminal servers are running Windows2000.
I guess I want to do whatever is quickest. As I said, my ultimate goal is to have the visitor submit either their state or zip and get back a list of stores (the table includes colums for Store Name, Address, City, State, Zip)...
| |
|
|
|
WinlitGroup
Posts: 9
Joined: 6/10/2004
Status: offline
|
RE: I think I'm just an idiot... please help - 6/15/2004 15:23:19
I guess so...
so what do I do?
| |
|
|
|
WinlitGroup
Posts: 9
Joined: 6/10/2004
Status: offline
|
RE: I think I'm just an idiot... please help - 6/15/2004 16:38:43
anyone???
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: online
|
RE: I think I'm just an idiot... please help - 6/15/2004 17:18:16
Or get a new host that supports ASP and FrontPage. I always wonder why one would try to adapt their coding to their host. I would think it would be the other way around.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
WinlitGroup
Posts: 9
Joined: 6/10/2004
Status: offline
|
RE: I think I'm just an idiot... please help - 6/15/2004 17:30:40
the server has FP extensions on it... that's how I communicate with the server... very helpful... given this, is there an easier way than learning PHP and SQL?
| |
|
|
|
WinlitGroup
Posts: 9
Joined: 6/10/2004
Status: offline
|
RE: I think I'm just an idiot... please help - 6/16/2004 11:11:45
I'm somewhat confused...
I see all these people are using the FP DRW to get results from a simple search of their access database... the only problem I have is creating the database connection.
I have the database (fields including store name, address, city, state, zip, and about 10 yes/no fields)
I have the web page.
I have the webhost (which supports FP extensions)
and I have a server here that I can assign its own IP and make that a DB server if necessary.
is there no way of using the Wizards in FP and Access? or do I really have to learn all of this code?
Thanks once again for helping!
-Adrian
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 