You should try using the MS-SQL Server JDBC type IV driver from the CFMX administration. This is faster than ODBC. If still want to use ODBC with SQL Server.. u will have to use the ODBC-Socket options in CFMX.
Joe > -----Original Message----- > From: Brook Davies [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 8:30 PM > To: CF-Server > Subject: Datasource Connection CFMX / MSSQL7 > > > Hi, I'm having this problem which I have been unable to resolve for days. > Maybe some one here can help, I hope :) > > I am trying to connect to a mssql7 datasource on a networked machine from > another machine with CFMX. Using the ODBC control panel, I can successful > set up and test the datasource, works fine. I am using sqlserver > authentication, not windows. > > When I try to set up the same datasource in CFMX, using the same > parameter > I can not get a connection. I get an error in JDBCPool which is fairly > unspecific. > > Why can I connect using the ODBC control panel and not via CF? > > Thanks for the help :) > > Brook > > > ______________________________________________________________________ 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 ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
