Win32::ODBC-problem escaping "c:\new.mdb"

[BeemerBiker]

I tried the following that didnt work
"c:\\new.mdb"
'c:\\new.mdb'
"c:\\new\.mdb"

So far, the only thing that worked is "c:\\new" but I had to rename the destination access database to get rid of the .mdb

Here is a sql command that works just fine when giving it to the access wizard to execute as a query. It copies 3 columns from one database to another.

INSERT INTO AvailableCourses  ( [Course ID], Grouping, [Course Title]) 
IN "c:\\new.mdb"  
SELECT [Course ID],Grouping, [Course Title] 
FROM [Available Courses];
 

I then changed the above to do the following in perl:

$dbqS = "trainingdb.mdb";
$dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver (*.mdb);dbq='.
    $dbqS.'','','',{RaiseError => 1,PrintError=>1}); 
 
@AvailCourses = (
'INSERT INTO AvailableCourses ( [Course ID], Grouping, [Course Title]) IN "c:\\new.mdb"  SELECT [Course ID], Grouping, [Course Title] FROM [Available Courses];'
);
 
sub DoRunQueries {
    my(@queries) = @{(shift)};
    my($query);
    foreach $query(@queries) {
    $sqlcmd = $query;
           print "$sqlcmd\n";
    my $sth = $dbh->prepare($sqlcmd);
                $sth->execute();
    }
}
DoRunQueries(\@AvailCourses);
 

this is the output, note the "invalid bracketing.."

INSERT INTO AvailableCourses ( [Course ID], Grouping, [Course Title]) IN "c:\new .mdb"  SELECT [Course ID], Grouping, [Course Title] FROM [Available Courses];
DBD::ODBC::db prepare failed: [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[c:\new.mdb]'. (SQL-42000)(DBD: st_prepare/SQLPrepare err=-1)
 

A google of "invalid bracketing of name" gets a huge number of hits on problems with access databases. Maybe this is not a perl problem but I need an expert to tell me. Currently, I am renameing my destination database so it has no extension which is really a kluge.

[KevinADC]

did you try putting [] brackets around c:\new.mdb instead of double-quotes?

@AvailCourses = (
'INSERT INTO AvailableCourses ( [Course ID], Grouping, [Course Title]) IN [c:\new.mdb]  SELECT [Course ID], Grouping, [Course Title] FROM [Available Courses];'
)
 

[BeemerBiker]

solved: I needed single quote and that was the only one I didnt try :(

'c:\\new\.mdb' works

however I got a worse problem escaping the ":" but I will post it on a new thread

[eWish]

See my post in the other thread.

--Kevin