Have a SQL server on inside interface of Cisco PIX
firewall and have a SQL server on a webserver on DMZ
interface of the PIX. Opened port 1433 between all inside
PCs and webserver. Created a DTS package using SQL logins
and passwords to update webserver with tables from inside
server. Both SQL servers set to SQL and Windows
authentication. DTS package works perfect - tables
update. Saved package as VB and inserted into an Access
Project. Get a string of errors beginning with

DTSStep_DTSDataPumpTask_1 failed Microsoft OLE DB Provider
for SQL Server [DBNETLIB][Connection Open (Connect()).]SQL
server does not exist or access denied.

Errors similiar to above continue fot all Pump tasks.

Any ideas why?

Ability for staff to update tables independently of a
scheduled SQL service is important here.

THanks V much.

RH wrote:
Set up IIS on the SQL-Server, where the Scheduled DTS-Jobs resides.
Script a small asp.page which starts the suggested dts-job by
"sp_start_job"-statement.

So you don't need to code an access-project and anything else.

This work will be done in 15 minutes!

regards

Frank

to catalogue, track sales, etc of all the material in
their collection. The webserver has a new online picture
gallery containing a selection of the material in their
library. This web site will be updated and added to on a
regular basis. The VB program which updates the tables on
the web server is part of the bigger Picture Library ADP
and SQL server database. If possible, I would really like
to keep the programming as part of that project rather
than as asp.net. And I would like to understand why it
works as a DTS package but not with the VB script of the
DTS package.