hyper threading: application

Showing posts with label application. Show all posts

Friday, March 23, 2012

I cant execute my asp.net application with IIS 5.0

Hi,

please i have a problem, i can't execute my asp.net application with IIS 5.0?

i have a message indicating that MYSERVER\ASPNET can't connect, and that arrive when trying connect to the database under SQL Server 2000.

you have to know that my application work very well with webserver of WebMatrix.

Web Matrix Project : version 0.6

.Net Framework 1.1

Thank you.

Is the server a domain controller? If so, there are no local users, so the MYSERVER\ASPNET user will not exist. If it's not a DC, have you verified that the account exisits in SQL for the ASPNET user?

Monday, March 19, 2012

I cannot connect an application using OLE DB

When I try to make the connection, the following message appears

"Cannot open database requested in login 'DBName'. Login fails."
Err Code = -2147467259

We are using SQL Server 2000 on NT Server 4.0 SP 6.
The client machine has MDAC 2.6 SP1.

All ideas are welcome.

ThanksSounds like the connection to the server has been made but the login cannot open the database. Could be because the database does not exist or because the login does not map to a valid user in the database.
Try just connecting to master.

I cann't connect to Analysisi Server 2000 from IA64 server with 2003 using adomd.net

I have tried to connect an application developed with c# and adomd.net v9.0 to AS 2000 installed on other server .

The server where my application is installed is a IA64 with win 2003 , the analysis server is installed on another server .

This is my code

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using Microsoft.AnalysisServices.AdomdClient;

namespace ado2000

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

AdomdConnection adomd= new AdomdConnection();

adomd.ConnectionString = this.textBox1.Text;

adomd.Open();

}

I cann't establish the connection always get the same error .

How can i fix this error?

Can I use another tool to make the connection ?

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: A connection cannot be made. Ensure that the server is running. > System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {B9776FC2-70D8-4664-A0DF-998114524D67} failed due to the following error: 80040154.
at Microsoft.AnalysisServices.AdomdClient.IXMLAStream..ctor()
End of inner exception stack trace
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenIXMLAConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectIXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToIXMLA(Boolean createSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at ado2000.Form1.button1_Click(Object sender, EventArgs e) in L:\ComponentesNet\ado2000\ado2000\Form1.cs:line 43
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
-
ado2000
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///E:/Desarrollo/ComponentesNet/ado2000/ado2000/bin/Debug/ado2000.exe
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
-
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
-
Microsoft.AnalysisServices.AdomdClient
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.AnalysisServices.AdomdClient/9.0.242.0__89845dcd8080cc91/Microsoft.AnalysisServices.AdomdClient.dll
-
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
-

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

tks....

hello,

from the error message above it looks likes you don't have IXMLA component (msadomdx.dll) properly installed/registered on your box. I suggest you either try to manually register this dll and see if this maybe helps, or perhaps re-run the setup for adomd.net on your box. (normally the dll would be located somewhere in %ProgramFiles%\Microsoft.Net\Adomd.Net\90\)

Also, note that you also need to have an msolap80 provider installed on your box as well to connect to AS2000.

as to the other ways to connect - you can also try using ole db perhaps. code might look something like below:

using System.Data.OleDb;

using(OleDbConnection connection=new OleDbConnection())

{

connection.ConnectionString = "Provider=MSOLAP.3;Data Source=localhost;"; // your connection string here

connection.Open();

// working with opened connection

}

hope this helps,

I cann't connect to Analysisi Server 2000 from IA64 server with 2003 using adomd.net

I have tried to connect an application developed with c# and adomd.net v9.0 to AS 2000 installed on other server .

The server where my application is installed is a IA64 with win 2003 , the analysis server is installed on another server .

This is my code

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using Microsoft.AnalysisServices.AdomdClient;

namespace ado2000

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

AdomdConnection adomd= new AdomdConnection();

adomd.ConnectionString = this.textBox1.Text;

adomd.Open();

}

I cann't establish the connection always get the same error .

How can i fix this error?

Can I use another tool to make the connection ?

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

tks....

hello,

Also, note that you also need to have an msolap80 provider installed on your box as well to connect to AS2000.

as to the other ways to connect - you can also try using ole db perhaps. code might look something like below:

using System.Data.OleDb;

using(OleDbConnection connection=new OleDbConnection())

{

connection.ConnectionString = "Provider=MSOLAP.3;Data Source=localhost;"; // your connection string here

connection.Open();

// working with opened connection

}

hope this helps,

Monday, March 12, 2012

I can not connect to SQL Server 2000 on WinXP SP2

Hi,
I am using 'SQLServer 2000 Driver for JDBC' in my java application. My SQL
Server is running in Windows XP pc. I dont had any problem before install
WindowsXP Service Pack 2. But when i have installed WinXP SP2 my application
can not connected to SQL Server. I have disabled firewall option in windows
but problem already continue. Is there any way for fixing this problem.
Thanks.
Sql Server SP3 is required
"Sercan AYYILDIZ" <sercan@.politeknik.us> wrote in message
news:O4umfOqEFHA.2756@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am using 'SQLServer 2000 Driver for JDBC' in my java application. My
> SQL
> Server is running in Windows XP pc. I dont had any problem before install
> WindowsXP Service Pack 2. But when i have installed WinXP SP2 my
> application
> can not connected to SQL Server. I have disabled firewall option in
> windows
> but problem already continue. Is there any way for fixing this problem.
> Thanks.
>

Friday, March 9, 2012

I am not sure whether I can use sql mobile.

Hi,

There are many text records need to be storeaged in my application.

I am new guy to Sql Mobile.

If I choose sql mobile to save my data. Will my app be more complex to deploy ?

Before I use Sql Mobile on device(wm5), need I install it first?

any other advice?

Best regards

PWang

SQL Mobile can store your textual data if your mobile application is constructed with Visual Studio 2005. You will have to include the SQL Mobile CAB files along with your application and install them on device in order to use this database engine. Yes, you have to install SQL Mobile on WM5 devices - it is not included in ROM.

You might want to read through some of the introductory information on the SQL Mobile Developer's Center on MSDN.

http://msdn.microsoft.com/sql/mobile/default.aspx

Darren

I am having a problem with percision which appears to be a documented bug is there a work around

I have been working on an application which require as much percision as we can get. We have defined all numeric values as (38,16) however when ever we divide a number by the result of a built in function it truncate the percision to 5 decimal place this cause us to have a small but enoying loss in the numbers being caculated we need a minimuim of 8 decimal places or better is there a work around or solution for this problem in sql server 2005. The more percision the better.

example: select tna/(select sum(tna) from taum) from taum where fund_id = 2345

the result is always 5 decimal places even though fund_id tna = 2569698.23 and sum(tna) =98745612325879.36 which should equal .00000002602341683313994 instead the result = .00000

if it is a reporducable bug use the product feedback center to report the bug:

http://connect.microsoft.com/Main/content/content.aspx?ContentID=2220

Otherwise you can use the SQL Server Data Access forum to ask your question

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

|||

Hi Caverman1,

It isn't bug. I resolve this issue in other thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=661591&SiteID=1

Good coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

I am having a problem with percision which appears to be a documented bug is there a work ar

example: select tna/(select sum(tna) from taum) from taum where fund_id = 2345

the result is always 5 decimal places even though fund_id tna = 2569698.23 and sum(tna) =98745612325879.36 which should equal .00000002602341683313994 instead the result = .00000

if it is a reporducable bug use the product feedback center to report the bug:

http://connect.microsoft.com/Main/content/content.aspx?ContentID=2220

Otherwise you can use the SQL Server Data Access forum to ask your question

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

|||

Hi Caverman1,

It isn't bug. I resolve this issue in other thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=661591&SiteID=1

Good coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

Friday, February 24, 2012

hypertext links & SQL 7 databases

I have arrived at a site and been thrown this curve ball.
This company have an Access 97 application which
successfully stores hypertext links. A consultancy came
into to try and Xfer all the functionality to SQL 7 (a
financial decision & because it's there!!). The
consultancy's conclusion was for the company to upgrade
SQL from 7 to 2000 in order for hyperlinks to be stored
(or used) successfully. The consultancy did not give a
definite reason for their conclusion & the company person
involved needs a reason why SQL7 is not a viable option.
Anyone out there know why?
I have trawled the KB and searched the web for answers
without success.
Thanks in advance,
Euan.
There is no such thing as a hyperlink datatype in either SQL 7 or SQL 2000.
You're going to have to code the <a href=> part yourself, either in the
query or in the front-end application.
http://www.aspfaq.com/
(Reverse address to reply.)
"Euan" <anonymous@.discussions.microsoft.com> wrote in message
news:002901c4a0b7$afb4d660$a301280a@.phx.gbl...
> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.
|||Hi
Neither SQL 7 or 2000 have a "hyperlink" data type. You would have to store
it in a char/varchar field and it would be up to the application to display
it as a hyperlink.
Regards
Mike
"Euan" wrote:

> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.
>

hypertext links & SQL 7 databases

I have arrived at a site and been thrown this curve ball.
This company have an Access 97 application which
successfully stores hypertext links. A consultancy came
into to try and Xfer all the functionality to SQL 7 (a
financial decision & because it's there!!). The
consultancy's conclusion was for the company to upgrade
SQL from 7 to 2000 in order for hyperlinks to be stored
(or used) successfully. The consultancy did not give a
definite reason for their conclusion & the company person
involved needs a reason why SQL7 is not a viable option.
Anyone out there know why?
I have trawled the KB and searched the web for answers
without success.
Thanks in advance,
Euan.There is no such thing as a hyperlink datatype in either SQL 7 or SQL 2000.
You're going to have to code the <a href=> part yourself, either in the
query or in the front-end application.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Euan" <anonymous@.discussions.microsoft.com> wrote in message
news:002901c4a0b7$afb4d660$a301280a@.phx.gbl...
> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.|||Hi
Neither SQL 7 or 2000 have a "hyperlink" data type. You would have to store
it in a char/varchar field and it would be up to the application to display
it as a hyperlink.
Regards
Mike
"Euan" wrote:
> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.
>

Sunday, February 19, 2012

Hyper Threading for a cluster envirnoment

Hi
We are running SQL server in a cluster environment and Hyper threading are
enabled in that servers. The application and Database servers are
different. The appliactions stores 2 MB size of acrobat files to the table
which contains more than 600000 records . We are finding some kind of
issues with this servers.
Couple of SQL DBAs mentioning that , Hyder threading needs to disable in
that server .Is hyper threading cause any issue related to SQL Server
envirnoment.
Please reply
Regards
Swami
ganesh2012@.hotmail.com
Hi
I see no reason why you should. HT processors act like there are 2
processors installed.
What issues are you having?
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:54181388-7DEA-46D4-AA5E-D183BE5846E5@.microsoft.com...
> Hi
> We are running SQL server in a cluster environment and Hyper threading
are
> enabled in that servers. The application and Database servers are
> different. The appliactions stores 2 MB size of acrobat files to the
table
> which contains more than 600000 records . We are finding some kind of
> issues with this servers.
> Couple of SQL DBAs mentioning that , Hyder threading needs to disable in
> that server .Is hyper threading cause any issue related to SQL Server
> envirnoment.
> Please reply
> Regards
> Swami
> ganesh2012@.hotmail.com
>
|||In general, hyperthreading is a good thing. There are some strange
behaviors on 8 or more processor clusters but these only happen under some
very specific conditions. I do find that you will need to lower the
maximium degree of parallelism to the actual physical processor count to
avoid oversaturating a system. Please reply with more details on exactly
what your symptoms are so someone here can give you a better answer.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:54181388-7DEA-46D4-AA5E-D183BE5846E5@.microsoft.com...
> Hi
> We are running SQL server in a cluster environment and Hyper threading
are
> enabled in that servers. The application and Database servers are
> different. The appliactions stores 2 MB size of acrobat files to the
table
> which contains more than 600000 records . We are finding some kind of
> issues with this servers.
> Couple of SQL DBAs mentioning that , Hyder threading needs to disable in
> that server .Is hyper threading cause any issue related to SQL Server
> envirnoment.
> Please reply
> Regards
> Swami
> ganesh2012@.hotmail.com
>
|||Geoff N. Hiten wrote:

> In general, hyperthreading is a good thing.

> There are some strange
> behaviors on 8 or more processor clusters but these only happen under some
> very specific conditions.
Could jou post a link to some info on this?
Hans
|||Here is one I actually oberved. It is a very unusual set of circumstances
that caused the problem.
FIX: Intermittent query slowdowns and corresponding high CPU utilization
http://support.microsoft.com/default.aspx/kb/835864
Here was another fix earlier to handle some other synchronization
performance issues.
FIX: Intense SQL Server Activity Results in Spinloop Wait in SQL Server 2000
Service Pack 2
http://support.microsoft.com/default...b;en-us;818763
I am pretty sure SP2 had something in it for Hyperthreading, most likely
counting the processors correctly for licensing restrictions.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hans de Bruin" <hans@.invalid.invalid> wrote in message
news:1107960610.727258@.draco.amc.uva.nl...[vbcol=seagreen]
> Geoff N. Hiten wrote:
>
some
> Could jou post a link to some info on this?
> --
> Hans

Hyde database features ...

My application setup program installs a MSDE2K instance on the user machine,
then attaches the application database (previously prepared with sa access
on the development machine), adds server logins and db users, sets
permissions etc. Everything goes fine, but I would like to hide my database
design, preventing the sysadmin of the target machine (NT) to view its
tables structure and relationships. How can I make my database protected 'by
itself' ?
hi Alessandro,
"Alessandro T" <alessandroteglia@.tin.it> ha scritto nel messaggio
news:ut2uAGWIEHA.3988@.tk2msftngp13.phx.gbl...
> My application setup program installs a MSDE2K instance on the user
machine,
> then attaches the application database (previously prepared with sa access
> on the development machine), adds server logins and db users, sets
> permissions etc. Everything goes fine, but I would like to hide my
database
> design, preventing the sysadmin of the target machine (NT) to view its
> tables structure and relationships. How can I make my database protected
'by
> itself' ?
>
it is not possible to prevent a sysadmin member to access your data and/or
metaschema ...
to prevent access to data area you have to resort to crypt solutions like
http://www.activecrypt.com/index.htm or your own algorithms, while for
schema hiding, you are only provided with the WITH ENCRYPTION option and for
stored procedure, views and user defined functions only...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Hurry! Query needs help

Hello Fellow Developers,

I am very new to SQL and ASP.net and in the learning process. I have to do a small web application that handles documents stored on a sql database. The requirements of the functionality of the application are below. I am just having trouble setting my query to work correctly.

Problem:

I want to be able to pull documents and folders that have the same ClientID. However, here is the catch, the query should take two inputs - ClientID and ParentID (which is an ID representing FolderID from the Folder Table; the document/folder does not belong to another folder then the system will enter ZERO as the ParentID). I hope this is clear? Can this even be done?

Any help is greatly appreciated, as life is a learning experience.

Database Structure:

Table Name: Client

Fields:

ClientID primary key autonumber

Name nvarchar 255

Table Name: ClientDocs

Fields:

DocID primary key autonumber

Document image (the actually file in bytes)

FriendlyName nvarchar 255

ClientID foreign key -> [Table Client]

ClientFolderID foreign key -> [Table ClientFolders]

Table Name: Folders

Fields:

FolderID primarykey autonumber

FolderName nvarchar 255

Table Name: ClientFolder

Fields:

ClientFolderID primarykey autonumber

FolderID foreign key -> [Table Folders]

ParentID int

ClientID foreign key -> [Table Clients]

saeapu:
Problem:
I want to be able to pull documents and folders that have the same ClientID. However, here is the catch, the query should take two inputs - ClientID and ParentID (which is an ID representing FolderID from the Folder Table; the document/folder does not belong to another folder then the system will enter ZERO as the ParentID).

What's the exact thing will the query do? To me it seems an insert to some table (may be ClientFolders?). Then where do the 2 input valuesClientID and ParentIDcome from? You mentioned when will the ParentID be set to 0, so what's the value of ParentID if it dose not satisfy the condition to be 0? And how do you want to deal with FolderID in your query, as there is a FolderID column in ClientFolders?

|||Not sure if i understand the question, is it just to return the data using a sql statement or stored procedure?

If it is, using a stored procedure you could:

Declare 2 parameters, @.ClientId and @.ParentId.

In the Where clause of your statement have something like

WHERE
ClientId = @.ClientId
AND (ParentId = @.ParentId
OR @.ParentId = 0)|||

Iori_Jay:
What's the exact thing will the query do? To me it seems an insert to some table (may be ClientFolders?). Then where do the 2 input values ClientID and ParentID come from? You mentioned when will the ParentID be set to 0, so what's the value of ParentID if it dose not satisfy the condition to be 0? And how do you want to deal with FolderID in your query, as there is a FolderID column in ClientFolders?

Thanks Lori_jay for the input and questions. Hopefully below I can explain the problem better.

Basically I am creating a small web application. Currently what my app can do is upload files to a sql database and associate the file(s) to a clientID. So there is 1 Client to many documents.

This works fine and dandy, but what I am trying to do is give the capability to create folders in the application. And let users insert a document into a particular folder which that folder is associated to a client and those documents inside the folder is also associated to the same ClientID. But they do not have to put the document inside a folder. They can just upload the document and just associate it to the ClientID. The reason I did parentID is that if they wanted to create a folder inside another folder. So the queries I will be needing help with is the 'Select' query to retrieve all documents and folders that have a two paremetersPartentID andClientID.

ParentID = a integer representing the folder that document/folder belongs too. If the folder /document is at the root level of the client then the value will be "0".

ClientID = a integer representing a Client.

Maybe my table structures are incorrect. What do you think?

Here is a small tree like structure I have in mind.

ClientID

|__ Folders

| |

| |__________Folder

| |

| |__Documents

|__ Documents

|||

DrGonzo:
Not sure if i understand the question, is it just to return the data using a sql statement or stored procedure?
If it is, using a stored procedure you could:
Declare 2 parameters, @.ClientId and @.ParentId.
In the Where clause of your statement have something like
WHERE
ClientId = @.ClientId
AND (ParentId = @.ParentId
OR @.ParentId = 0)

Hey Thanks DrGonzo, I have tried that already and no luck Can you give me an example on how you would use the tables I have given above and JOIN them to make this query work.

Thanks.

|||

saeapu:
So the queries I will be needing help with is the 'Select' query to retrieve all documents and folders that have a two paremetersPartentID andClientID.

ParentID = a integer representing the folder that document/folder belongs too. If the folder /document is at the root level of the client then the value will be "0".

ClientID = a integer representing a Client.

Then how do you konw the folder/document is at the root level? Can I say a row in ClientFolders table which has 0 for ParentID column represents a top level entity? If so we do not need to consider the @.ParentID with value 0 as a particular issue, we can just treat @.ParentID as it is other value (1,2,3...ect.). The top level entity logic is implemented when you insert the row into ClientFolders table, right? Let's try such query:

declare @.ClientID int,@.ParentID int
select @.ClientID=1,@.ParentID=1
select c.ClientID,c.Name,cf.ClientFolderID,cf.ParentID,
f.FolderID,f.FolderName,cd.FriendlyName
from ClientFolders cf join Folders f on cf.FolderID = f.FolderID
join ClientDocs cd on cf.ClientFolderID=cd.ClientFolderID
join Clients c on cf.ClientID = c.ClientID
wherecf.ClientID=@.ClientID
andcf.ParentID=@.ParentID

Friday, March 23, 2012

I cant execute my asp.net application with IIS 5.0

Monday, March 19, 2012

I cannot connect an application using OLE DB

I cann't connect to Analysisi Server 2000 from IA64 server with 2003 using adomd.net

I cann't connect to Analysisi Server 2000 from IA64 server with 2003 using adomd.net

Monday, March 12, 2012

I can not connect to SQL Server 2000 on WinXP SP2

Friday, March 9, 2012

I am not sure whether I can use sql mobile.

I am having a problem with percision which appears to be a documented bug is there a work around

I am having a problem with percision which appears to be a documented bug is there a work ar

Friday, February 24, 2012

hypertext links & SQL 7 databases

hypertext links & SQL 7 databases

Sunday, February 19, 2012

Hyper Threading for a cluster envirnoment

Hyde database features ...

Hurry! Query needs help

hyper threading

Blog Archive

About Me