close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Iis

Thread began 6/08/2011 4:58 am by russell298997 | Last modified 6/08/2011 2:01 pm by Jason Byrnes | 1472 views | 7 replies |

russell298997

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

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

russell298997

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

russell298997

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...?

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

russell298997

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)

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...