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");
>>
>>
>>
>>
