The Master is your set default, but when you connect to the database in
Rose, you select the database that you want to reverse engineer. There is a
setting when you create a user and password to choose a default database and
that is where you need to have that default as Master. We use the Master
system tables to get information from all other databases.
Eric Naiburg
Rational Software Corp.
425-497-6124
[EMAIL PROTECTED]
-----Original Message-----
From: Butler, Frances H. (FHB) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 06, 2000 9:52 AM
To: 'Naiburg, Eric J.'; 'Butler, Frances H. (FHB) ';
'[EMAIL PROTECTED]'
Subject: RE: (ROSE) Connecting to Microsoft SQL Server 7.0
Eric,
Thanks, but it seems that would provide the system tables only (which is
what Microsoft recommends you have in Master), how do I tell Rose that I do
not want to reverse engineer the system tables, and I want only the schema
for the user defined database? Stating that question another way, how do I
set the Master as default and use another?
Frances
-----Original Message-----
From: Naiburg, Eric J. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 06, 2000 12:06 PM
To: 'Butler, Frances H. (FHB) '; '[EMAIL PROTECTED]'
Subject: RE: (ROSE) Connecting to Microsoft SQL Server 7.0
Your default database for SQL Server must be the Master Database. This does
not mean that this is the database you use, but it just must be your
default. This will be changed in the next release.
Eric Naiburg
Rational Software Corp.
425-497-6124
[EMAIL PROTECTED]
-----Original Message-----
From: Butler, Frances H. (FHB) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 06, 2000 7:56 AM
To: '[EMAIL PROTECTED]'
Subject: (ROSE) Connecting to Microsoft SQL Server 7.0
I am attempting to use Rose 2000e to reverse engineer a SQL Server 7.0
database schema, and I'm having some trouble connecting to the database.
Within Rose, I go to Tools->Data Modeler->Reverse Engineering Wizard.
Next, I have a "Choose a Database" window with the following text boxes:
Target (pull-down menu, where I select Sql Server 7.x)
User Name (where I enter my Windows 3-character uid)
Password (where I enter my Windows password)
Server (where I enter the server name, which is the same as the machine name
in Windows' network neighborhood)
Database (there should be a pull-down menu here if connected properly, but
my problem seems to be with the Windows networking issues, and since I'm not
connected, I get nothing here)
A Windows NT system administrator suggested that I enter 2 backslashes
followed by the machine name (in this case, "morpheus"). That did not work.
We are using TCPIP for connectivity.
Any help would be greatly appreciated.
Thanks in advance,
Frances
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Frances H. Butler
| Computing Specialist
| BWXT Y-12 L.L.C.
| Oak Ridge, TN
| Phone: (865) 574-3694
| Internet: [EMAIL PROTECTED]
|
| Results! Why, man, I have gotten a lot of results.
| I know several thousand things that won't work.
| Thomas Edison
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
