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]

Reply via email to