Re: (ot) sql server 2005 express sp3 installation onto vista os

2009-08-12 Thread Jason Fisher

Actually, I run SQL 2005 Express on my Vista box at home for dev work, and it's 
actually been fine.  SQL Express has its own problems (what do you mean I can't 
move data with it??), but that's not a Vista issue. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325375
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: (ot) sql server 2005 express sp3 installation onto vista os

2009-08-12 Thread Jochem van Dieten

On Wed, Aug 12, 2009 at 5:19 AM, Don L wrote:
 Mysql, sql lite, h2, derby  = no install
 sql lite is eliminated for it's not a dbms but a c library for a dbm.  of the 
 remaining 3, which one is most compatiable with ms sql server 2005 syntax and 
 feature-wise?

PostgreSQL.

Supports silent installation, PostgreSQL driver is included in Railo
out of the box. And PostgreSQL is licensed under the BSD license so
you can use it without fear of having to release your own stuff as
open source.

Jochem

-- 
Jochem van Dieten
http://jochem.vandieten.net/

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325383
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: (ot) sql server 2005 express sp3 installation onto vista os

2009-08-12 Thread Don L

 Actually, I run SQL 2005 Express on my Vista box at home for dev work, 
 and it's actually been fine.  SQL Express has its own problems (what 
 do you mean I can't move data with it??), but that's not a Vista issue. 
Could you look up Windows Installer version from registry on your Vista box for 
me?
Probably here are places to start,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall
HKEY_LOCAL_MACHINE\Software\Microsoft\Active Setup\Installed Components

Also, what edition of your Vista os?

Thanks. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325398
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: (ot) sql server 2005 express sp3 installation onto vista os

2009-08-12 Thread Jason Fisher

Looks like it's still Vista SP1, Home Premium Edition.

No clue what version of the Installer is in place.  There are no entries 
in those keys that are specific to the installer itself, at least not on 
my OS.

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325423
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: (ot) sql server 2005 express sp3 installation onto vista os

2009-08-12 Thread Don L

Looks like it's still Vista SP1, Home Premium Edition.

No clue what version of the Installer is in place.  There are no entries 
in those keys that are specific to the installer itself, at least not on 
my OS.

Good to know, thanks.  Those two registry branches are pretty standard for XP 
probably Vista is a quite different beast, could you run a key word search 
for Windows Installer at the computer level across all registries with 
regedit for me?  Would greatly appreciate it. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325424
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: (ot) sql server 2005 express sp3 installation onto vista os

2009-08-12 Thread Don L

 On Wed, Aug 12, 2009 at 5:19 AM, Don L wrote:
  Mysql, sql lite, h2, derby  = no install
  sql lite is eliminated for it's not a dbms but a c library for a dbm. 
  of the remaining 3, which one is most compatiable with ms sql server 
 2005 syntax and feature-wise?
 
 PostgreSQL.
 
 Supports silent installation, PostgreSQL driver is included in Railo
 out of the box. And PostgreSQL is licensed under the BSD license so
 you can use it without fear of having to release your own stuff as
 open source.
 
 Jochem
 
thanks for the input.
 Jochem van Dieten
 http://jochem.vandieten.
net/

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325425
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: (ot) sql server 2005 express sp3 installation onto vista os

2009-08-12 Thread Emmit Larson

Out of curiosity, after all  the problems you have had with MSSQL Express
and all the alternatives that have been offered. Are you going to continue
to use MSSQL Express? Or will you try using one of the alternatives?
Best Regards.
Emmit

On Wed, Aug 12, 2009 at 6:27 PM, Don L do...@yahoo.com wrote:


  On Wed, Aug 12, 2009 at 5:19 AM, Don L wrote:
   Mysql, sql lite, h2, derby  = no install
   sql lite is eliminated for it's not a dbms but a c library for a dbm.
   of the remaining 3, which one is most compatiable with ms sql server
  2005 syntax and feature-wise?
 
  PostgreSQL.
 
  Supports silent installation, PostgreSQL driver is included in Railo
  out of the box. And PostgreSQL is licensed under the BSD license so
  you can use it without fear of having to release your own stuff as
  open source.
 
  Jochem
 
 thanks for the input.
  Jochem van Dieten
  http://jochem.vandieten.
 net/

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325427
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: (ot) sql server 2005 express sp3 installation onto vista os

2009-08-12 Thread Don L

FYI,
a) Project deadline is days away.  One should probably not to change horse 
while crossing a river (of course another could argue should you really need 
to cross the river?)
b) The randomly reported error may not accurately reflect sql server 2005 
express sp3 installation success or failure with Vista.  Too bad MS is not very 
accurate on this, only a small number of users has this (installation) 
problem, also, in rare situation it would crash a user's computer, shameful.
c) I have another option.
d) Converting the app from cf8 to railo has already caused me quite a bit of 
pain
not because railo has some real issue but because of misunderstanding or 
difference in expectation.  Would like to avoid this especially now.
e) I leave the option open to move away from MS DBMS but right now timing is 
way too bad.  But if MS is on my back then hell I would be forced to take 
action.  Then who the heck am I?  Kidding myself!
f) Intend to publish the db schema (or most of them) in case other cfers would 
like to extend the app.  But definitely not now.

Out of curiosity, after all  the problems you have had with MSSQL Express
and all the alternatives that have been offered. Are you going to continue
to use MSSQL Express? Or will you try using one of the alternatives?
Best Regards.
Emmit

On Wed, Aug 12, 2009 at 6:27 PM, D

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325428
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


(ot) sql server 2005 express sp3 installation onto vista os

2009-08-11 Thread Don L

I'd like to hear people's experience on this, my users/customers reported tons 
of problem with it while generally positive on XP.  I don't have vista box 
myself, can't test it on my own.  thks. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325361
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: (ot) sql server 2005 express sp3 installation onto vista os

2009-08-11 Thread Gerald Guido

Mysql, sql lite, h2, derby  = no install

All of which have rich SQL dialects and are very capable.

Problem solved!

G!

On Tue, Aug 11, 2009 at 9:47 PM, Don L do...@yahoo.com wrote:


 I'd like to hear people's experience on this, my users/customers reported
 tons of problem with it while generally positive on XP.  I don't have vista
 box myself, can't test it on my own.  thks.

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325363
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: (ot) sql server 2005 express sp3 installation onto vista os

2009-08-11 Thread Don L

sql lite is eliminated for it's not a dbms but a c library for a dbm.  of the 
remaining 3, which one is most compatiable with ms sql server 2005 syntax and 
feature-wise? do they all support quiet installation? do h2 and derby support 
dll as well? how about creating datasource connection to railo cfml engine? fk 
ms! it made me so mad (their own os, their own dbms, all fucked up!)

Mysql, sql lite, h2, derby  = no install

All of which have rich SQL dialects and are very capable.

Problem solved!

G!

On Tue, Aug 11, 2009 at 9:47 PM, D


 I'd like to hear people's experience on this, my users/customers reported
 tons of problem with it while generally positive on XP.  I don't have vista
 box myself, can't test it on my own.  thks.

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325364
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4