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

Here's how I have it setup. I installed a developer version of SQL Server 2000 from my MSDN library, and this is where I have installed the StrataFrame internal and sample databases. I was aware of a problem connecting to SQL Server 7.0 and I wanted to be able to learn the framework without having to deal with this problem at the same time.



I was working my way through Tutorial 1 and I was in the Business Object Mapper setting the project properties (setting the SQL Server connection string) I was going to connect to my SQL Server 2000 database to base the Business Object on but thought I would try to connect to the SQL Server 7.0 server, just to see if i could. I specified the name of the server and the sa credentials... when I tried to open the databases drop down, it said it was loading them and when I opened the drop down it was empty. I remember one of you guys was telling me that I can't use a blank sa password.. so I've created a new instance of SQL Server 7.0 that the sa has a password.



Thanks

What you might try is this, Mike:



Don't use the wizard to create the connection string, but type it in manually. NOTE: Within the BOMapper, you don't have to specify the database within your connection string, so these connection strings would work fine:



Server=MyServer;Integrated Security=SSPI;



Server=MyServer;User Id=sa;Password=MyPassword;



You don't need the database, because the BOMapper only connects to the "master" database to gather the structure information on the server. So, if the dropdown list won't populate with the databases, try skipping the wizard and just entering your connection string manually. Then, when you configure a business object and point it to a specific table, the BOMapper should be able to use the connection string you entered to read the database structure without problem.