Search results for query: *

I've a large dynamic sql statement built in asp. I need to return an error (or anything) from within the exec sql statement. I've tried as shown below but return does not work within the string, and @@ERROR outside the exec statement reports no errors. I've been looking at the forum and the...

What can be returned from a sql execute command without a sp? I want to report an error if it occurs - ie if the transaction is rolled back. I've only had any success with the RecordsAffected property on the Execute method. My sql statement consists of multiple inserts, this only seems to...

I need to copy a large access db to SQL Server 2000 & want to copy the access import specs to SQL DTS packages. The spec data in access is held in the hidden system tables MSysIMEXColumns and MSysIMEXSpecs - is this data held in a similar manor in SQL Server? I'm guessing it must be somewhere...

I need to mail up to 700 email addresses (using a dynamic string from a recordset to get the addresses). If I use the mailto command nothing happens, as if the hyperlink goes nowhere. If I paste the string created into outlook it works fine & if i cut the string down to only contain a few...

MS article Q176377 suggests that integrated security can be used with SQL server 2000 if using kerberos security on 2000 server and that the workarounds described in that article & Q247931 do not apply. Should need to follow steps in this doc to get it to work...

I'm fairly sure this isn't possible but pls. let me know if i'm wrong! I need to trap the 'page cannot be displayed' error when a user submits a form (the users are working offline - when they submit it should reconnect and reload the same page - it doesn't if there's a problem with the line)...

Anyone know if there is any way of centering a form object on the screen when it gets focus? Some of our intranet users are new to windows and aren't too hot with scrollbars - i have a huge form for them to complete and anticipate problems! Thanks in advance.

Can anybody help with this error which is occurring intermitently when I connect to an Access97 db. Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xa70 Thread...

This problem affects 1 of 3 iis servers i've tested, I don't know much about iis, can anyone help: If I set integrated auth (iis5) for an asp page and then try to use the 'post' method to send data from it (and from any subsequent anonymous pages), the data is not passed. I have no problem if...

If i set the security of an asp page to nt challenge/response (IIS5), I cannot send info from a form on that page (& subsequent pages) using the 'post' method. It works fine with 'get' but thats no good to me in this instance. If i set the security back to anonymous i have no problem. Hope...

Just wondered if anybody knew why Ultradev changes your SQL statement by generating a replace function for a variable when creating a recordset, e.g: WHERE (tblLkpAreaManager.RegionID LIKE '" + Replace(rsList__varRegion, "'", "''") + "') It doesn't cause any...

I have set the properties of a single asp page to use integrated windows authorisation (on IIS5). This allows authorised users to get to subsequent pages which all have anonymous access in order to allow connnection to a SQLServer 2000 database using a single windows login. This all works fine...