Now on Windows Plesk Server

[s32k]

My account has been migrated from 87.117.201.122 to the Plesk server. I've set up all the email accounts again, and as far as I can see the only things missing are the MS Access databases.

Do I need to set up a new folder on each domain and upload them again? Is there a special place they should go? Since they all use DSN-less connections, I need to find this out so that any code changes can be done or the pages won't work.

Thanks.

[flesso]

Originally Posted by s32k

My account has been migrated from 87.117.201.122 to the Plesk server. I've set up all the email accounts again, and as far as I can see the only things missing are the MS Access databases.

Do I need to set up a new folder on each domain and upload them again? Is there a special place they should go? Since they all use DSN-less connections, I need to find this out so that any code changes can be done or the pages won't work.

Thanks.

If I were you, I would add a new folder to each domain, and upload the Access databases to there; I would then change the connection strings as necessary. You will need to know the new location of your domains on the server to change the connection strings, to do this add the following code to a classic ASP page in the 'httpdocs' folder of your site:

PHP Code:


<%

Response.Write(Request.ServerVariables("SCRIPT_NAME"))

%> 


That code should give you the exact drive locations of your website.

[s32k]

Thank you for confirming what I thought would be the case, and so quickly too . It's only a matter of changing a string within the server variable, but it's a bit tedious to do for a lot of websites.

I'm off tomorrow for a 3-day break, my first one this year, so it's going to be a late night!

Many thanks

[flesso]

Sorry, I gave you the wrong code, it sould be:

PHP Code:


<%

Response.Write(Request.ServerVariables("PATH_TRANSLATED")) 

%> 


[Rock]

All the data has been carefully moved from the old server to the new one. The MS-Access Databases (.mdb files) too have been moved & copied into the 'Private' folder. Please open up a ticket with the suport dept & we'll get the 'Private' folder renamed to 'DB', for which you won't have to make any sort of changes into your connection strings.