I discovered the problem. I followed the method below to set up virtual directories and FTP. I changed the FTP user password today and the site went down and couldn't...

Thanks for trying everyone. Time to take a different route I think.

SQL Server Native Client 10.0 is on both machines although the versions were different. I've undated the version on the script machine and it is now the same as SQL...

Does SQL Server Native Client just need to be on the machine that is running MSSQL Server?

If so it should be install by default I believe.

"Microsoft SQL Server Native Client...

opc.three (4/14/2011)

---

You are using the wrong driver. Try this connection string:

"Driver={SQL Server Native Client 10.0};Server=" & srv & ";Database=" & db & ";Uid=" & uid & ";Pwd=" & pwd &...

Error messages:

srv = IP\SQLEXPRESS,1433

"SQL Server does not exist or access is denied"

srv = IP

"Object required"

srv = IP\SQLEXPRESS

"SQL Server does not exist or access is denied"

srv = "IP"

uid = "user_name"

pwd...

SQL Server Browser is running.

I've tested with the following and can't connect

IP\SQLEXPRESS,1433

IP\SQLEXPRESS 1433

IP\SQLEXPRESS:1433

IP:1433

(not quite sure how to add the port)

Firewall has MSSQL added under port 1433 and the setting appear...

This has already been done which is why I can telnet...

Thanks Jack I didn't know about that option, but it looks like it might do the job. Do I have any issues with timing out if I execute about 15...

Hi. The SPs import XML data, format it and insert it. Is it best to use run a job using a local copy of SQL Server 2008 Express that connects...

Hurray! You're a star. I've finally got to see the parameters with the following event type.

exec sp_trace_setevent @trace_id, 11, @current_num, @on -- RPC:Starting - Occurs when an RPC has started.

Many...

Thanks Jack, the last post has been helpful. I've now managed to get a trace working which shows me parametized SQL queries from ASP pages, but it's still not much...

Hi Jack, many thanks for your reply. The problem was a permissions thing. It seems I needed to create the folder the trace was being saved to manually. I guess...

Thanks for your help with this. As I've learnt more this post is drifting off topic so I'll make new post to keep it a useful thread.

I've been looking at the following post (http://www.sqlservercentral.com/Forums/Topic576752-146-1.aspx%5B/url%5D) on creating a trace but I'm getting errors trying to run the following code.

declare @traceidout int

declare @maxfilesize bigint

declare @on bit

set...