Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning Microsoft Visual Basic 2008 ISBN: 978-0-470-19134-7
This is the forum to discuss the Wrox book Beginning Microsoft Visual Basic 2008 by Thearon Willis, Bryan Newsome; ISBN: 9780470191347
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Microsoft Visual Basic 2008 ISBN: 978-0-470-19134-7 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 17th, 2009, 01:45 AM
Registered User
 
Join Date: Dec 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 16 - Accessing Databases error

Error message:
Could not retrieve schema information for table or view

i am doing the first part of chptr 16, no code is being written..
pg 546 try it out

I get the above error msg when I try to make the actual connection to the access database.. I can test the connection ok.. I can preview the data ok..
but when I try to populate the datagrid, it is blank...
I have downloaded the northwinds database multiple times...
I created a database - to eliminate the possible of a corrupt downloaded file.. and I get the same error...

Can you please explain how I can correct this error...
I did search the error.. and I can find no exact match. but a few close ones..
and they are all making repairs with lengthy code entries...

on a side note... when I download your chapter 16 code.. it runs...

This would not be funny, but, I am writing NO CODE.. to qoute your book
pg 548
<At this point you have not written a single line of code to achieve these results>

Seeing how I am new to this, I hope I provided enough detailed info to help you arrive at a working conclusion that will help me....

thank you
Larry
Reply With Quote
  #2 (permalink)  
Old January 31st, 2010, 01:59 AM
Wrox Author
Points: 333, Level: 6
Points: 333, Level: 6 Points: 333, Level: 6 Points: 333, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2006
Location: , , .
Posts: 91
Thanks: 0
Thanked 5 Times in 5 Posts
Default

can you find a text comparison tool like winmerge(free) and compare your project with the one you downloaded. If you can post the differences we should be able to pinpoint and fix.
Reply With Quote
  #3 (permalink)  
Old February 2nd, 2010, 11:22 AM
Registered User
 
Join Date: Feb 2010
Location: Pennsylvania
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Larry
I have same problem- did you ever solve it?
Bob
Reply With Quote
  #4 (permalink)  
Old February 3rd, 2010, 01:37 AM
Wrox Author
Points: 333, Level: 6
Points: 333, Level: 6 Points: 333, Level: 6 Points: 333, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2006
Location: , , .
Posts: 91
Thanks: 0
Thanked 5 Times in 5 Posts
Default

Bob, Can you post your connection string? Bryan
Reply With Quote
  #5 (permalink)  
Old February 3rd, 2010, 03:22 PM
Registered User
 
Join Date: Feb 2010
Location: Pennsylvania
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Bryan
The connection string is:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source= [Data Directory]\Northwind.mdb

When my DataViewGrid wouldn't populate I tried adding my own
record using the control and when I tried to save it
it gave me an exception and said that my Jet.OLEDB.4.0 was not registered-
I don't understand this since I use Access 2007 without any trouble
Thanks for your prompt reply and help
Bob
Reply With Quote
  #6 (permalink)  
Old February 3rd, 2010, 09:23 PM
Registered User
 
Join Date: Dec 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

sorry for the delay..
my laptop crashed and required parts for repair..
on my laptop, Yes it now works, but only after
a full reload... I am not sure why it failed prior..

I know this is not enough information to resolve this issue..
and it is not the answer I was looking for....

But the reload corrected this issue...

Larry
Reply With Quote
  #7 (permalink)  
Old February 4th, 2010, 12:46 AM
Wrox Author
Points: 333, Level: 6
Points: 333, Level: 6 Points: 333, Level: 6 Points: 333, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2006
Location: , , .
Posts: 91
Thanks: 0
Thanked 5 Times in 5 Posts
Default

Bob,

Have you downloaded the code from the wros site? If not, the link is at the top of this post. Try that example and see if it runs. Bryan
Reply With Quote
  #8 (permalink)  
Old February 4th, 2010, 03:04 PM
Registered User
 
Join Date: Feb 2010
Location: Pennsylvania
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Bryan
I downloaded your copy of Northwind Customers DatagridView but when I tried to open the project it gave me the following 2 errors
1- Could not load file or assembly "System.Data.DatasetExtensions, Version=2.0.0.0, Cultural=Neutral PublicKey= b77......89 or one of its dependencies. The system cannot find the file specified.

2- The variable "NorthwindDataSet" is either undeclared or was never assigned.

THanks
Bob
PS- I have worked through the first 15 chaps of your book and think it is great!
Reply With Quote
  #9 (permalink)  
Old February 6th, 2010, 01:18 AM
Wrox Author
Points: 333, Level: 6
Points: 333, Level: 6 Points: 333, Level: 6 Points: 333, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2006
Location: , , .
Posts: 91
Thanks: 0
Thanked 5 Times in 5 Posts
Default

Do you have .net framework 2.0 installed? Try to install that. You me be able to go to add reference and remove the reference to that version and add the reference to whatever version you had. That code definintely works so something is missing on your machine. Are you running windows 7?
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 16 Accessing Database Bruce A Smith BOOK: Beginning Microsoft Visual Basic 2008 ISBN: 978-0-470-19134-7 7 July 12th, 2009 01:19 PM
Error in Source Code in Chapter 16 Lcstyle BOOK: Beginning Linux Programming, 4th Edition ISBN 978-0-470-14762-7 1 February 28th, 2009 10:14 AM
Search Error Chapter 16 EgoGen BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 0 June 12th, 2008 03:36 PM
Chapter 16 forum - SQL error petefernando PHP Databases 3 October 22nd, 2007 07:13 PM



All times are GMT -4. The time now is 12:05 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.