(RADIATOR) Could not connect to SQL database

[Andrew Reeves]

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.