> > > I am using the Microsoft Jet Engine to connect to the database > > > and I get this error.: > > > > > > CMemoryException: unknown cause > > > PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag > > > > > > > > > I had this before and I re-created the database and it worked > > > fine. I have since re-created this database 5 times and still > > > no luck. There is one table that is not working, no matter how > > > many times I start from scratch. > > > > any field types ntype? > > What you mean by ntype? (Sorry I am not an expert)....I > assume you mean number type.
In SQL Server, the data types NCHAR, NVARCHAR and NTEXT are Unicode string data types that can be used instead of the ASCII string data types CHAR, VARCHAR and TEXT, but you may occasionally run into issues with them. To solve your problem, you might find what's different between the table that isn't working, and those that are. You might also try running the same query that's failing through another query interface (typically, one comes with whatever database you're using). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
