I'm testing AppWizard against the sample database (Northwind) made available
with the MSDE version
of MS-Sql Server 2000. I selected only the table "Employees". When I run the
resulting app, it fails
with an error like:
Dabo Error Log: Wed Apr 16 19:44:40 2008: Database Execution failed with
response: internal error:
SQL Server message 4004, severity 16, state 1, line 1:
Unicode data in a Unicode-only collation or ntext data cannot be sent to
clients using DB-Library
(such as ISQL) or ODBC version 3.7 or earlier.
DB-Lib error message 10007, severity 5:
General SQL Server error: Check messages from the SQL Server.
I traced this to these specific fields
## gek: removed lines
## ("Photo", "?", False, "Employees", "Photo"),
## ("Notes", "M", False, "Employees", "Notes"),
which are of types "image" and "ntext", respectively, in MSSQL.
My question: Is this a problem with how AppWiz handles these fields (I hope
so!) or is it deeper, with
an inability of DB-Lib to pass the values (as a literal reading of the error
message would indicate)?
Gary
--
View this message in context:
http://www.nabble.com/AppWizard-with-MS-Sql-Server-tp16736958p16736958.html
Sent from the dabo-users mailing list archive at Nabble.com.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]