Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: WIn32::ODBC - Can't call method "SqL" on an undefined value on XP machine

by jimbojones (Friar)
on Apr 06, 2005 at 21:38 UTC ( #445453=note: print w/replies, xml ) Need Help??

in reply to WIn32::ODBC - Can't call method "SqL" on an undefined value on XP machine


I suspect that you aren't connecting to the dsn correctly from your XP box. Hence, after the first line, the object $db is undefined. Something like:

my $db = new Win32::ODBC("dsn=A3T;UID=shenriks;PWD=changeme0"); die "Cannot connect to dsn A3T" unless ( defined $db );
or something like that. From the Win32::ODBC doc

Next, create a data connection to your DSN:

$Data = new Win32::ODBC("MyDSN");
NOTE: MyDSN can be either the DSN as defined in the ODBC Administrator, or it can be an honest-to-God DSN Connect String.

Example: "DSN=My Database;UID=Brown Cow;PWD=Moo;"

You should check to see if $Data is indeed defined, otherwise there has been an error.
(emphasis added).

Also, look into code tags for your posts. See this node 17558 for more details.

Updated: added link to writeup formatting node

- j

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://445453]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (6)
As of 2018-06-24 01:19 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (126 votes). Check out past polls.