Can't edit project properties if Database connection is down

jcooke

Hi,

I had set up a number of generator projects pointing to a particular database. The machine that housed the database needed to be rebuilt. After they started the rebuild, I was going to load my data to a different database.
The problem is that when I try to open the project to change the DB connection, I get an error that says that the project could not be loaded due to the fact that it could not connect to the database.
Is there anyway to change the project connection properties outside the GUI?

Thanks
Jim Cooke[/img]

Linda Hawksworth

You can manually edit the project file (*.sqlgen) in Notepad and change the server name and/or database name. Look for the string:

<ServerName>LINDA\SQLSERVER2000</ServerName><DatabaseName>WidgetDev</DatabaseName>

Please let me know if this works for you.

jcooke

Thanks Linda...That did the trick.