Missing dll file: network

Showing posts with label network. Show all posts

Wednesday, March 28, 2012

Modeling a Matrix

What is the best way to model a matrix in terms of table design? I want to
model a sociogram, which is basically a network diagram with weights
assigned to the edges. Once, established I would want to use it to do matrix
computations (matrix algebra). So, the simple version would be something
like the following:
0 1 1
1 0 1
1 1 0
The rows and columns will constitute the same set of data. In other words,
the matrix will reflect the relationship between like entities from the same
set. Relationships between persons of a given set of people, for example.
Just wondering if there is a clever way of modeling this, or if I should
just use a table with three columns: entityA, entityB, edgeValue...
Thanks
BKGet a copy of SQL FOR SMARTIES; there is a whole chapter on matrix math
in SQL.
CREATE TABLE Martix
(i INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n1>>,
j INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n2>>,
k INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n3>>,
element_value FLOAT NOT NULL,
PRIMARY KEY (i, j, k));
Then you talk about graphs in SQL with a sociogram -- which is it?|||(grabs SQL FOR SMARTIES off of his bookshelf...and there it is on p303! ..
should have checked there first)
Excellent, thanks! I thought that might be the best way to do, but just
wanted to validate my gut feeling...
The answer to your question is: both. Really its just a matrix
representation of a sociogram, so the edges will represent the relationships
between the nodes (and the elements of the matrix). The row and column
vectors will be the same and will represent the "people".
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1115680013.666216.159290@.f14g2000cwb.googlegroups.com...
> Get a copy of SQL FOR SMARTIES; there is a whole chapter on matrix math
> in SQL.
> CREATE TABLE Martix
> (i INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n1>>,
> j INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n2>>,
> k INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n3>>,
> element_value FLOAT NOT NULL,
> PRIMARY KEY (i, j, k));
> Then you talk about graphs in SQL with a sociogram -- which is it?
>|||BK,
See http://groups.google.co.uk/groups?q=BBEB95_9DBB7E for an example.
Steve Kass
Drew University
BK wrote:

>What is the best way to model a matrix in terms of table design? I want to
>model a sociogram, which is basically a network diagram with weights
>assigned to the edges. Once, established I would want to use it to do matri
x
>computations (matrix algebra). So, the simple version would be something
>like the following:
>0 1 1
>1 0 1
>1 1 0
>The rows and columns will constitute the same set of data. In other words,
>the matrix will reflect the relationship between like entities from the sam
e
>set. Relationships between persons of a given set of people, for example.
>Just wondering if there is a clever way of modeling this, or if I should
>just use a table with three columns: entityA, entityB, edgeValue...
>Thanks
>BK
>
>

Friday, March 23, 2012

mmc.exe Error - Please HELP

I had SQL Server Personal edition on my Windows XP
Professional client computer and something happened
yesterday when the network people push down Antivirus
update. Now when I try to connect other SQL Servers on the
network, it takes too long and I keep hearing raddling
disk noise.
I have the following error messages on my Event viewer:
Hanging application mmc.exe, version 5.1.2600.0, hang
module hungapp, version 0.0.0.0, hang address 0x00000000.
also
Hanging application isqlw.exe, version 2000.80.194.0, hang
module hungapp, version 0.0.0.0, hang address 0x00000000.
Is there anyone else has experienced this.
Thanks for any feedback.I'd run a ScanDisk ... peculiar noises from any disks are usually not good.

Wednesday, March 21, 2012

Mixed Mode Authentication

Hi folks,
I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
am trying to install project server 2003. Project server tells me that my
SQL server must be in Mixed mode to complete the installation.
The problem is that the server which was installed with "Windows Only" will
not switch to "Windows and SQL". I have restarted the services and still no
joy, what else can I do to change to mixed mode?
thanks
DaveWhat do you mean it wont switch? Do you get an error
message? If so, would you like to share it with the rest
of the class?
>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>|||David,
Is SQL Server a local administrator on the machine? Does it have access
to the registry? This state is stored in the registry, and if SQL Server
doesn't have write permission to the registry it could fail.
The registry key is
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQLServer\<instance_name>\MSSQLServer\LoginMode
The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
may still see 0 for SQL Server only (servers upgraded from 6.5).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Hi folks,
> I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
> am trying to install project server 2003. Project server tells me that my
> SQL server must be in Mixed mode to complete the installation.
> The problem is that the server which was installed with "Windows Only" will
> not switch to "Windows and SQL". I have restarted the services and still no
> joy, what else can I do to change to mixed mode?
> thanks
> Dave
>|||No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle :)
Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx.gbl...
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> >--Original Message--
> >Hi folks,
> >
> >I have a microsoft SQL server 2000 on a Windows 2003
> Server on my network, I
> >am trying to install project server 2003. Project server
> tells me that my
> >SQL server must be in Mixed mode to complete the
> installation.
> >
> >The problem is that the server which was installed
> with "Windows Only" will
> >not switch to "Windows and SQL". I have restarted the
> services and still no
> >joy, what else can I do to change to mixed mode?
> >
> >thanks
> >Dave
> >
> >
> >.
> >|||Hi Mark,
thanks for that, your correct, the currently logged on user which I thought
was part of the local administrators group isn't.
oh the joys
thanks
Dave
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||Just thought of something there, what do you mean is the "SQL Server" a
local administrator on the machine?
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||David,
What I meant was, is the Windows Domain Account that the MSSQLServer
service logs on under, a member of the Local Administrators group on the
server.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Just thought of something there, what do you mean is the "SQL Server" a
> local administrator on the machine?
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
>>David,
>>Is SQL Server a local administrator on the machine? Does it have access
>>to the registry? This state is stored in the registry, and if SQL Server
>>doesn't have write permission to the registry it could fail.
>>The registry key is
>>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
>>SQLServer\<instance_name>\MSSQLServer\LoginMode
>>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
>>may still see 0 for SQL Server only (servers upgraded from 6.5).
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>David Hodgson wrote:
>>Hi folks,
>>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> network, I
>>am trying to install project server 2003. Project server tells me that
> my
>>SQL server must be in Mixed mode to complete the installation.
>>The problem is that the server which was installed with "Windows Only"
> will
>>not switch to "Windows and SQL". I have restarted the services and still
> no
>>joy, what else can I do to change to mixed mode?
>>thanks
>>Dave
>>
>
>|||No but it is part of the "domain admins" group which is part of the "local
admins" group so permissions look ok.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23gMxADDaEHA.2892@.TK2MSFTNGP10.phx.gbl...
> David,
> What I meant was, is the Windows Domain Account that the MSSQLServer
> service logs on under, a member of the Local Administrators group on the
> server.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Just thought of something there, what do you mean is the "SQL Server" a
> > local administrator on the machine?
> >
> >
> > "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> > news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> >
> >>David,
> >>
> >>Is SQL Server a local administrator on the machine? Does it have access
> >>to the registry? This state is stored in the registry, and if SQL Server
> >>doesn't have write permission to the registry it could fail.
> >>
> >>The registry key is
> >>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> >>SQLServer\<instance_name>\MSSQLServer\LoginMode
> >>
> >>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> >>may still see 0 for SQL Server only (servers upgraded from 6.5).
> >>
> >>--
> >>Mark Allison, SQL Server MVP
> >>http://www.markallison.co.uk
> >>
> >>Looking for a SQL Server replication book?
> >>http://www.nwsu.com/0974973602.html
> >>
> >>
> >>
> >>David Hodgson wrote:
> >>
> >>Hi folks,
> >>
> >>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> >
> > network, I
> >
> >>am trying to install project server 2003. Project server tells me that
> >
> > my
> >
> >>SQL server must be in Mixed mode to complete the installation.
> >>
> >>The problem is that the server which was installed with "Windows Only"
> >
> > will
> >
> >>not switch to "Windows and SQL". I have restarted the services and
still
> >
> > no
> >
> >>joy, what else can I do to change to mixed mode?
> >>
> >>thanks
> >>Dave
> >>
> >>
> >
> >
> >sql

Wednesday, March 28, 2012

Modeling a Matrix

Friday, March 23, 2012

mmc.exe Error - Please HELP

Wednesday, March 21, 2012

Mixed Mode Authentication

Mixed Mode Authentication

Mixed Mode Authentication

Missing dll file

Blog Archive

About Me