Several months ago, I installed the SQL Server trial version in anticipation of doing more development work from home for my former employer. I went through the process of re-creating their database on my local server (with 100+ tables).
(by the way, you're not given any warning when your 120 day trial period is about to end, and once it ends, you're apparently SOL accessing those databases until you buy a version of SQL Server) I bought the Developer edition and installed it over the trial version. During that installation process, at the step when you're choosing "Windows Authentication" or "Mixed Mode" I couldn't recall which way I had done it before, so I chose Windows Auth. The install went seemingly ok. The CFMX Admin was still able to verify the DSN without any problems. However, when I go to a page on my machine to access a table, I get an "Invalid object name" for any table in the DB. I assume this is because I used Mixed Mode before and was using SQL Server authentication with a cf_user. I've gone into and changed the Server's registration to allow mixed mode to use SQL Authentication. The user logs in ok. I've changed the ODBC DSN info to allow the same thing. However, I still get "Invalid Object Name". Then, when I reload the page, I get: "The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null pointers are another name for undefined values." And, that seems to hose the entire server, forcing a restart. Any suggestions on how to fix this or what the real problem actually is? ------------------------------------------- Scott Brady http://www.scottbrady.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
