I was going through the tutorial and when I was in the Business Object Mapper I was unable to connect to SQL Server 7.0. The server is running Windows 2000 SP4. I've tried connecting using Windows Integrated Security and by using the 'sa' account. Neither works. The sa password is not blank.



It sees the server but when it tries to load the databases, it doesnt populate the databases combo box.



Any suggestions?

Thanks

Mike

So you are just trying to pull a structure from an SQL 7.0 database then and the StrataFrame databases are on a SQL Server 2000 instance.  Is this correct?

The tutorial uses the StrataFrameSample database and creates a business object called CustomersBO and then maps that business object to the Customers table in the StrataFrameSample database.  Are you able to pull the structure from SQL the Server 2000 instance?

As I mentioned earlier, the 7.0 instance may not pull the structure correctly.  We do guarantee StrataFrame support for SQL Server 2000 or later, but not 7.0. 

Another option is to load SQL Server 2005 Express or MSDE.  Both of these databases are free and Express comes as part of the Visual Studio 2005 install or you can easily download it off of the website.

I really want to get you going, but I recommend working through the trial on SQL Server 2000 or later.