I'd be careful about MDAC 2.7. I started getting GPFs when using DBI to a SQL Server. I had to reinstall the OS to iron it out. Anyone else have similar problems with MDAC 2.7?
-tom ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Tom D. Bullers - Network Engineer University of Iowa Health Care Telecommunications Services 200 Hawkins Dr. C-132 GH Iowa City, IA 52242 voice: (319)384-9762 fax: (319)384-8777 mailto:[EMAIL PROTECTED] > -----Original Message----- > From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 28, 2002 11:48 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: ODBC using VFP driver - Memory could not be written > > > 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!!! > > > > >
