I've been running into some little issues in getting SQL Server 2000 and CFMX to run smoothly. After some searching I was finally able to get a dsn setup correctly(by using the ODBC Socket setting instead of the SQL Server setting).
Now my issue is in running a simple query. I keep getting 'Invalid object name' responses when querying tables that do exist and can be queried through SQL Query Analyzer, etc. Any ideas on what's going on? The DSN verifies correctly, but I can't access the DB. Any suggestions would be appreciated. Thanks. Mike Roberto ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
