Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

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

Hi

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


Comment on Re: WIn32::ODBC - Can't call method "SqL" on an undefined value on XP machine
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://445453]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (8)
As of 2014-08-27 23:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (253 votes), past polls