> No, becuase when I set up SQLServer, and installed CFMX7 > something went wrong and i can't connect to it using CF's > native drivers. Instead i have to set up a ODBC datasource > and connect to that.
Can you provide more detail about the something which went wrong? I think you'd be much better off fixing that thing than using ODBC. Here are some things which could go wrong when using JDBC to talk to SQL Server: 1. SQL Server needs to be set up to listen on TCP/IP. Named Pipes won't work with JDBC. 2. SQL Server needs to allow mixed-mode authentication, instead of just Windows authentication. Actually, you can set up Windows authentication, but to do this you have to run CFMX as a specific Windows user that can authenticate against the database server, but I would generally recommend that you use mixed-mode authentication instead. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
