I found my error. I had tried many times to get the DSN's I had created to verify correctly with the SQL Account I had setup, but every time it would return an error.
I had checked a ton of possibilities, but I just found the problem, it seems that when SQL2K was installed the server-wide security preferences defaulted to allow ONLY Windows Authenticated accounts, not SQL and Windows, so the SQL accounts I created were getting denied. I changed that setting and of course VIOLA! I can connect. Thanks. Mike Roberto -----Original Message----- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 8:21 PM To: CF-Talk Subject: Re: SQL Server 2000 and CFMX 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 > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
