I keep getting this error using a dsn connection but not with a OLEDB connection string. It does not allow me to insert into a table within my DB. Any help is greatly appreciated!

Microsoft VBScript runtime error '800a01a8'

Object required: ''

/LoopMX_Remote/Compound/Confirm.asp, line 105


Michael Rudge

usually problems like this relate to permission-probs. make sure you not only set the correct permissions in iis but give the ntfs-permissions too.

should sweep the probs away...

That is what I initialyy thought also, but it allows inserts to all other tables in the db... and when I switched to a dsn-less connection it disappeared... are permissions altered based on the connection type?

Michael Rudge

It seems that this is a feature of UD if you set up your site with a DSN and later change it to DSN-less it just will not work, you have to start all over again.

dave

Actually guys, an expert in ASP/VB that works for the company I work for told me it is due to the version of the MDAC. I think this maybe right... as for switching between dsn and dsn-less I do it all the time and this is the first problem I have had. I have however been having a ton of problems with the hosting company I'm using so I'm thinking MDAC. It has to be a server issue because on my local test machine it was ok...


Michael Rudge