Thanks so much for your quick response!

Here are the anwsers to your questions, I am sure that we can now get to the bottom of this quickly!

In response to this:

Why don't you copy and modify the connection string from another page that works?  Without access to your machine to see what is going on there is nothing I can do to make it work.  The connection is very simple and there isn't any debugging that can be done via a message board.

Thanks for your suggestion! We originally did not expect this project to be done for the web, although we like the web solution MUCH better then what we thought we were going to receive! 

Unfornately, you did this page for the web using ASP without asking us which technology we use here. In fact, we have no ASP pages here on any of our servers that we can use as an example, we are totally Dot Net Based, and the connection strings and methods are very different. If you like, we can send you a sample of how we do things in Dot Net and you can change the app to work in our environment. Of course I will be willing to pay extra for this.

If you would like to try to troubleshoot the existing connection string, here is that one that modified and put into the application that fails to work:

<%
 Dim CONN
 CONN.Open "Driver={SQL Server}; Server=(local); Database=enterprise; Uid=enterprise; Pwd=entx2003n"
%>

We also tried this variation which also does not work:

CONN.Open "Driver={SQL Server};" & _ 
           "Server=localhost;" & _
           "Database=enterprise;" & _
           "Uid=enterprise;" & _
           "Pwd=entx2003n"

Luckly when I run the script on the production server I actually get a meaningful error message:

Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
dbconnection.asp, line 3

This is what a working connection string from one of our dot net pages looks like:

Dim ConnectionString as String = "data source=(local);initial catalog=enterprise;user id=enterprise;password=entx2003n;persist security info=False;packet size=4096"

Dim myConnection As New SqlConnection(ConnectionString)

If you can spot the problem with the connection string, please let me know.

Also, attached is a ASPX Page that we use standard with our application, and this ASPX page has a bunch of lines of code twords the top that makes the Connection String, Company, Division, and Department available to whatever code is in the body.

Please let me know how you want to proceed, i.e., either re-writting for our standard dot net or continuing to trobuleshoot the asp connection string

Also, Thanks for the changed xml file, I have now retrieved it.

Thanks!
