we had the same issue and for some reason if we do a ping from the database
server to the CF server then it will connect... I have no idea why though.
Tom
----- Original Message -----
From: "Todd Ashworth" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 10:39 PM
Subject: Re: Serious issues with connectstring causing CF server threads to
hang
> > Here is what I would do.
> > Pop in another NIC, assign it a IP
> > on the same subnet as the 2000 server,
> > and make the connection via TCP/IP.
> >
> > I once had a similar problem, and this fixed it.
> > I also did this as a last, hopeless resort....and BOOM !
> >
> > I also got a connection to the DB, but it
> > timed out due to "high traffic"....
> > it was as if some of the return packets
> > was going out on the IP and not back to the LAN.
>
> This is a possibility since I have a linux box doing NAT for the private
IPs
> and the Linux box's default gateway and route out are different than the
CF
> servers, but then again, why would it be only happeneing with the error
> message that a connection to the database could not be made. Any other
> database error (such as table not found, column not found, "you do not
have
> permission to access blah blah blah") doesn't cause this problem and CF
> displays normal error messages, and database connections with no errors
> return expected data.
>
> I will try the TCP/IP on Monday, though. I just needed to finish building
> the cluster and the rest of the production environment today before
> switching the database parameters.
>
> Todd
>
> > -----Original Message-----
> > From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, July 26, 2001 4:59 AM
> > To: CF-Server
> > Subject: Serious issues with connectstring causing CF server threads to
> > hang
> >
> >
> > I have posed this question on CF-Talk and on the Forums and even opened
a
> > ticket with Macromedia tech support, but I still don't have an answer.
> Tech
> > support is still working on a resolution (if there is one), but after 16
> > months of development, we are ready to deploy this app. for Beta testing
> and
> > this show-stopping problem is really throwing off our schedule. It is
soo
> > frustrating to finish a long project only to be held up at the last
moment
> > by a problem that can't be developed around! I'm hoping someone on the
> > cf-server list might have some ideas.
> >
> > Here we go ...
> >
> > I am using connectstring to connect to a Saybase database. I can normaly
> get
> > the queries to run fine, but if anything in the connectstring is wrong
to
> > the point that it causes CF not to be able to connect to the database,
the
> > current thread hangs 'permenantly'.
> >
> > This is a very serious problem for me because the application I am
> > developing *has* to use connectstring. There is no way around it, that I
> > know of. Also, end users will be providing some of the parameters that
> make
> > up the connect string, so the likelyhood of failed connection attempts
is
> > _very_ high. This could eaily kill performance on the server enough to
> make
> > the program unusable within a very short time (seconds even).
> >
> > Here's my setup:
> >
> > CF Server is running on NT 4.0 SP 6 using IIS 4.
> > The database engine runs on Windows 2000 Pro SP 2.
> > The database is Sybase ASA 7.02
> > The 2 machines communicate via NetBIOS (the CF server has a public IP
and
> > the database server has a private one)
> >
> > I pretty sure that the error has something to do with ColdFusion. The
> > database doesn't lock up in any way and actually returns an error
message
> > saying that the database connection attempt failed. The CF machine
> actually
> > recieves the error because we can log it in the datasource log we set
up.
> > ColdFusion is just missing this, or something.
> >
> > Here is the debug info from the datasource on the CF machine which
> includes
> > the connectstring (The invalid data in this connectstring is the
password)
> > .. notice the CONN messages:
> >
> > -----
> > Wed Jul 18 2001 11:01
> > CONN: Application information:
> > "HOST=BUSINESSSAFE;OS=Windows NT 4.0 (Service Pack
> >
>
6);PID=0x5d;THREAD=0xc9;EXE=C:\CFUSION\bin\cfserver.exe;VERSION=7.0.2.1402;A
> > PI=ODBC"
> > CONN: Attempting to connect using:
> >
>
UID=3;PWD=******;DBF=e:\databases\gymtime\16.db;ENG=Saber;CON=SQL_DBC_4889cf
> >
>
8;ASTOP=YES;INT=NO;CBSIZE=4096;DBG=YES;LTO=10;LOG=c:\gymbob.log;DMRF=NO;LINK
> > S=netbios
> > NetBIOS -- Trying connection on lan adapter: 1
> > NetBIOS -- Looking for name on lan adapter: 1
> > NetBIOS -- Found name successfully on lan adapter: 1
> > NetBIOS -- Trying connection on lan adapter: 1
> > NetBIOS -- Found session connection on lan adapter: 1
> > CONN: Connected to the server
> > CONN: Database is running, but could not connect to it
> > -----
> >
> > So, as you can see, the CF machine is being notified that the connection
> > failed, it's just that CF doesn't seem to be getting the hint. The
> > connectstring is 100% correct, except for the password, which I inserted
> > incorrectly on purpose to generate the error. If the correct password is
> > provided, the connection is made and the query runs and the results are
> > returned .. everything performs perfectly.
> >
> > After further testing, I found that it does NOT have to be the
> connectstring
> > that is wrong. I moved the uid and pwd out of the connectstring and into
> the
> > username and password attributes of the <cfquery> tag. Now, if I provide
> the
> > wrong password, the connectstring is 100% correct, but I still get the
> hung
> > thread. This makes me think that anytime there is *any* type of database
> > error while using the connectstring attribute, I will get a hung thread.
I
> > haven't tested this on access or SQL Server yet, though.
> >
> > I've included the query that I am calling.
> >
> > <cfquery name="qryValidateLogin" datasource="#Request.mainDSN#"
> > username="#qryGetUserID.contactPK#" password="#Attributes.txtPassword#"
> >
>
connectstring="dbf=e:\databases\gymtime\#Client.dbID#.db;eng=Saber;links=net
> > bios;">
> > SELECT 1
> > FROM dummy
> > </cfquery>
> >
> > I have tried using every "timeout" method available on all of the
> machines,
> > but the thread still hangs 'permenantly'.
> >
> > This is what I get in my application.log file, but I never get this
error
> on
> > the screen:
> >
> > -----
> > Mozilla/4.0 (compatible; MSIE 6.0b; Windows NT 5.0; COM+ 1.0.2204), ODBC
> > Error Code = 08S01 (Communication link failure) [Sybase][ODBC
> > Driver][Adaptive Server Anywhere]Communication link failure:
Communication
> > errorDate/Time: 07/18/01 10:59:53
> > -----
> >
> > Here is what I get in my server.log file:
> >
> > A request exceeded the timeout. The unresponsive thread count is up to
1.
> > [C:\Inetpub\wwwroot\gymtime_2\index.cfm]
> >
> > 2001-07-18 11:03:05 Error 202
> >
> >
> > !! CFTrace::logThread(201) has no entry for thread 201
> >
> > 2001-07-18 10:59:53 Warning 199
> >
> >
> > Template: C:\Inetpub\wwwroot\gymtime_2\index.cfm, Ran: 1977 seconds.
> >
> > 2001-07-18 10:59:53 Error 201
> >
> >
> > Error number 232 occurred attempting to close connection to web server.
> >
> >
> > 2001-07-18 10:59:53 Error 201
> >
> >
> > Windows NT error number 232 occurred.
> >
> > 2001-07-18 10:59:53 Error 201
> >
> >
> > Windows NT error number 232 occurred.
> >
> > 2001-07-18 10:59:53 Error 201
> >
> > Error number 232 occurred while attempting to write the reply to the web
> > server.
> > -----
> >
> > and I just have pages of this in my webserver.log file:
> >
> > -----
> > Request canceled or ignored by server Server busy or unable to fulfill
> > request. The server is unable to fulfill your request due to extremely
> high
> > traffic or an unexpected internal error. Please attempt your request
again
> > (if you are repeatedly unsuccessful you should notify the site
> > administrator). (Location Code: 26)
> > -----
> >
> > Does anyone have ANY ideas?
> >
> > Todd
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
