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!!!
> >
> >
