Wednesday, March 7, 2012

Problem w/ SQL Server Database Wizard

I'm relatively new to VB.NET and Database programming, so I don't know a WHOLE lot about both, but I've recently purchased Wrox's "Beginning Visual Basic .NET Databases" and I've run into a snag on page 48.

The text says to fill in the Login ID and Password ("sa" and blank) on the first screen of the Microsoft SQL Server Database Wizard in Access, but when I do, I get an Overflow error. I get the same error if I try to Use Trusted Connection. I can't get past this screen.

I'm running Access 2000, and the SQL Desktop Engine 2000, and I don't have Enterprise Manager. Anyone know how to help me?

Please!!! Help me!!!Do you have latest service packs on SQL SErver and OFfice tools?|||No, I don't. Would I get those from Microsoft's site? (Damn, I hate navigating that website.)|||Hey, Satya, service pack 3 did the trick.

Thanks for the help.

Sean

No comments:

Post a Comment