How can we help you today? How can we help you today?

Can't edit project properties if Database connection is down

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]
jcooke
0

Comments

2 comments

Sort by
  • 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.
    Linda Hawksworth
    0
  • jcooke
    Thanks Linda...That did the trick.
    jcooke
    0

Add comment

Please sign in to leave a comment.