Re: DBD::ODBC won't read past a certain record

If it is an access DB (sounds like it) have you tried to do a Compact and Repair? I had a similar problem and it fixed it. I also, found that I got confused because I forgot that some records had been deleted and I had Autonumber turned on and wondered why the id didn't match the total number of records returned and it was obvious.. Access remembers the last highest number to auto-increment with... anyway... try the Compact and repair.. couldn't hurt :)

Comment on Re: DBD::ODBC won't read past a certain record

Replies are listed 'Best First'.
Re: Re: DBD::ODBC won't read past a certain record by Groll (Acolyte) on Aug 07, 2003 at 05:07 UTC
Sorry, but as stated in the original message, this is SQL Server.	[reply]
Re: Re: Re: DBD::ODBC won't read past a certain record by JamesNC (Chaplain) on Aug 07, 2003 at 13:17 UTC
Sorry, I had read so many of the posters I was focusing on what you said about verifying that the record was there via access which threw me off (it would be helpful to know which version of SQL Server you are running also 7.0?)... If running the same query using ISQL on your host server has the same failure, then you can verify that it is not the DBI or ODBC interface. Other than that, I would also try to see if M$ has updated ODBC drivers, or if you have the latest ones installed on the Server. Before you run off to Java, I would run a simple query using VB and and see if you get the same results...if you do.. then you can really point the finger at the DB. I built a DB with 1.2Million records... (sheese.. it took 30 mins - 1GB in size) and ran the same query... and it returned the records just fine. (Access however - I don't have MS SQL Server at home.) Only stuff I could think of. Good luck. JamesNC	[reply]