Thanks everyone for your replies and the link: very helpful!

I did not mention that all tables have primary keys (of course) so they...

Depending how you're implementing it, yes you could write a script to change the sa password and create a new login, and run that at the end of setup.

I advise...

Assigning a blank SA password is considered bad practice.  Is there any specific reason why you need to do this?

Better practice would be to assign an SA password (and restrict...

According to the EULA, there's no difference.  "You may install and run any number of copies of the Server Software on a single Server."

As you suggested, I phoned them, and...

Aha, so it's a licensing issue and not a technical one (i.e. with Standard Edition you can install up to 16 instances with one processor but you'd need 16 licences). ...

I thought of that but due to the nature of the setup, I can't do it, as the people I need to lock out are administrators and I can't deny...

Good idea, I've tried it but unfortunately it's not working.  Same error message.

That means it must be an overflow with the OLE DB provider and not SQL Server?

It doesn't look like I've solved the date issue.  I am getting the following error back from the load procedure:

Server: Msg 7341, Level 16, State 2, Procedure...

Thanks!  I'll review the SQL Server side against the field widths in Progress and change SQL side as necessary.

Having said that I want to limit time spent working with Progress as there...

I've implemented the casting option and it's worked - thanks!

I solved this by moving the Set objVariable = Nothing statements to the very end, rather than destroying them as and when I no longer needed them throughout...

http://dictionary.reference.com/search?q=humor