> I have the vanilla cfaibjects datasource as a Sybase SQL Anywhere...
>
> I upsize to SQL Server 7...(made a DB named cfaobjects_new in SQL
> server - I
> then added it to the ODBC admin in conrol panel as cfaobjects_new), I
> migrated the standard cfaobjects datasource to this new DB... okay done.
Ok, this step (the migrate) was not necessary. When you upsized the Sybase
crap, you created an exact copy. All you needed to do was rename cfaobjects
to cfaobjects_old, and rename your SQL Server version to cfaobjects. At that
point, Spectra will be using SQL Server for CFAobjects.
> I rename the datasource in CF admin to cfaobjects and rename the original
> cfaobjects to cfaobjects_old via the Sybase dialogue box.
See above.
> I created a new datasource for me new app.
>
> I then set the current app to my new datasource from within the webtop..
> How can I be sure that I am using a seperate Webtop and Seperate
> datastore?
Your not. According to the above, your using SQL Server for cfaobjects. Yes,
it's "new", but it's still your 'Webtop' dsn, so if your new app object is
pointing to it, that's bad. Luckily, all you need to do is create a new
database in SQL Server, create a DSN pointer to it, then use the webtop to
'install' to it, and update your app object to point to it.
Make sense?
-Ray
------------------------------------------------------------------------------
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.
