Accessing SQL Servers in the DMZ

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)


Peter
.