(RADIATOR) Could not connect to SQL database

[Andrew Reeves]

DBD::Sybase appears to have solved the problem.

regards
Andrew

Frank Danielson wrote:

>You can test perl and the associated DBI/DBD modules with the dbish tool. It
>should be in the directory with your perl binaries.
>
>-Frank
>
>-----Original Message-----
>From: Andrew Reeves [mailto:andrew.reeves at sunbeach.net]
>Sent: Tuesday, June 14, 2005 8:29 AM
>To: radiator at open.com.au
>Subject: Re: (RADIATOR) Could not connect to SQL database
>
>
>Yes, the SQL FailureBackoffTime is being respected. Also, since I'm able 
>to connect with isql via unixODBC and freeTDS I'm thinking that rules 
>out freeTDS. I was wondering if it could be perl or one of the perl modules?
>
>regards
>Andrew
>
>Hugh Irvine wrote:
>
>  
>
>>Hello Andrew -
>>
>>This is likely to be a problem with freeTDS, but have you checked  
>>that the SQL FailureBackoffTime is being respected? By default  
>>Radiator waits for 600 seconds (10 minutes) before retrying the  
>>database. If the problem is indeed freeTDS, you may want to check if  
>>a different version runs better. Otherwise I suggest you run an  
>>instance of Radiator on Windows and proxy requests from the other  
>>machine to it.
>>
>>regards
>>
>>Hugh
>>
>>
>>
>>On 14 Jun 2005, at 06:48, Andrew Reeves wrote:
>>
>>    
>>
>>>Hi guys,
>>>
>>>I'm running Radiator 3.12 on CentOS 4, with perl 5.6.2, DBI::DBD,  
>>>DBD::ODBC, unixODBC and freeTDS.
>>>
>>>
>>>I have the following problem with radiator 3.12.
>>>
>>>After loss of connectivity to the MSSQL Sever 2000 radiator is  
>>>unable to connect after the connectivity is restored.. It logs the  
>>>following information:
>>>ERR: Could not connect to SQL database with DBI->connect  
>>>dbi:ODBC:datasource, user, password
>>>
>>>After connectivity is restored I can connect via isql but not  
>>>radiator. With radiator on Windows 2000 the problem doesn't occur.
>>>Has anyone experienced this before or have any suggestions?
>>>
>>>TIA
>>>Andrew
>>>
>>>-- 
>>>Archive at http://www.open.com.au/archives/radiator/
>>>Announcements on radiator-announce at open.com.au
>>>To unsubscribe, email 'majordomo at open.com.au' with
>>>'unsubscribe radiator' in the body of the message.
>>>
>>>      
>>>
>>NB:
>>
>>Have you read the reference manual ("doc/ref.html")?
>>Have you searched the mailing list archive (www.open.com.au/archives/ 
>>radiator)?
>>Have you had a quick look on Google (www.google.com)?
>>Have you included a copy of your configuration file (no secrets),
>>together with a trace 4 debug showing what is happening?
>>
>>    
>>
>
>--
>Archive at http://www.open.com.au/archives/radiator/
>Announcements on radiator-announce at open.com.au
>To unsubscribe, email 'majordomo at open.com.au' with
>'unsubscribe radiator' in the body of the message.
>
>--
>Archive at http://www.open.com.au/archives/radiator/
>Announcements on radiator-announce at open.com.au
>To unsubscribe, email 'majordomo at open.com.au' with
>'unsubscribe radiator' in the body of the message.
>
>
>  
>

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.