Hi,
SetupAction.cs seems to be working fine. Well there is a option to
connect to database. It searches for .mdf file. I ran createdb.sql file.
After this i tried to connect to the database. i'm not able to find any
.mdf file at all!!! Am I doing the right thing..??? Am i suppose to
connect to any databases after running this c# file???or as Ranjitha
said should i go ahead with SetupActions.csproj??
Prajwal Muralidhara
Hi Drew,
In
http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/SetupActions/
,
we have "*SetupAction.cs* " and "*SetupActions.csproj ". *
The code, "SetupActions.csproj" seems to be compiling "SetupAction.cs" along
with other files.
And "SetupActions.cs" is the one that is creating the database and
populating them with initial
values.
So,I infer that we have to run "SetupActions.csproj". Am I correct?
Or do we have to run "SetupActions.cs"?
Regards,
Ranjitha
On Thu, Apr 2, 2009 at 10:27 PM, Drew Baird (Volt)
<[email protected]>wrote:
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>
