CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Win32 Programming Help:
Help with Win32::ODBC

 



fancy_pants
New User

Dec 11, 2007, 3:13 PM

Post #1 of 3 (5908 views)
Help with Win32::ODBC Can't Post

Greetings all,

This is my very first perl script and I'm having a little trouble with using the Win32::ODBC module. I think the module is installed correctly. I ran the test.pl script that came in the download and the odbc connection I want to use is listed there. I've played around w/ my code quite a bit and it always results in diffrent errors (although they seem to be the same rootcause). Here are some sample script and errors:

use Win32::ODBC;
$db = new Win32::ODBC("casql100");
$db->Sql("SELECT * FROM Blah);
$db->Close();

Can't call method "Close" on an undefined value
Can't call method "Sql" without a package or object reference

Any help or guidence is appreciated. Thanks.


Kanji
User

Dec 11, 2007, 6:14 PM

Post #2 of 3 (5907 views)
Re: [fancy_pants] Help with Win32::ODBC [In reply to] Can't Post

Error checking should help reveal the problem:-


Code
use Win32::ODBC; 

$db = new Win32::ODBC("casql100")
or die Win32::ODBC::Error(), "\n";

--k.


fancy_pants
New User

Dec 12, 2007, 8:56 AM

Post #3 of 3 (5903 views)
Re: [Kanji] Help with Win32::ODBC [In reply to] Can't Post

Yes sir, I acutally figured that part out late yesterday and found that it was sending a null username and password. I changed "$db = new Win32::ODBC("casql100")" part to include that info and it connects fine now.

I guess my follow up question is why isn't it using the L/P that I have specified in the ODBC connection?

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives