Accessing SQL Servers in the DMZ

[Stone Free]

I have written a program to archive user reports to a temporary area and then deleting them after a set number of days. This program works fine on our Local Area Network, but it cannot connect to an SQL Server which is in the DMZ. ASP.NET programs do not seem to have any trouble. My program is written in C++ and Classic ADO. My connection details are as follows: (written as VB as this is probably the most familiar) Conn.Mode = adModeReadWrite OR adModeShareExclusive Conn.CursorLocation = adUseClient Conn.ConnectionTimeout = 15 Conn.CommandTimeout = 128 Conn.Provider = "sqloledb" Conn.ConnectionString = "Data Source=TheServer;Initial Catalog=TheDB" Conn.Attributes = 0; Conn.IsolationLevel = adXactReadCommitted Conn.Open( , UserNameVar, DBPasswordVar,adConnectUnspecified)