Sorry - not been watching this one - hope this is on the right track
This is speculation only, but I've had previous fun with the NV Access
db's before & noticed a few things that may help you.
Don't try it on a live machine
I'm not convinced about the support line after you do this but....
On NT NV uses the Access Jet engine (MDAC version up to 2.5, but not
above) so the db's are access databases in
<drive>:\usr\ov\databases\odbc (3 of them tess..., snmpcollect...,
topo...)
There are 3 odbc connections created which if you set
DATABASE_TYPE=ACCESS then then will be MS-Access connections.
You could _try_;
- create a db in ms/sql called Netview (name is irrelevant).
- Run the 3 .sql scripts in <drive>:\usr\ov\databases\odbc in that db to
create the tables
- Re-create the odbc connections (note their name) - you'll need to
provide a value uid/pswd to access the db (test the connections)
It may then elect to start.....
Of course if there are flat files that include some pointers to the db
then things will be bad - the thing I'd be suspicious of is whatever the
equivalent to reset_ci on NT is. If the code can handle initialising the
db when it finds an empty db, then all _may_ be ok.
If this works and you really want your data you could try using DTS in
SQL to export the Access db into the new SQL db, but that may also
require a data transformation (not much fun)..
imho I'd re-install NV as suggested by James. Although the above may be
entertaining(!), I doubt it will work/get supported.
Hth
K
-----Original Message-----
From: James Shanks [mailto:jshanks@us.ibm.com]
Sent: 27 May 2003 15:16
To: nv-l@lists.tivoli.com
Subject: Re: [nv-l] Access to SQL (7.1.3 on Windows)
I suggest that you read those instructions again. The choice of
databases
is set at install time. You cannot switch from one to the other without
re-installing the product, so far as I know. If SQL server is
installed,
then NetView will use that. You can, as the instructions indicate, set
an
environment variable prior to installation, to tell the installation
program to use Access rather than SQL Server, but otherwise that's what
you get. So to switch to SQL server now, you'd have to reinstall the
product. But you should be able to do that and preserve the
customization and the object database (which is nether Access nor SQL)
you
have now.
The installation program will detect that you already have NetView
installed and ask if you want to upgrade that installation or install
fresh. Choose the upgrade option to preserve the customizations you
have
already made.
James Shanks
Level 3 Support for Tivoli NetView for UNIX and NT
Tivoli Software / IBM Software Group
CMazon@commercebankfl.com
05/23/2003 03:56 PM
To: nv-l@lists.tivoli.com
cc:
Subject: [nv-l] Access to SQL (7.1.3 on Windows)
Is there a way to tell NetView to start using SQL if SQL server was
installed after NetView. We did not know that SQL had to be on the same
server, which is why we had to install SQL after the fact. I find
instructions on how to use Access when SQL is installed but not vice
versa.
I already have SNMP collect set to use SQL server however nothing is
being written to it.
Thanks for you help
Carlos A. Mazón
Network Administrator
---------------------------------------------------------------------
To unsubscribe, e-mail: nv-l-unsubscribe@lists.tivoli.com
For additional commands, e-mail: nv-l-help@lists.tivoli.com
*NOTE*
This is not an Offical Tivoli Support forum. If you need immediate
assistance from Tivoli please call the IBM Tivoli Software Group help
line at 1-800-TIVOLI8(848-6548)
---------------------------------------------------------------------
To unsubscribe, e-mail: nv-l-unsubscribe@lists.tivoli.com
For additional commands, e-mail: nv-l-help@lists.tivoli.com
*NOTE*
This is not an Offical Tivoli Support forum. If you need immediate
assistance from Tivoli please call the IBM Tivoli Software Group help
line at 1-800-TIVOLI8(848-6548)
---------------------------------------------------------------------
To unsubscribe, e-mail: nv-l-unsubscribe@lists.tivoli.com
For additional commands, e-mail: nv-l-help@lists.tivoli.com
*NOTE*
This is not an Offical Tivoli Support forum. If you need immediate
assistance from Tivoli please call the IBM Tivoli Software Group
help line at 1-800-TIVOLI8(848-6548)
|