Hi Ranjitha, You should set this to whatever 'instance' you want to Use to use. On my system I use ./MSSQLSERVER, Often if you only have one instance on your MSSQL installation can simply use "." I have three different flavors of MSSQL running on my machine. The readme says "dbserver is set to ".\MSQLServer " If you use SQLExpress it will be different." I will update the readme to be more clear on this.
Use whatever instance you want as long as it is installed. Of course you want to be consistent. >From MSDN: "The default installation of SQL Server 2005 Express Edition uses >an instance name of SQLEXPRESS." So if that is your case then substitute >SQLEXPRESS. Hope This helps. Here is more on MSSQL instances. http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/68a3c394-b120-48ce-9f50-819a5dd4c129/ Best, Drew -----Original Message----- From: Ranjitha V [mailto:[email protected]] Sent: Thursday, April 02, 2009 8:08 AM To: [email protected] Subject: Re: How to create and populate DB Hi Drew, You have mentioned this in your first reply to Harold. c. dbserver is set to ".\MSQLServer " If you use SQLExpress or *another MSSQL Instance* it will be different. I have posted this question once before. My server is set to SQLEXPRESS and not to MSSQLSERVER (as required). This is also mentioned in the wiki http://cwiki.apache.org/confluence/display/STONEHENGE/Stonehenge+PHP+and+WSAS+Stocktrader+Installation+Guide My question is simple. Can I continue with creation and population of database with the SQLEXPRESS running. Or is it imperative that I need to have the MSSQLSERVER running. If possible, can you clarify the difference between the two? Regards, Ranjitha On Thu, Apr 2, 2009 at 7:18 PM, Drew Baird (Volt) <[email protected]>wrote: > HI Vineet, > It is hard to tell what you need because of the way the replies are > interwoven. > I think you said "> There are a number of "SetupActions" in the link. > Can pls tell me specifically which one??. > > The Link: > http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/SetupActions/ > > This is a C# solution and project. When the C# program is compiled it will > run the script in setupActions.cs. If you don't want to use dotnet/C# you > can read the code and see what it does. Here is where the paths are defined. > string CREATE_LOADACCOUNTPROFILEXML = > @"Setup\DATALOAD\CreateInsertXMLAccountProfileProc.sql"; > string CREATE_LOADACCOUNTXML = > @"Setup\DATALOAD\CreateInsertXMLAccountProc.sql"; > string CREATE_LOADHOLDINGXML = > @"Setup\DATALOAD\CreateInsertXMLHoldingProc.sql"; > string CREATE_LOADORDERSXML = > @"Setup\DATALOAD\CreateInsertXMLOrdersProc.sql"; > string CREATE_LOADQUOTEXML = > @"Setup\DATALOAD\CreateInsertXMLQuoteProc.sql"; > > So it looks like 5 scripts above physically exist in : > http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/ > > Hope this helps. You really need to read and understand the rest of the > program to understand parameters and how to run the scripts manually. > > HTH > Drew > <Rest of mail snipped for clarity>
