AArgh!!
OK
I am building my UD apps using IIS on a local machine. I have a development directory which is my local directory, my application server points to the virtual directory in my INETPUB folder. I connect to my DB using a DSN.

This all works great, no problems at all...

However then i want to put the applications on my hosts server. And its a nightmare!!! I just cant get a connection at all!!

My connections.asp reads----->

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
MM_poll_STRING = "Driver={Microsoft Access Driver (*.mdb)}; DBQ="Server.MapPath("/www.europc.co.uk/poll/db/poll.mdb")"
%>

The Error I get online is -------->

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/poll/poll.asp, line 88

poll.asp reads ---(Lines 85-96)----------->

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command"
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

If (MM_editRedirectUrl <> "" Then
Response.Redirect(MM_editRedirectUrl)
End If
End If
--------------------------------------

Does anyone know of any good articles about the issues involved in moving your UD4 Project from its nice cosy local development environment to a web host???

Cheers!

SORTED!!!!!!!!!!!!!

<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>