Showing posts with label helloi. Show all posts
Showing posts with label helloi. Show all posts

Sunday, March 11, 2012

Datamining Viewer Client Problem

Hello!

I am running a SQL Server 2005. I created the mining models from the tutorials. I can connect with the DataminingViewerClient directly on the SQL Server(i.e. to localhost), but when i try to connect to the Server from my other computer it is not working i always get connection faild and i should check that the server is running. I can connect to the Server with other programms but the viewer is not working. Any ideas what that could be?

Can you connect to other servers from the machine where the DataminingViewerClient application works? If so, it may be that there are additional client components that need to be installed. Let us know and we can continue to diagnose.

Thanks

-Jamie

|||Ok i now tried to connect from Server A to Server B, not working either. It works on both when i run the viewer directly on the server and connect to localhost but not from Server A to B or vice versa or from any other computer. Could it be that some permissions are missing, because in the dataminingviewer client i dont have to specify a user/password for the server where the analysis-service runs. I dont think that components are missing because i can compile the source code without errors, but i'll be happy about any hint that might help.

Another thing i tried: When i create a datasource on Server A to connect to Server B(or from any other computer) it only works when I use the sa user(Windows Authentication doesnt work), otherwise i cant browse/select the databases.|||In general AS only uses Windows Authentication, unless you connect over http (requires configuration - see books online). Connecting over http allows you to specify a username and password. For the DM Viewer Client, you cna modify the code to use a http connection, or prompt for username and password. The source code is provided.|||

Hello again!

I found the error...the server was not in the domain, after we added it it worked.

Wednesday, March 7, 2012

DataBindings

Hello

I need to link two tables,

one has a primary key (Membership) and one doesn't (results),

results doesn't have any primary key values, I have added a membership number column can I bind the results table column membership number to the values in the membership table?

If so how?

C

You need a FOREIGN KEY constraint between the 2 tables. Just set a FOREIGN KEY constraint on the membership number column of 'results' talbe which references the Primary Key column of Membership table. You can use such T-SQL statement:

ALTER TABLE Membership ADD CONSTRAINT
FK_MemShip_Num FOREIGN KEY
(
[membership number]
) REFERENCES dbo.titlex
(
[membership number]
)

For more information, please refers to following article:

http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_04_8ypg.asp?frame=true

Friday, February 24, 2012

DatabaseName data column is blank in Profiler

Hello!
I am trying to figure out when DatabaseName Data column in SQL Trace is
always blank. I am executing SQL Batch. I can see DatabaseID but not Name.
Any help is greatly appreciated,
IgorHi
It is not always captured!
http://tinyurl.com/3m6xm
http://tinyurl.com/4t9wb
John
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:epuZDeyCFHA.1188@.tk2msftngp13.phx.gbl...
> Hello!
> I am trying to figure out when DatabaseName Data column in SQL Trace is
> always blank. I am executing SQL Batch. I can see DatabaseID but not Name.
> Any help is greatly appreciated,
> Igor
>

DatabaseName data column is blank in Profiler

Hello!
I am trying to figure out when DatabaseName Data column in SQL Trace is
always blank. I am executing SQL Batch. I can see DatabaseID but not Name.
Any help is greatly appreciated,
Igor
Hi
It is not always captured!
http://tinyurl.com/3m6xm
http://tinyurl.com/4t9wb
John
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:epuZDeyCFHA.1188@.tk2msftngp13.phx.gbl...
> Hello!
> I am trying to figure out when DatabaseName Data column in SQL Trace is
> always blank. I am executing SQL Batch. I can see DatabaseID but not Name.
> Any help is greatly appreciated,
> Igor
>

DatabaseName data column in Profiler is blank

Hello!
I am trying to figure out when DatabaseName Data column in SQL Trace is
always blank. I am executing SQL Batch. I can see DatabaseID but not Name.
Any help is greatly appreciated,
Igor
It's only populated for certain security related events. It won't be
populated for events like Batch Completed or SP Completed. When I load a
trace into a table I tend to have an auxillary table with the databaseid +
name and then create a view to look at the trace so I get the database name.
I do a similar thing with the Event column (you can find the names for the
eventid's in BOL)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:OlgV2dyCFHA.2288@.TK2MSFTNGP14.phx.gbl...
> Hello!
> I am trying to figure out when DatabaseName Data column in SQL Trace is
> always blank. I am executing SQL Batch. I can see DatabaseID but not Name.
> Any help is greatly appreciated,
> Igor
>
|||Thanks a lot,
Igor
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eplEBP3CFHA.228@.tk2msftngp13.phx.gbl...
> It's only populated for certain security related events. It won't be
> populated for events like Batch Completed or SP Completed. When I load a
> trace into a table I tend to have an auxillary table with the databaseid +
> name and then create a view to look at the trace so I get the database
> name. I do a similar thing with the Event column (you can find the names
> for the eventid's in BOL)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
> news:OlgV2dyCFHA.2288@.TK2MSFTNGP14.phx.gbl...
>

Sunday, February 19, 2012

Database work

Hello!I'm new here on the forum!
I have a work to do on a class which consists on creating a database and this's a work by checkpoints,which means,I have a limit date to give away part of the work I've done until the next checkpoint.The prob lem is,I don't know where to start!The first thing I'm asked to do is to propose a theme(Managing a bar was what I had in mind) and have its preliminary specification.What do they want to say with 'preliminary specification'?Next I'm supposed to give away the inicial specification and the applicational funcionalities that uses this database...Again I'm not sure what they mean by that...Any help is extremely appreciated!Which school is it? Full name and address, please.

Why? Perhaps someone (among Forum members) goes to that school, or even works there. Then it will be easier to answer such a question. Because, if YOU, who attend those classes (or, at least, you are supposed to) don't have a clue what your teacher wants, how do you expect US to read his mind?

Whatever we think "preliminary specificatons" or "functionalities" are, it is your teacher who EXACTLY knows what he wants you to do. Therefore, I'd suggest you to take a walk, knock on his door and get all required information there.

Then return back and show what you've already done, explain problems you have and someone will surely help you. But, it is a little bit impolite to expect Forum members to do your school assignment from the beginning. Gosh, you don't even know how to start!

"Managing a bar" could be OK if you know to manage a bar (it is not just "a barman pours a drink into my glass"), i.e. know business rules. If not, you'll have to spend some time to get into the business - you can't design something you don't know at all. Therefore, choose a theme you are familiar with.|||To make things easier for you, select a data model here (http://www.databaseanswers.org/). ;)

PS: You may need to mention the site/author in the 'bibliography' or 'references' section of your paper.|||At least you can explain all the time you spend in the bar as "research".

It could have been worse. The assignment could have been for a sewage treatment plant.|||Well we are freely to choose a theme we like...|||After giving some more thought to the "Bar management" theme I've decided to change themes,not only because I'm on a tight schedule and I need to send the theme by mail to the teacher until Monday, but also because it would involve lots of research(and field research) and it's not one of the most easiest subjects to deal with.Also the teacher values originality and a database about a bar is something overused this days(at least I see it that way).
After someone suggested to speak with the teacher about what he really wanted to say with "preliminar specification" ,I mailed my teacher with the question and got a response:

"A preliminar specification could be,for example,

'Caf Management Application' will allow:

- do the stock management of all products(inserting shops and sales,deliveries,invoices,etc.)
- staff management(personal data,contracts,prizes,remunerations)

'Caf Management Application' should have:

- an application of POS(cash register) to be used by the waiter
- a backoffice application to be used by the cafe manager"

My new theme deals with 'Dog's house management'.This's what I've got so far concerning my preliminar specification:

'Management application of a dog's house' will allow:

- when the owners are away the dog's house would be their new home.
- register the dogs' breed and type
- manage the the type of treatments and medical care needed
- register information about the dogs(name,age,color,gender,etc.)
- manage the dogs' family details(name,adress,city,state,contact,etc.)
- manage the vacancies and reservations

Does this preliminar specification looks ok?Should I include something more?Also, what does the term "backoffice" means?
Any help on this is greatly appreciated!Thanks in advance!:)|||Any help,please?