Search results for query: *

I'm using classic ASP/VBScript and want to call secure FTP (PSFTP) to transfer a file. When I open the page it just hangs. My IIS uses an internet guest account called xxx. I have verified that: - the PSFTP command is constructed correctly - the PSFTP command runs without error from the command...

Hi, I have an access database with security enabled so that the Admin user can't open it. However, I can't point Word's mailmerge at the database now. Is there a setting in word that I can put in a userid/password, or set a connection string to the database so that Word can access the database.

Hi, I have a form (based on TableA) with two sub forms. Each sub form is on a different page of a tab control. Each subform is based on TableB. So when the user types in something in the first sub-form, a record is created in TableB. Then when they switch to the second sub-form, they edit that...

I want to disable detailed error messages being sent to the user. I've changed a setting in IIS (Home Directory-Configuration-Debugging) so that a specific message is to be sent to the user. However this doesn't seem to be taking effect. I have commented out any "On error resume next" and...

Sorry if this is in the wrong forum, but I think it's an ASP problem... I have a website that uses session variables. It has started behaving erratically in that session variables seem to get 'lost'. There is no clear logic as to when they do this and in some cases the session variables can be...

Hi, I hope I have the right forum. I'm using BO v5.1.7, and it links to a database built in SQL Server 2000. I'm going to migrate this database to SQl Server 2005. The tables and views which Business Objects reads from will not be changed w.r.t. structure, data-types, field names etc. Does...

Hi, I want to do something very straightforward - I want to have two installations of Business Objects on one machine. The machine in question already has a version of Business Objects (reporter) on it using distribution througha repository, requiring the user to log in when opening Reporter. I...

Hi, I want to do something very straightforward - I want to have two installations of Business Objects on one machine. The machine in question already has a version of Business Objects (reporter) on it, but it was set up by a previous contractor and is highly secured. I don't want to disrupt any...

Hi, I hope I have the right forum. My question is on Business Objects Designer, to which I am new. I am setting up a universe, which seems straightforward enough. However, say I have two tables, Table1 and Table2 which are joined by a left outer join, i.e. I want to return the records in Table1...

Hi I want to create a stored procedure which will check a directory, see if there are files in it and if so, will return the filenames. I know I can do it through Access but is there a way to do it from SQL Server, something similar to xp_cmdshell perhaps?

Hi, I hope this is the right forum. I have an Access 200 database as a client to a SQL Server database. I have a form based on a linked table. However, sometimes when I update one of the fields (e.g. select from a combo box), the screen refreshes and displays the value before I made a selection...

Hi, I hope this is the right forum. I have an Access 200 database as a client to a SQL Server database. I have a form based on a linked table. However, sometimes when I update one of the fields (e.g. select from a combo box), the screen refreshes and displays the value before I made a selection...

Hi, I want to run a delete query from a data access page. I am trying: MSODSC.execute "qryDeleteUserSelection" but am getting an 'invalid argument' message. Any ideas? Thanks.

Hi I'm new to VBScript, so this is probably a very simple issue. I've created a Data Access Page in Access 2000, and it uses 4 tables to group data into a hierarchy. I have a command button at one of the levels, which on clicking will retrieve the record the user is currently on. In order to do...

Hi, I have some code which clones a form's recordset and then adds a record to it using DAO .AddNew. I want to retrieve the ID of the record just updated (it's an identity column in a linked SQL Server view) So I have code which looks like this: dim sNewRec as string rs.AddNew...

HI, I've built a form which gathers user criteria and from this builds a WHERE clause which is passed to the OpenReport method of DoCmd: DoCmd.OpenReport "rpt001", acViewPreview, , sReportCriteria where sReportCriteria denotes the string containing the user criteria. This works fine, except...

Hi, I am using xp_readmail & xp_sendmail to send emails to users from SQL Server. Is there any way I can see the emails sent by xp_sendmail other than looking through the email client? I am looking for a way to view them through SQL. Thanks.

Hello I have some reports which were set up in Landscape mode. The first time they are previewed/printed they print correctly in Landscape, after that they switch to Portrait, without any intervention. Does anyone know if this a known bug or is there a work-around to it? There is nothing out of...

This may belong in the Queries forum ... but my problem is I have an INSERT statement which is built from the entries the user has selected from the form. It works most of the time, but occasionally it won't run the INSERT properly, but doesn't generate an error message. I've set a breakpoint in...

This is probably a very basic question, but how do you make getdate() display seconds as mine shows: Jan 10 2003 3:47PM Thanks in advance