Is that all? Right during the connect?
Jeff
>
> Hi,
>
> Download and installed MDAC 2.7. ODBC core now at 3.520.7713.0.
> VFP driver at
> 6.01.8629.01 which is the current release. Attempted to update
> VFP driver anyway
> but got the message "Visual Foxpro ODBC driver setup is not
> supported on Windows
> 2000 since it is already installed with the operating system.".
>
> Level 9 trace follows.
>
> As before, your help is appreciated.
>
> Tom
>
>
> C:\Inetpub\wwwroot\EDS2000>testodbc.pl
> DBI 1.201-nothread dispatch trace level set to 9
> Note: perl is running without the recommended perl -w option
> -> DBI->connect(DBI:ODBC:EDS2000, , ****)
> -> DBI->install_driver(ODBC) for MSWin32 perl=5.006001 pid=1852 ruid=0
> euid=0
> install_driver: DBD::ODBC version 0.28 loaded from
> C:/Perl/site/lib/DBD/ODBC.pm
> New DBI::dr (for DBD::ODBC::dr, parent=, id=)
> dbih_setup_handle(DBI::dr=HASH(0x1df742c)=>DBI::dr=HASH(0x1da6bf8),
> DBD::ODBC::dr, 0, Null!)
> dbih_make_com(Null!, DBD::ODBC::dr, 92)
> dbih_setup_attrib(DBI::dr=HASH(0x1da6bf8), Err, Null!)
> SCALAR(0x1db031c)
> (already defined)
> dbih_setup_attrib(DBI::dr=HASH(0x1da6bf8), State, Null!)
> SCALAR(0x1db0364)
> (already defined)
> dbih_setup_attrib(DBI::dr=HASH(0x1da6bf8), Errstr, Null!)
> SCALAR(0x1db0340)(already defined)
> dbih_setup_attrib(DBI::dr=HASH(0x1da6bf8), Handlers, Null!)
> ARRAY(0x1da6b74)
> (already defined)
> dbih_setup_attrib(DBI::dr=HASH(0x1da6bf8), Debug, Null!) 0
> (already defined)
>
> dbih_setup_attrib(DBI::dr=HASH(0x1da6bf8), FetchHashKeyName,
> Null!) 'NAME'
> (already defined)
> <- install_driver= DBI::dr=HASH(0x1df742c)
> >> connect DISPATCH (DBI::dr=HASH(0x1df742c) rc1/3 @5 g0
> a1db49a8) at
> C:/Perl/site/lib/DBI.pm line 474 via
> C:\Inetpub\wwwroot\EDS2000\testodbc.pl line
> 4
>
> -> connect for DBD::ODBC::dr
> (DBI::dr=HASH(0x1df742c)~0x1da6bf8 'EDS2000' ''
>
> **** HASH(0x1abf0b4))
> New DBI::db (for DBD::ODBC::db, parent=DBI::dr=HASH(0x1da6bf8), id=)
> dbih_setup_handle(DBI::db=HASH(0x1da6ba4)=>DBI::db=HASH(0x1da6b68),
> DBD::ODBC::db, 1df7180, Null!)
> dbih_make_com(DBI::dr=HASH(0x1da6bf8), DBD::ODBC::db, 92)
> dbih_setup_attrib(DBI::db=HASH(0x1da6b68), Err,
> DBI::dr=HASH(0x1da6bf8))
> SCALAR(0x1db031c) (already defined)
> dbih_setup_attrib(DBI::db=HASH(0x1da6b68), State,
> DBI::dr=HASH(0x1da6bf8))
> SCALAR(0x1db0364) (already defined)
> dbih_setup_attrib(DBI::db=HASH(0x1da6b68), Errstr,
> DBI::dr=HASH(0x1da6bf8))
> SCALAR(0x1db0340) (already defined)
> dbih_setup_attrib(DBI::db=HASH(0x1da6b68), Handlers,
> DBI::dr=HASH(0x1da6bf8)) ARRAY(0x1da6b74) (already defined)
> dbih_setup_attrib(DBI::db=HASH(0x1da6b68), Debug,
> DBI::dr=HASH(0x1da6bf8)) 0
> (already defined)
> dbih_setup_attrib(DBI::db=HASH(0x1da6b68), FetchHashKeyName,
> DBI::dr=HASH(0x1da6bf8)) 'NAME' (already defined)
> Driver connect 'EDS2000', '', ''
>
> Jeff Urlwin wrote:
>
> > You probably are not doing anything wrong, but check your
> driver. Microsoft
> > has the MDAC 2.7 out, I believe and that may have a more up to
> date driver.
> >
> > Your SQL statement is pretty plain vanilla. If updating your
> driver doesn't
> > work, set the tracing level to 9 and post here.
> >
> > Thanks,
> >
> > Jeff
> > >
> > > Hi,
> > >
> > > I'm a Perl Newbie and I'm having problems trying to use DBD with my
> > > Visual Foxpro free tables on Win2K. Here is the code:
> > >
> > > use DBI;
> > > #$dbh = DBI->connect('DBI:ODBC:ESLMI04','sa','price'); # SQL 6.5
> > > works!!!
> > > $dbh = DBI->connect('DBI:ODBC:EDS2000','','') or
> > > die $DBI::errstr; ; # Visual Foxpro free table,
> > > $sqlstatement="SELECT * FROM areatype";
> > > $sth = $dbh->prepare($sqlstatement);
> > > $sth->execute ||
> > > die "Could not execute SQL statement ... maybe invalid?";
> > >
> > > while (@row=$sth->fetchrow_array)
> > > { print "@row\n" };
> > >
> > > #$dbh->disconnect;
> > >
> > > It retrieves the data but I'm getting a message box "The
> instruction at
> > > 0x...(changes each execution) referenced memory at 0x0000004. Memory
> > > could not be written. Click on OK to terminate the program, click on
> > > CANCEL to debug the program."
> > >
> > > I created an identical table on M$ SQL Server 6.5 and it seems to work
> > > fine.
> > >
> > > Win2K Pro SP2, ODBC core version 3.520.7430.0, VFP driver
> 6.01.8629.01,
> > > DBD-ODBC 0.28, DBI 1.201
> > >
> > > What am I doing wrong?
> > >
> > > Any and all help is most appreciated!!!
> > >
> > >
>
>
