> 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
