Re: Accessing SQL Servers in the DMZ


"Peter Nimmo" <PeterNimmo@xxxxxxxxxxxxxxxxx> wrote in message
news:Xns98CB7E1B76EBEPeterNnospamtnsofres@xxxxxxxxxxxx
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

Firewalls and DCOM have issues as COM is a major security hole. ie, this
isn't an ADO problem per sec. You will need to configure your system to
specifically work with it.

How and where depends on your domain, wire, hardware, etc. Get with your
admin and work it out.

-ralph


.