Ask a Question related to Coldfusion Database Access, Design and Development.
-
BenDC #1
MSDE and Text Query Problem
Hello
My problem is simple enough and it seems there are some similar threads up
here.
I am connecting to a local (laptop) MSDE and local CFMX7 connected via ODBC
(not SQL driver).
When querying the DB, text/ntext fields are being returned as NULL (not
truncated, NULL) regardless if they have data or not. I checked the port setup
issue noted in these forums, and the port is set to 1433 and good.
What else should I look at?
Thanks in advance for ANY help!
Ben
BenDC Guest
-
Connecting to MSDE
I have just upgrade to CF MX 7 on my development laptop where I have MSDE installed. When I am in Cold Fusion Administrator it cannot verify the... -
Problem evaluating text from within a cfmail tag usingthe query parameter
Hi I'm trying to decrypt a string using text returned from a query and wondered if anyone knows what I need to do... I've tried adding <pre>... -
Use MSDE in application
Dear all I want to know that can i use MSDE as database server for deploying application. Is it necessary to buy any licence if I use MSDE as... -
DBs and SPs in MSDE installation
MSDE is a equevelant of the more powerfull SQL Server. Therefore looking for tables and storedprocedures in Access (=oledb) is not wath you aspect... -
MSDE/SP3 MemoryLeakage
I very much doubt it is a memory leak. Search this group for many similar queries, essentially SQL server will take almost all available memory and... -
BenDC #2 Re: MSDE and Text Query Problem
Ureka!
Solved it - switched to the native driver - was able to do this by going to:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn and running the SVRNETCN
program and enabling TCPIP, and making sure port was set to 1433 (it was so by
default).
BenDC Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
