I had a lot of trouble trying to get VB.NET/MDSE and IIS to talk to eachother, but I got it happening.

First I downloaded a free application called "DBAMgr2K" that acts as an interface for MSDE. Secondly, I got on the phone with a (new) friend who helped me configure MSDE (with "DBAMgr2K") and hook up the pubs database so I could open it with the string above. I can now connect successfully. I verified the connection is being made with a 'try/catch' and the immediate/command window. Life is good.

New problem: Now when I run the code, it runs just fine up to the line "MyDataAdapter.SelectCommand.ExecuteNonQuery() ", then I get the error, "Invalid object name 'authors'" . . . which is the table I'm trying to get at in the pubs database! I even downloaded the code for the same program off the Wrox website and it does the exact same thing . . . won't access the tables inside the pubs database.

I've seen references all over the web regarding this error message, but no solutions. Anybody out there in Wroxland ever had to fix this one?

Thanks again!

Dana

Something I should have added to the above novel: The piece of code the program bombs out on is:

MyDataAdapter.SelectCommand.ExecuteNonQuery()

Regards,

Dana