newbie question

Hi,
i'm kinda new to Microsoft SQL Server. I've just finished my first
install. Now i want to be able to connect macintosh clients to the
server. I'm able to connect using windows 2000 authentification but not
with SQL Server authentification (in mixed mode).
When using "Aqua Data Studio" on my mac, when i try to connect using
the "sa" account it fails because "the connection is not associated to
a secure SQL Server connection".
How can i establish such a secured connection ?
Thanks in advance,
Pierre
When you're connecting to SQL server with sa user you are trying to
authenticate with SQL authentication.
That means that you have to set a mixed mode on the server. Then you'll be
able to connect with sa user.
Secure SQL Server connection error you're getting means that you should use
Windows account to log to SQL Server.
Danijel
"Pierre Chatel" <admin@.chatelp.org> wrote in message
news:2005011413034716807%admin@.chatelporg...
> Hi,
> i'm kinda new to Microsoft SQL Server. I've just finished my first
> install. Now i want to be able to connect macintosh clients to the server.
> I'm able to connect using windows 2000 authentification but not with SQL
> Server authentification (in mixed mode).
> When using "Aqua Data Studio" on my mac, when i try to connect using the
> "sa" account it fails because "the connection is not associated to a
> secure SQL Server connection".
> How can i establish such a secured connection ?
> Thanks in advance,
> Pierre
>

newbie question

Hi,
i'm kinda new to Microsoft SQL Server. I've just finished my first
install. Now i want to be able to connect macintosh clients to the
server. I'm able to connect using Windows 2000 authentification but not
with SQL Server authentification (in mixed mode).
When using "Aqua Data Studio" on my mac, when i try to connect using
the "sa" account it fails because "the connection is not associated to
a secure SQL Server connection".
How can i establish such a secured connection '
Thanks in advance,
PierreWhen you're connecting to SQL server with sa user you are trying to
authenticate with SQL authentication.
That means that you have to set a mixed mode on the server. Then you'll be
able to connect with sa user.
Secure SQL Server connection error you're getting means that you should use
Windows account to log to SQL Server.
Danijel
"Pierre Chatel" <admin@.chatelp.org> wrote in message
news:2005011413034716807%admin@.chatelpor
g...
> Hi,
> i'm kinda new to Microsoft SQL Server. I've just finished my first
> install. Now i want to be able to connect macintosh clients to the server.
> I'm able to connect using Windows 2000 authentification but not with SQL
> Server authentification (in mixed mode).
> When using "Aqua Data Studio" on my mac, when i try to connect using the
> "sa" account it fails because "the connection is not associated to a
> secure SQL Server connection".
> How can i establish such a secured connection '
> Thanks in advance,
> Pierre
>

newbie question

Hi,
i'm kinda new to Microsoft SQL Server. I've just finished my first
install. Now i want to be able to connect macintosh clients to the
server. I'm able to connect using windows 2000 authentification but not
with SQL Server authentification (in mixed mode).
When using "Aqua Data Studio" on my mac, when i try to connect using
the "sa" account it fails because "the connection is not associated to
a secure SQL Server connection".
How can i establish such a secured connection '
Thanks in advance,
PierreWhen you're connecting to SQL server with sa user you are trying to
authenticate with SQL authentication.
That means that you have to set a mixed mode on the server. Then you'll be
able to connect with sa user.
Secure SQL Server connection error you're getting means that you should use
Windows account to log to SQL Server.
Danijel
"Pierre Chatel" <admin@.chatelp.org> wrote in message
news:2005011413034716807%admin@.chatelporg...
> Hi,
> i'm kinda new to Microsoft SQL Server. I've just finished my first
> install. Now i want to be able to connect macintosh clients to the server.
> I'm able to connect using windows 2000 authentification but not with SQL
> Server authentification (in mixed mode).
> When using "Aqua Data Studio" on my mac, when i try to connect using the
> "sa" account it fails because "the connection is not associated to a
> secure SQL Server connection".
> How can i establish such a secured connection '
> Thanks in advance,
> Pierre
>

Newbie query question

I need to include data from a table which is not directly related to
the "hub" table, and am kinda stuck.
I doubted it would work (tried anyhow), but this is the code from my
attempt:
SELECT
ConsignmentCodes.CodeDesc,
Stockline.ConsignmentCode,
Reserve.SalesOrderId,
Invoice.ShipDate,
Part.Number,
Reserve.Shipped as Qty,
SOItem.UnitAmount,
(Reserve.Shipped*SOItem.UnitAmount) as Total,
1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
FROM Stockline JOIN Part ON (Stockline.PartId=Part.PartId)
LEFT JOIN Reserve ON (Stockline.StockId=Reserve.StockId)
LEFT JOIN ConsignmentCodes ON
(Stockline.ConsignmentCode=ConsignmentCodes.Consig nmentCode)
LEFT JOIN SOItem ON (Stockline.PartId=SOItem.PartId)
WHERE Reserve.SalesOrderId=Invoice.SalesOrderId
AND Reserve.InvoiceId=Invoice.InvoiceId
You can see why it did didn't work, and hopefully, what I am trying to
do.
I need "Invoice.ShipDate", but "Invoice" doesn't have any fields which
relate to "Stockline".
If I try to base all my relationships on "Resreve", then I end up with
ths same problem for "Part".
What's my next step?
-Mo
On Feb 22, 2:41Xpm, Lucas Kartawidjaja
<LucasKartawidj...@.discussions.microsoft.com> wrote:
> Without knowing the table structure and their relationship, I would suggest
> try the following query or something close:
> SELECT
> X X X X ConsignmentCodes.CodeDesc,
> X X X X Stockline.ConsignmentCode,
> X X X X Reserve.SalesOrderId,
> X X X X Invoice.ShipDate,
> X X X X Part.Number,
> X X X X Reserve.Shipped as Qty,
> X X X X SOItem.UnitAmount,
> X X X X (Reserve.Shipped*SOItem.UnitAmount) as Total,
> X X X X 1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
> FROM X XStockline LEFT OUTER JOIN Part ON (Stockline.PartId=Part.PartId)
> X X X X LEFT OUTER JOIN Reserve ON (Stockline.StockId=Reserve.StockId)
> X X X X LEFT OUTER JOIN ConsignmentCodes ON
> X X X X X X X X (Stockline.ConsignmentCode=ConsignmentCodes.Consig nmentCode)
> X X X X LEFT OUTER JOIN SOItem ON (Stockline.PartId=SOItem.PartId)
> X X X X LEFT OUTER JOIN Invoice ON (Reserve.SalesOrderId=Invoice..SalesOrderId)
> X X X X AND (Reserve.InvoiceId=Invoice.InvoiceId)
> Lucas
>
> "Mehile.Orl...@.gmail.com" wrote:
>
>
>
> - Show quoted text -
Thanks, I think that gets me going again.
If I run into anything else, I'll repost.
Mo
sql

Newbie query question

I need to include data from a table which is not directly related to
the "hub" table, and am kinda stuck.
I doubted it would work (tried anyhow), but this is the code from my
attempt:
SELECT
ConsignmentCodes.CodeDesc,
Stockline.ConsignmentCode,
Reserve.SalesOrderId,
Invoice.ShipDate,
Part.Number,
Reserve.Shipped as Qty,
SOItem.UnitAmount,
(Reserve.Shipped*SOItem.UnitAmount) as Total,
1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
FROM Stockline JOIN Part ON (Stockline.PartId=Part.PartId)
LEFT JOIN Reserve ON (Stockline.StockId=Reserve.StockId)
LEFT JOIN ConsignmentCodes ON
(Stockline.ConsignmentCode=ConsignmentCodes.ConsignmentCode)
LEFT JOIN SOItem ON (Stockline.PartId=SOItem.PartId)
WHERE Reserve.SalesOrderId=Invoice.SalesOrderId
AND Reserve.InvoiceId=Invoice.InvoiceId
You can see why it did didn't work, and hopefully, what I am trying to
do.
I need "Invoice.ShipDate", but "Invoice" doesn't have any fields which
relate to "Stockline".
If I try to base all my relationships on "Resreve", then I end up with
ths same problem for "Part".
What's my next step?
-MoWithout knowing the table structure and their relationship, I would suggest
try the following query or something close:
SELECT
ConsignmentCodes.CodeDesc,
Stockline.ConsignmentCode,
Reserve.SalesOrderId,
Invoice.ShipDate,
Part.Number,
Reserve.Shipped as Qty,
SOItem.UnitAmount,
(Reserve.Shipped*SOItem.UnitAmount) as Total,
1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
FROM Stockline LEFT OUTER JOIN Part ON (Stockline.PartId=Part.PartId)
LEFT OUTER JOIN Reserve ON (Stockline.StockId=Reserve.StockId)
LEFT OUTER JOIN ConsignmentCodes ON
(Stockline.ConsignmentCode=ConsignmentCodes.ConsignmentCode)
LEFT OUTER JOIN SOItem ON (Stockline.PartId=SOItem.PartId)
LEFT OUTER JOIN Invoice ON (Reserve.SalesOrderId=Invoice.SalesOrderId)
AND (Reserve.InvoiceId=Invoice.InvoiceId)
Lucas
"Mehile.Orloff@.gmail.com" wrote:
> I need to include data from a table which is not directly related to
> the "hub" table, and am kinda stuck.
> I doubted it would work (tried anyhow), but this is the code from my
> attempt:
> SELECT
> ConsignmentCodes.CodeDesc,
> Stockline.ConsignmentCode,
> Reserve.SalesOrderId,
> Invoice.ShipDate,
> Part.Number,
> Reserve.Shipped as Qty,
> SOItem.UnitAmount,
> (Reserve.Shipped*SOItem.UnitAmount) as Total,
> 1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
> FROM Stockline JOIN Part ON (Stockline.PartId=Part.PartId)
> LEFT JOIN Reserve ON (Stockline.StockId=Reserve.StockId)
> LEFT JOIN ConsignmentCodes ON
> (Stockline.ConsignmentCode=ConsignmentCodes.ConsignmentCode)
> LEFT JOIN SOItem ON (Stockline.PartId=SOItem.PartId)
> WHERE Reserve.SalesOrderId=Invoice.SalesOrderId
> AND Reserve.InvoiceId=Invoice.InvoiceId
> You can see why it did didn't work, and hopefully, what I am trying to
> do.
> I need "Invoice.ShipDate", but "Invoice" doesn't have any fields which
> relate to "Stockline".
> If I try to base all my relationships on "Resreve", then I end up with
> ths same problem for "Part".
>
> What's my next step?
> -Mo
>|||On Feb 22, 2:41=A0pm, Lucas Kartawidjaja
<LucasKartawidj...@.discussions.microsoft.com> wrote:
> Without knowing the table structure and their relationship, I would sugges=t
> try the following query or something close:
> SELECT
> =A0 =A0 =A0 =A0 ConsignmentCodes.CodeDesc,
> =A0 =A0 =A0 =A0 Stockline.ConsignmentCode,
> =A0 =A0 =A0 =A0 Reserve.SalesOrderId,
> =A0 =A0 =A0 =A0 Invoice.ShipDate,
> =A0 =A0 =A0 =A0 Part.Number,
> =A0 =A0 =A0 =A0 Reserve.Shipped as Qty,
> =A0 =A0 =A0 =A0 SOItem.UnitAmount,
> =A0 =A0 =A0 =A0 (Reserve.Shipped*SOItem.UnitAmount) as Total,
> =A0 =A0 =A0 =A0 1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
> FROM =A0 =A0Stockline LEFT OUTER JOIN Part ON (Stockline.PartId=3DPart.Par=tId)
> =A0 =A0 =A0 =A0 LEFT OUTER JOIN Reserve ON (Stockline.StockId=3DReserve.St=ockId)
> =A0 =A0 =A0 =A0 LEFT OUTER JOIN ConsignmentCodes ON
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 (Stockline.ConsignmentCode=3DConsignmentCo=des.ConsignmentCode)
> =A0 =A0 =A0 =A0 LEFT OUTER JOIN SOItem ON (Stockline.PartId=3DSOItem.PartI=d)
> =A0 =A0 =A0 =A0 LEFT OUTER JOIN Invoice ON (Reserve.SalesOrderId=3DInvoice=.SalesOrderId)
> =A0 =A0 =A0 =A0 AND (Reserve.InvoiceId=3DInvoice.InvoiceId)
> Lucas
>
> "Mehile.Orl...@.gmail.com" wrote:
> > I need to include data from a table which is not directly related to
> > the "hub" table, and am kinda stuck.
> > I doubted it would work (tried anyhow), but this is the code from my
> > attempt:
> > SELECT
> > ConsignmentCodes.CodeDesc,
> > Stockline.ConsignmentCode,
> > Reserve.SalesOrderId,
> > Invoice.ShipDate,
> > Part.Number,
> > Reserve.Shipped as Qty,
> > SOItem.UnitAmount,
> > (Reserve.Shipped*SOItem.UnitAmount) as Total,
> > 1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
> > FROM Stockline JOIN Part ON (Stockline.PartId=3DPart.PartId)
> > LEFT JOIN Reserve ON (Stockline.StockId=3DReserve.StockId)
> > LEFT JOIN ConsignmentCodes ON
> > (Stockline.ConsignmentCode=3DConsignmentCodes.ConsignmentCode)
> > LEFT JOIN SOItem ON (Stockline.PartId=3DSOItem.PartId)
> > WHERE Reserve.SalesOrderId=3DInvoice.SalesOrderId
> > AND Reserve.InvoiceId=3DInvoice.InvoiceId
> > You can see why it did didn't work, and hopefully, what I am trying to
> > do.
> > I need "Invoice.ShipDate", but "Invoice" doesn't have any fields which
> > relate to "Stockline".
> > If I try to base all my relationships on "Resreve", then I end up with
> > ths same problem for "Part".
> > What's my next step?
> > -Mo- Hide quoted text -
> - Show quoted text -
Thanks, I think that gets me going again.
If I run into anything else, I'll repost.
Mo

Newbie here. Problems on bulk loading.

Hi guys. I am kinda new in XML bulk loading section. Several tutorials had been done by myself and I get some difficulties when having an attribute in my XML. Here are my table, XML and XML schema for bulk loading.

Tables :

CREATE TABLE [dbo].[Game](
[ID] [int] IDENTITY(1,1) NOT NULL,
[code] [int] NOT NULL,
CONSTRAINT [PK_Game] PRIMARY KEY CLUSTERED
(
[code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Match](
[ID] [int] NOT NULL,
[date] [datetime] NULL,
[gamecode] [int] NOT NULL,
CONSTRAINT [PK_Match] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Match] WITH CHECK ADD CONSTRAINT [FK_Match_Game] FOREIGN KEY([gamecode])
REFERENCES [dbo].[Game] ([code])
GO
ALTER TABLE [dbo].[Match] CHECK CONSTRAINT [FK_Match_Game]

XML :

<?xml version='1.0' encoding='utf-8'?>

<ROOT>

<game code="1"/>

<match id = "1001" date="2007/08/01" />

<match id = "1002" date="2007/08/02" />
</game>

<game code="2"/>

<match id = "1003" date="2007/08/03" />

<match id = "1004" date="2007/08/04" />
</game>

<game code="3"/>

<match id = "1005" date="2007/08/05" />

<match id = "1006" date="2007/08/06" />
</game>

</ROOT>

XML Schema :

<xsdchema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlnsql="urnchemas-microsoft-com:mapping-schema">

<xsd:annotation>
<xsd:appinfo>
<sql:relationship name="gameMatch"
parent="Game"
parent-key="code"
child="Deal"
child-key="gamecode" />
</xsd:appinfo>
</xsd:annotation>

<xsd:element name="game" sql:relation="Game" >
<xsd:complexType>
<xsdequence>
<xsd:element name="Match"
sql:relation="Match"
sql:relationship="gameMatch" >
<xsd:complexType>
<xsd:attribute name="id" type="xsd:integer" /> -- error occurs on this attribute
</xsd:complexType>
</xsd:element>
</xsdequence>
<xsd:attribute name="date" type="xsdate" />
</xsd:complexType>
</xsd:element>

</xsdchema>

Hope able to get any assistance here. Thx.

My problem solved. Just the element mistake.