Wind32::ODBC question

------_=_NextPart_001_01CC569B.7B3902EB
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

All



I am using the Win32::ODBC module to connect to a Sybase database

I can connect fine, but when I run a query to retrieve some data I keep
getting the following error



[Sybase][ODBC][connection timed out]



Reading the ODBC documentation I tried to set the
'SQL_ATTR_CONNECTION_TIMEOUT' Attribute, but with no success

Has anyone run into this issue before?

Is there another setting that I can try to set to let my query complete?

Any help would be appreciated

Thanks in advancer



Robert Gorrebeeck
Sr. EDI Apps Dev Analyst

Coventry Workers' Comp Services
Solutions to Restore Health and Productivity
Office: (972) 473-2942

gorrebeeckra [at] cvty.com <mailto:gorrebeeckra [at] cvty.com>
www.coventrywcs.com <http://www.coventrywcs.com/>







Email Confidentiality Notice: The information contained in this transmiss=
ion is confidential, proprietary or privileged and may be subject to prot=
ection under the law, including the Health Insurance Portability and Acco=
untability Act (HIPAA).

The message is intended for the sole use of the individual or entity to =
whom it is addressed. If you are not the intended recipient, you are not=
ified that any use, distribution or copying of the message is strictly pr=
ohibited and may subject you to criminal or civil penalties. If you rece=
ived this transmission in error, please contact the sender immediately by=
replying to this email and delete the material from any computer.
------_=_NextPart_001_01CC569B.7B3902EB--
gorrebeeckra [ Di, 09 August 2011 15:51 ] [ ID #2063176 ]

Re: Wind32::ODBC question

On Tue, Aug 9, 2011 at 6:51 AM, Gorrebeeck, Robert
<gorrebeeckra [at] cvty.com> wrote:

> I am using the Win32::ODBC module to connect to a Sybase database
>
> I can connect fine, but when I run a query to retrieve some data I keep
> getting the following error
>
> =A0 =A0 =A0 =A0 =A0 =A0[Sybase][ODBC][connection timed out]

While I haven't used Win32::ODBC, I have used DBD::Sybase & DBI with
some success in the past. I just wanted to point that out in case you
don't receive any specific replies regarding Win32::ODBC.

Kevin.

--
To unsubscribe, e-mail: beginners-unsubscribe [at] perl.org
For additional commands, e-mail: beginners-help [at] perl.org
http://learn.perl.org/
Kevin Spencer [ Di, 09 August 2011 19:47 ] [ ID #2063198 ]
Perl » gmane.comp.lang.perl.beginners » Wind32::ODBC question

Vorheriges Thema: one simple perl module for authentication
Nächstes Thema: how to use jks encrypt in perl webservice