Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re^3: SQL err in WIN32

by WhiteBird (Hermit)
on Jul 31, 2004 at 15:27 UTC ( #378930=note: print w/replies, xml ) Need Help??


in reply to Re^2: SQL err in WIN32
in thread SQL err in WIN32

I'm glad to see that EdwardG nailed the problem for you. I wasn't pulling any errors at all, but I didn't have a space in my table name. I avoid spaces in names at all costs. Just out of curiosity I renamed my table with a space in the name and I pulled up the 1305 error. In detail it reads:

error submitting SQL statment [-1305] [1] [0] "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'CODE'. Make sure it exists and that its name is spelled correctly."

Which points directly to my table which is named "CODE CODE". Just FYI for future reference.

Replies are listed 'Best First'.
Re^4: SQL err in WIN32
by Robertn (Hermit) on Aug 01, 2004 at 20:45 UTC
    Hi,My problem is I'm not getting any of the Microsoft message, just the numbers. If you've an opportunity, could you check the versions you have of the DB packages, aginst what I posted, I still think I may not have everything I need, or their not current. Or maybe I installed in an improper sequence. I'm getting errors now when I try to read the data using
    while ($db->FetchRow() ) { @Data= $db->Data( 1 ); }
    which should just get the first column, but I get this error sequence for every record.
    Use of uninitialized value in array element at C:/Perl/lib/Win32/ODBC.pm line 257.
    Use of uninitialized value in substitution (s///) at C:/Perl/lib/Win32/ODBC.pm line 256.
    Use of uninitialized value in substitution (s///) at C:/Perl/lib/Win32/ODBC.pm line 256.
    Use of uninitialized value in substitution (s///) at C:/Perl/lib/Win32/ODBC.pm line 256.
    Use of uninitialized value in substitution (s///) at C:/Perl/lib/Win32/ODBC.pm line 256.
    Use of uninitialized value in concatenation (.) or string at C:\Alpine\Laia_2.pl line 51.
    Line 51 being Fetchrow. Of course there maybe a problem with the data base, but everything is supposed to be stright text. Also tried using examples found at http://www.roth.net/perl/odbc/docs/ODBC_Docs.htm# for Data and Datahash, but keep getting similar errors. Of course some of those column names are names with spaces in them, so that might be yet another problem. And I thought this would be easier than figuring out visual basic. Thanks again for your time and help.
      I'm running an older version of ActiveState Perl on W2K, version 5.6.1.
      My DBD::ODBC is 1.05 and DBI is 1.37.

      You probably don't want to drop back to an older version.

      I've seen the concatenation error before when I've had troublesome data in a database--but that doesn't necessarily mean that you're having the same problem. Are you able to directly view the data you're trying to pull?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (2)
As of 2022-05-21 07:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (76 votes). Check out past polls.

    Notices?