|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
July 7th, 2009, 06:50 PM
|
|||
|
|||
|
Problems connecting to Access Database on remote server
Hello I am a novice user of Dreamweaver and have just built a dynamic site using ASP and Access Database, with the help of the Missing Manual! I set up an IIS testing server and a custom connection. Everything works perfectly on the testing server but my problem is I don't know how or where to put my database on my ISP. I have tried but the website doesn't display properly - I assume its something to do with the connection to the database being lost. I am a complete Novice and the ISP support is so unhelpful I am now absolutely stuck with a website I can't publish. Any help or ideas would be greatly appreciated. Many thanks, Joanne
|
|
#2
July 7th, 2009, 06:55 PM
|
||||
|
||||
|
who is your site hosted with? is it an IIS server?
most hosts usually have an FAQ on where you need to put access databases. for example, godaddy tells you to put it into a specific directory.
__________________
Come JOIN the party!!! Quote of the Month: Pretension: The downside of being better than everyone else is that people tend to assume you're pretentious. Questions to Ponder: You can be overwhelmed and underwhelmed, but why can't you be simply whelmed? iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm") copyright© 2008 sbenj69
|
|
#3
July 8th, 2009, 03:09 AM
|
|||
|
|||
|
Hi its 123reg.co.uk. They first told me it was as simple as putting everything into the web/content folder. That didn't work so then said connect to my database through their database control panel by setting up a database name then importing my data but this seems to accept only .sql files not access and I don't know how to convert. They do give me the path for the asp connection but I'm unsure how to set this up in relation to my original test connection through my laptop. Its a windows hosting package, don't know about IIS but they assure me the package supports asp and access. I think the problem is once on their server my pages are still looking for my data through the connection I set up on the test server, where I had to specify my connection string as "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Animal Sculptures\Inventory.mdb." Many thanks, Jo
|
|
#4
July 8th, 2009, 08:17 AM
|
||||
|
||||
|
if you have it in the same directory structure that you're showing above ... try something like this:
Code:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\Animal Sculptures\Inventory.mdb") & ";Persist Security Info=False"
|
|
#5
July 9th, 2009, 10:40 AM
|
|||
|
|||
|
Thanks for that. Have tried it and still doesn't work. Have since discovered that I need to import my Access DB as a .sql file so thats probably why its not working. I found some MS software to convert it so hopefully I'll get my head round that and sort it out, if not I'll be back for more advice!! :O) Thanks for your help. Kind regards, Jo
|
|
| Viewing: ASP Free Forums > Web Design > Windows Web Hosting > Problems connecting to Access Database on remote server |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
