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...

Thanks i'll check it out!

Ok Thanks - I normally do use cdonts but the user wants to use Outlook. They're happy to paste the addresses from a textfield so all is fine, if a bit messy.

I think the restriction is the string length - i guess the same restrictions that apply to using 'get' to processing a form.

Thanks for that - i was thinking along those lines - its going to be messy though as my sql string can be of infinite length (well i guess i can put some restriction on it - its for a dynamic survey result insert, the surveys can be a bit lengthy - the string i just tested was almost 22000...

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...

Thanks for the advice - i've just found the dts tables in sql and i think you're right i can't see anything which looks the same as the access spec data but i'll keep trying. The reason i want to copy the specs is that they are for many undelimited text files with about 100 columns in each, so...

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...

Sorted this out using javascript to open another page on the server in a new hidden window and then checking something in it (e.g title) to make sure it has loaded OK (use setInterval or setTimeout to give it time to load). If OK then submit the form. :-)

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.

I have now - still no difference, i'm going to have a play around moving everything to my local machine to try & eliminate any security issues. Failing that, the only reason its in Access is because it was originally a stand alone app., I'd like to migrate the whole backend to SQLServer!

Thanks G & Paul, unfortunately I don't think its that simple. All recordsets are closed at the end of each page (well 1 wasn't but I've changed that now & the error still occurs). I've checked and can't see the .ldb remaining. I've been looking on Microsoft's support pages & I think the...

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...

Tried this on another iis server and don't have any problem so this is in the wrong forum! If anyone does know why this is happening please let me know though.

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...