Help moving databases

[mtarby]

I'm migrating several SQL databases from SQL Server 7 to 2000. I noticed that everything moves well except any column type that is set to text or ntext.

Any text or ntext columns will cause my ASP pages to blow up, giving an error that says "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done"

Is this something I'm doing wrong with the SQL database? Does anyone have any troubleshooting suggestions? Also, if I should looking for help instead on the ASP front, let me know.

Thanks in advance.

Michelle

 

[nigelrivett]

Make sure you have the latest mdac on the iis server.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[mtarby]

We've got MDAC 2.7, SP 1 installed. Would that be causing the problem?

 

[nigelrivett]

Is that the refresh?

http://www.microsoft.com/downloads/...f2-cae7-493d-b0f3-ae36c570ade8&DisplayLang=en

It's what's installed with sql server so should be OK.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[mtarby]

I found a work around - apparently some versions of mdac get testy with text type (that part I knew!)

What worked for me was to list each column in the select statement (instead of select * ) and put the name of the column with the text value last...