Iis

Following a major PC crash, I've had terrible trouble setting up IIS again and am plagued with permission issues and unable to get any sites toi run on virtual server.

is there anyone who can set up a connect and troubleshoot it - i'm happy to pay a support charge obviously

We do not offer support for server configuration.

perhaps consider using one of the Apache PHP packages such as WAMP or XAMPP.

I had a horrible time in Windows 7 getting php working with IIS. I ended up ditching IIS for XAMPP and had a wroking installation in about 10 minutes.
xampp.html

thanks jason.

regards my other point about the DSN-less connection that you replied to yesterday, would you be kind enough to quickly just comment on the following and then i promise to leave you alone as i appreciate this is wide of webassist's remit - i'm just a bit confused.

i m,anged to get a new ASP page to connect using:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "E:\Domains\e\everythingforthechef.com-19969252\user\database\chef.mdb"
%>

it works fine for a new test page that has had no recordsets already created, but if i apply this to a page that already exists with recordsets, it doesnt work. If i open the Add Recordset DIalog box in DW, it says "Unable to retrieve tables from this connection, click on the Define button and test connection"

When I look at the code for a recordset they all refer to the previous conn_chef DSN connection, i.e ;

<%
Dim rsMfrMenu
Dim rsMfrMenu_cmd
Dim rsMfrMenu_numRows

Set rsMfrMenu_cmd = Server.CreateObject ("ADODB.Command")
rsMfrMenu_cmd.ActiveConnection = MM_eftc_STRING
rsMfrMenu_cmd.CommandText = "SELECT * FROM tbl_mfr ORDER BY item_mfr ASC"
rsMfrMenu_cmd.Prepared = true

Set rsMfrMenu = rsMfrMenu_cmd.Execute
rsMfrMenu_numRows = 0
%>


Is there a way around this or will my new DSN-less connection mean my pages won't work?

If you could point me in the right direction I'd be grateful as ever.

thanks

your connection is now pointing to a location that only exits on the remote server.

Dreamweaver cannot make that connection to the remote servers location, you need to have a local connection file that is configured to connect to the database on your local computer, and another copy of that connection file for the remote server.

Kinda get you. I changed the local connection string to

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_eftc_STRING
MM_eftc_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\database\chef.mdb"%> %>

But it tells me

Data Source name not found and no default drive specified?

Also, given that logic, my file index2.asp should work once it's online if that previous code was good for the uploaded connection. But it doesnt.

Is it possible to pay for a support ticket to get to the bottom of this. Appreciate its not a WA issue but a DW one...?

the data source needs to pass a full path to the database


open up the windows finder and browse to the database, copy the address from the address bar and add that to the data source path, something like:
Data Source=C:\initpub\wwwroot\yoursite\database\chef.mdb

1. did that. so path is

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\SmallBusinessMedia\Websites\everythingforthechef\htdocs\database

now it errors

Data Source name too long

2. Tho this would solve the local issue, my connection for the remote server is good for a new test page but doesnt run my previously built pages that were connected via the DSN. my index2.asp page for instance wont run, tho it is using the include file eftc.asp which has the new info in and which is fine for the newly createde test2.asp page (which has no recordsets)

1) Move the database to a location where the data source name would be shorter.


2) The idea is to have 2 connections files of the same name, one that is uploaded to the remote server, with the data source path set for the remote computer.

the other with the data source file for the local computer.

the way I end up doing this is to follow these steps:
1) On the database tab, create the connection using the information for remote server.

2) Upload the connects folder to the remote server

3) In the files panel, set the drop down to connect to the remte files.

4) Right click on the connection file and select Set Permissions, clear the write permissions for all 3 users to make the file on the read only

5) Set the files panel back to local view

6) On the database panel, double click the connection connection to edit it, set the data source path to the local path.

now you have a remote connection file on the remote server that is set to be read only with the data source path for the remote server. since it is read only, the local settings cannot over write it, Dreamweaver will fail to upload the connection file if it tries.