The suggestion below helped, AND I was passing in an application password instead of a database password. Once you send in the right data, things work surprisingly well.
Thank you, everyone. -----Original Message----- From: BAO RuiXian [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 3:46 PM To: Laurie Vien; [EMAIL PROTECTED] Subject: Re: Can't call Sql on an undefined value ... Please keep on the list. Laurie Vien wrote: >Yup, I did that next, and it now tells me "default username not supported". >I'm not sure what default username it's referring to. (Thank you....) > > I have not used Win32:ODBC much, and not sure you have the right syntax. Maybe you can try the syntax $db = new Win32::ODBC("DSN=MP2;UID=LAURIEV;PWD=MYPSWD;"); suggested by another Fernando Luna. Best Bao >-----Original Message----- >From: BAO RuiXian [mailto:[EMAIL PROTECTED] >Sent: Thursday, March 04, 2004 2:03 PM >To: Laurie Vien >Cc: [EMAIL PROTECTED] >Subject: Re: Can't call Sql on an undefined value ... > > > > >Laurie Vien wrote: > > > >>I just wrote a few lines of Perl to try to access an Oracle database via >>Win32::ODBC. Running this code results in the error "Can't call method >>"Sql" on an undefined value at line 6". Line 6 is the line containing the >>SELECT statement. >> >> >> >> >Usually the error message means connection fails. Can you add a 'or die >"...." to your connection string to check it? > >Best > >Bao > > > >>Here's the code--what's the problem?: >> >>#testchunk.pl >>use Win32::ODBC; >> >>$db = new Win32::ODBC("MP2", "LAURIEV", "MYPSWD"); >> >> >> >>
