Try setting up the ODBC connection with the Windows Data Sources control panel first. If you get a good connection there, then it should with within the CF Administrator.
Use the SQL Client Configuration Utility to make sure you're using the correct network protocol and IP address. ---mark --- Thanh Nguyen <[EMAIL PROTECTED]> wrote: > Both are Win2k with SP 2. > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 09, 2002 1:04 PM > To: SQL > Subject: RE: ODBC Error Code = 08001 (Unable to > connect to data source) > > > what are you o/s for each server, including service > packs? > > At 12:52 PM 7/9/2002 -0700, you wrote: > >I tried both. Still got the error. > >and no It's not the same time everyday. > > > >thanks. > > > >Thanh > > > >-----Original Message----- > >From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > >Sent: Tuesday, July 09, 2002 12:45 PM > >To: SQL > >Subject: Re: ODBC Error Code = 08001 (Unable to > connect to data source) > > > > > >Are you using named pipes or TCP/IP? > > > > > > > > >At 11:47 AM 7/9/2002 -0700, you wrote: > > > > > > > >Hi all, > > > > > > > >Sorry for the double post here. > > > > > > > >I'm hoping someone in here haave an idea of > what could have caused this > > > >error. I'm trying > > > > > > > >Error Diagnostic Information > > > > > > > >ODBC Error Code = 08001 (Unable to connect to > data source) > > > > > > > >[Microsoft][ODBC SQL Server Driver][TCP/IP > Sockets]SQL Server does not > >exist > > > >or access denied. > > > > > > > >The error occurred while processing an element > with a general > identifier > >of > > > > > > > >(CFQUERY), occupying document position (74:2) > to (74:51). > > > > > > > >This error only occurs once or twice a day for > about 5 minutes, then it > > > >works again. > > > > > > > >Thanks > > > > > > > >Thanh Nguyen > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
