musictopia
|
| Posted: 07/22/2005, 11:58 AM |
|
Let me start by saying that the help files are superb!
I think there's something I'm not getting about creating a connection. I configure one to work remotely, with ASP and an Access2003 database. I can view the database tables, build queries and browse results, but when I build the page, I cannot preview (anticipated since the db is on the server) and cannot see the data when the page is published.
Note: I am using godaddy to host.
I deleted everything from the server and tried to build a simple grid from work at lunch time...then realized that the db is Access 2003 and my new job is only running 2002 (ouch!).
I plan on re-trying Saturday. Any tips would be appreciated. If I am still having an issue, I will provide explicit details.
I am loving this tool, and I've only been working with it for less than 48 hours!
Carla
Musictopia Entertainment
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 07/22/2005, 12:38 PM |
|
Hi,
I am not aware of a possibility of being able to connect from one computer to a remote MS Access database on another computer. It may be just something that I don't know, but for now I am assuming that you will be running ASP programs on the same computer/server where the database is placed. Thus you may be running ASP programs locally and connecting to your local database, while when you copy/publish ASP programs to GoDaddy server then they should be connecting to the database on that server.
The best way to handle this is to find out the exact path to your database on the GoDaddy server, then enter it into the connection string within your CCS Connection -> Server dialog.
Sample server connectoin string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SomePath\DatabaseName.mdb;Persist Security Info=False
I think that GoDaddy automatically creates one writable folder specially for placing databases in, and they should provide you with the path to that database folder. Or you can enter the databse name without a folder, and then you may see an error message that displays the full path to the default folder, and from there you may be able to figure out the rest.
Keep in mind that currently CCS allows only one server connection settings to be specified, so you may end up changing your Connection/Server settings each time when you change the publishing between the local and remote server.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
|
