I did download and install MDAC 2.7. What's in the Jet 4 SP3 package? I can't use the ODBC Socket, because I get all kinds of client variable errors when I do. I get a precision length error when using a MSSQL7 datasource and the ODBC Socket whenever my client variables grow beyond 17k. Other people DO NOT get this error. I even tried reinstalling to no avail.
I really don't understand how/why I can connect through the ODBC control panel to the remote datasource but not through CF. If any one can help on this I would be very grateful. I'm kinda screwed otherwise ;) Brook At 08:22 PM 18/09/02 -0400, you wrote: >Are you getting a java socket error? If so, try this from the MX >release notes: > >Microsoft Jet 4 SP3 >http://www.microsoft.com/data/download_Jet4SP3.htm >MDAC 2.7 >http://www.microsoft.com/data/download_270RTM.htm > >-----Original Message----- >From: Brook [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, September 18, 2002 8:29 PM >To: CF-Talk >Subject: Datasource using CFMX > > >I am at a total loss on this one. I've searched the forums with no >success >and this lists archives. > >I am trying to connect to a MSSQL Datasource on a separate machine from >the >CFMX administrator. I have set up and tested the connection using the >ODBC >control panel, and this works 100%. When I try through the CFMX admin >page >I get an error. I am using the SQl Server Datasource setting, not the >ODBC >Socket. SQL Server has a login specified and I am using that username >and >pass. The error says to check the username and password. I am sure the >info >is correct! > >I have tried removing the datasource entries from the jrun-resources >file >with no luck. I don't know what else to do at this point? Does any one >have >any suggestions? Please? :) > >I don't understand why it would work fine from the ODBC control panel >but >not through CFMX. > >Thanks for the help, god knows I need all I can get these days ;) > >Brook > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
