Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-14 : 14:06:50
|
Steve writes "I have building asp pages based on Access databases behind my web sites. I am in the process of upgrading these databases to MsSQL7. I have successfully "upsized" my Access database, and made minor changes on my asp pages. However Access "Memo" fields are converted to "ntext" datatype in SQL Server. MyASP pages return this error whenever they try to insert text from such a field:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/welcome.asp, line 59
I heard that elsewhere thatthere are issues in upsizing msAccess memo fields. Any help would be appreciated.
My SQL7 database is running on Windows 2000 server, with IIS. However, I am using windows 98 desktop version of sql enterprise manager to access the server." |
|
|
|
|
|
Upsizing Access Memo fields to SQL7