Recent content by Neilf

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