Open File - Security Warning

I have a SQL job that calls a command file that executes a vbscript. I am getting "Open File - Security Warning" whenever the command file calls the vbs as it goes through a loop. Is there a way to suppress the warning dialog box?

Thanks!!

This is a SQL Server Integration Services forum. Are you using SSIS in this issue?

If not, you might want to try the SQL Server Database Engine or Transact-SQL forums.

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

Open an Password Protected Access-2000 Database (OLE DB)

Hi,
I have created reports for a password protected database using Crystal Reports-8 thru OLE DB Connection. Whenever calling the report from a VB Form(thru Crystal Report Active-x Control), it reports "Unable to logon to SQL Server".

But if I try same thru ODBC Connection thru a DSN, it works perfect.

Since, there is a need to change the name of the source database (during runtime, the report has to access data from different databases), I require the same thru an OLE DB Connection. OR there is any way to change the database name in an odbc dsn by modifying connection parameters?

I remain.

Thanks.If u r tring to open Access database which has password. to change the database at runtime u can use the following code in vb.My report using Direct Database file connection not oledb or others.

Report.Database.Tables.Item(1).Location = App.Path & "\" & dbName
Report.Database.Tables(1).SetSessionInfo "", Chr(10) & txtPass

if u have more then on table u can use loop.

Only show group header once per page.

Hi!

I have a main report with a subreport in it. My problem is I want to print the subreports 'report header' whenever the subreport encounters a new page. I didn't find a way to do that so I placed a group in my subreport. But I only want the 'group header' once per page even though the details of the subreport is printing several times per page. Is there a way to do this.

/HeleniusHey, here's how to make a fake pageheader for a subreport and print it on every new page...

http://support.businessobjects.com/library/kbase/articles/c2005103.asp