I'm assuming you successfully migrated your cfaobjects DB to SQL server and
gave it a new DSN.
I found after doing this that I had to do the following in addition to
changing the datasource reference for the Ibuild or Project Datasources in
System Design->Applications.
Click on the user name in the Webtop (Next to Application Name on the main
login page)
Select Preferences from the Left and select "Enable System Entities"
In System Design, Select Applications and change the WebTop Datasource (And
any other which is set to the old DSN) to the migrated SQL Server DSN
Without System Entities turned on, the WebTop option does not appear in the
list.
Chris Smoother
FirmwareDesign
02 8836 4812
-----Original Message-----
From: Zoaib A. Qureshi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 19 July 2000 23:46
To: [EMAIL PROTECTED]
Subject: Problem with Database Conversion
Hello All, I created an application in Spectra using SQL Server 7.0. I
installed the database structure in SQL Server. Whenever I start my
application, the Sybase Adaptive Server also starts. I then moved cfaobjects
in SQL Server but webtop starting giving errors that cannot find Adaptive
Server. Do we have to make some changes in source for the webtop to use SQL
Server Database. I have renamed cfaobjects (in Sybase Adaptive Server) to
b_cfaobjects and make a new ODBC connection to cfaobjects in SQL Server. I
have also successfully exported the database from Sybase to SQL Server. The
connection is also giving no errors.
Thanks in advance for your replies.
Zoaib A Qureshi
Noblestar
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
