| Author |
Database connection
|
|
| billxo 2004-02-19, 1:29 pm |
| Hello
Can anybody please advise, I?m using the Dreamweaver version 6 for my website,
and wish to connect a database to one of the web pages
The question I wish to ask is as follows
Can I connect an Access database to one of the WebPages locally on my PC, or
does the site have to be uploaded to the web before the database connection can
be made
If I can connect locally which database connection should I use
I would appreciate any advice on the above
Love
Belind
| |
|
| hi yea,
go to http://www.webthang.co.uk for a great tutorial on how to do this.
regards
spud
"billxo" <bill884@hotmail.com> wrote in message
news:c12qfu$eui$1@forums.macromedia.com...
> Hello
>
> Can anybody please advise, I?m using the Dreamweaver version 6 for my
website,
> and wish to connect a database to one of the web pages
>
> The question I wish to ask is as follows
>
> Can I connect an Access database to one of the WebPages locally on my PC,
or
> does the site have to be uploaded to the web before the database
connection can
> be made
>
> If I can connect locally which database connection should I use
>
> I would appreciate any advice on the above
>
> Love
>
> Belind
>
>
| |
| mrichmond 2004-02-19, 1:29 pm |
| It depends on where your test pages are
If the pages you are testing are on your local machine as well then you can
have the database in either place
If your pages are on a remote server then really you most likely will have to
also put your database there
In either case it would be a better practice to place the database in a folder
on the remote website - that is not accessible directly from the web
What this means is that for example, if your root of your website is
d:\MyWebsites\MycurrentWeb
Then you should put the database on a folder higher up so that it cannot be
accessed by typing in a URL to the DB in the web. Then on the remote machine
you can set up yyour database connection to get to the database
Another option is to talk to your hosting company and see if they will make a
folder for you to place your databases in that is not browsable on the web.
That way you are protecting your database from being downloaded and helping
prevent your info from being hacked
| |
| Les Matthews 2004-02-19, 2:29 pm |
| 1. Create a new text file on your desktop
2. Rename the text file to "myConn.udl". Choose yes to accept the change.
3. Double click myConn.udl
4. On the Provider tab, select Microsoft Jet 4.0 OLE DB Provider and click
"Next>>"
5. Browse to your MDB in the top field on the Connection tab.
6. Enter a user name and password, if one is specified in the MDB.
Otherwise, skip this step.
7. Click "Test Connection". If test is successful, click "OK" to close the
alert box.
8. Click "OK" to close the Data Link Properties window.
9. Rename myConn.udl to myConn.txt. Choose yes to accept the change.
10. Double-click myConn.txt and copy the last line.
11. Open DMX and create a recordset, click "Define" connection
12. Choose "New" and "Custom Connection String"
13. Give the connection a name and paste the line you copied from myConn.txt
into the Connection string box.
14. Test the connection
"billxo" <bill884@hotmail.com> wrote in message
news:c12qfu$eui$1@forums.macromedia.com...
> Hello
>
> Can anybody please advise, I?m using the Dreamweaver version 6 for my
website,
> and wish to connect a database to one of the web pages
>
> The question I wish to ask is as follows
>
> Can I connect an Access database to one of the WebPages locally on my PC,
or
> does the site have to be uploaded to the web before the database
connection can
> be made
>
> If I can connect locally which database connection should I use
>
> I would appreciate any advice on the above
>
> Love
>
> Belind
>
>
| |
| DesDev 2004-02-19, 2:29 pm |
| How will you be connecting to the DB? As a DSN connection or DSN-Less
connection?
And yes, you can connect locally, but you will have to make sure that you
have the DB and the connction setup on your website server as well
"billxo" <bill884@hotmail.com> wrote in message
news:c12qfu$eui$1@forums.macromedia.com...
> Hello
>
> Can anybody please advise, I?m using the Dreamweaver version 6 for my
website,
> and wish to connect a database to one of the web pages
>
> The question I wish to ask is as follows
>
> Can I connect an Access database to one of the WebPages locally on my PC,
or
> does the site have to be uploaded to the web before the database
connection can
> be made
>
> If I can connect locally which database connection should I use
>
> I would appreciate any advice on the above
>
> Love
>
> Belind
>
>
| |
|
| what if you get this massage after step 3
C:\Progra~2\common~1\system\oledb~1\oledb32.dll
The specified module could not be found
| |
| Les Matthews 2004-02-19, 4:29 pm |
| Not positive, but I'm guessing you need MDAC:
http://www.microsoft.com/downloads/...&DisplayLang=en
"vmail" <sales@vmail.tk> wrote in message
news:c133ii$gm$1@forums.macromedia.com...
> what if you get this massage after step 3
>
>
> C:\Progra~2\common~1\system\oledb~1\oledb32.dll
> The specified module could not be found
|
|
|
|
| Copyright 2003 - 2008 forum4designers.com Software forum Computer Hardware reviews |