I am trying to avoid upgrading one of my accounts to a more expensive plan. Otherwise I could create another DSN to the SQL Databases&#039 IP address.<BR><BR>I want to Query my SQL Database at one server for records and then I need to package the resulting records and send them via a form, or .txt file, or via XML, to the second server which does not have a SQL DSN.<BR><BR>Which is the best way to get across servers like this? Is it possible to have it FTP&#039ed as a text file using ASP?<BR><BR>I am willing to click a processing script link every now and again to update it, but in the long run this must all run self sufficiently. <BR><BR>Can I get some code, articles, or links? <BR><BR>Here is the code so far.. I need to write to a .txt file on another server or something? <BR><BR>&#060;!-- #include virtual="includes/db.asp" --&#062; <BR>&#060;% <BR>dbdate = Date() -7 <BR>sSql = "Select * FROM Products_Other WHERE PR_Date &#062; &#039" & dbdate & "&#039" <BR>rs.Open sSql, conn, 1, 3, 0 <BR> rs.MoveFirst <BR> Do While NOT rs.EOF <BR>Response.Write rs("PR_Date") & " <BR>" <BR> rs.MoveNext <BR> Loop <BR> rs.Close <BR> Set rs=nothing <BR>%&#062;