Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Database Connection

Database Connection

Thread began 7/08/2010 5:39 am by wayne.doherty252635 | Last modified 7/19/2010 12:01 pm by wayne.doherty252635 | 3320 views | 12 replies

7/08/2010 5:39 amwayne.doherty252635

Database Connection

Hi,

I am using DataAssist 2.0.7 and have connected to a SQL database.

When I search, this works correctly and brings back information.

When I click View I get the following:
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

The same for Update.

If I click Insert and type something in like WDDDD I get:
permission denied on object 'HICOMClinicsAndDoctors', database 'PASExtract', owner 'dbo'.

If I changed the database permissions to write then the error changes to:
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Thanks

Wayne

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.