Hi Scott,
These are the steps we followed and we obtained the following errors:
1. Open SetupActions.sln in Visual Studio 2008. On my machine it is located
in c:\StockTraderDemo\setup_utilities\SetupActions
I could not open SetupActions.sln as a project in Visual C# 2008 express
edition.
I clicked on File->Open Project->SetupActions.sln and I got this error. (The
image)
2. Open the App.config file in the SetupActions project
a. Change the dbServer value. From the thread below it sounds like
yours should be set to .\SQLExpress
b. Change the dbPassword value. This would be the value that you
assigned to the sa account when you installed SQLExpress.
I followed this and I did not face any complications but I have a question
here.
Don't we have to change the "install path" value in the App.config file? We
have to set it to the path where we have stored all files i.e,
"SetupActions.cs",
"SetupActions.csproj","Program.cs" etc.
3. Compile the solution. Build -> Build Solution menu.
Which file is exactly "solution"? Is it SetupActions.sln?
Regards,
Ranjitha
On Wed, Apr 8, 2009 at 7:48 AM, Prajwal Muralidhara <
prajwal.muralidh...@sun.com> wrote:
> 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)
>> <a-dre...@microsoft.com>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:ranjitha...@gmail.com]
>>> Sent: Thursday, April 02, 2009 8:08 AM
>>> To: stonehenge-dev@incubator.apache.org
>>> 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) <
>>> a-dre...@microsoft.com
>>>
>>>
>>>> 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>
>>>>
>>>>
>>>
>>
>>
>
>
