I'm sorry that I don't have an answer for your specific problem but I do have a comment. Using the ODBC socket is slower than using the JDBC connector. When I set it up I used the JDBC and set a new user for SQL2k with a specific password and limited access.
> 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 > > > ______________________________________________________________________ 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 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
