зеркало из https://github.com/mono/mail-archives.git
132 строки
5.5 KiB
HTML
132 строки
5.5 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
|
|
<HTML>
|
|
<HEAD>
|
|
<TITLE> [Mono-list] different behavior between .NET and Mono
|
|
</TITLE>
|
|
<LINK REL="Index" HREF="index.html" >
|
|
<LINK REL="made" HREF="mailto:dan%40astusa.com">
|
|
<META NAME="robots" CONTENT="index,nofollow">
|
|
|
|
<LINK REL="Previous" HREF="025783.html">
|
|
<LINK REL="Next" HREF="025815.html">
|
|
</HEAD>
|
|
<BODY BGCOLOR="#ffffff">
|
|
<H1>[Mono-list] different behavior between .NET and Mono
|
|
</H1>
|
|
<B>Dan Maltes
|
|
</B>
|
|
<A HREF="mailto:dan%40astusa.com"
|
|
TITLE="[Mono-list] different behavior between .NET and Mono">dan@astusa.com
|
|
</A><BR>
|
|
<I>Wed, 16 Feb 2005 17:00:46 -0500</I>
|
|
<P><UL>
|
|
<LI> Previous message: <A HREF="025783.html">[Mono-list] different behavior between .NET and Mono
|
|
</A></li>
|
|
<LI> Next message: <A HREF="025815.html">[Mono-list] different behavior between .NET and Mono
|
|
</A></li>
|
|
<LI> <B>Messages sorted by:</B>
|
|
<a href="date.html#25785">[ date ]</a>
|
|
<a href="thread.html#25785">[ thread ]</a>
|
|
<a href="subject.html#25785">[ subject ]</a>
|
|
<a href="author.html#25785">[ author ]</a>
|
|
</LI>
|
|
</UL>
|
|
<HR>
|
|
<!--beginarticle-->
|
|
<PRE>You can use the user account in sql that already there for access to that
|
|
database, that's fine. However, the connection must authenticate you by
|
|
sending the username and password, whereas with windows authentication, your
|
|
logged in windows user credentials would be sent automatically, and the
|
|
matched against a sql user, which is what cannot happen on mono. So, yes,
|
|
your connection string could be altered to pass the sql user name and
|
|
password.
|
|
|
|
-Dan
|
|
|
|
-----Original Message-----
|
|
From: <A HREF="mailto:mono-list-admin@lists.ximian.com">mono-list-admin@lists.ximian.com</A>
|
|
[mailto:<A HREF="mailto:mono-list-admin@lists.ximian.com">mono-list-admin@lists.ximian.com</A>] On Behalf Of Michael George
|
|
Sent: Wednesday, February 16, 2005 4:14 PM
|
|
To: Dan Maltes
|
|
Cc: 'Michael George'; 'A Rafael D Teixeira'; 'MonoList'
|
|
Subject: RE: [Mono-list] different behavior between .NET and Mono
|
|
|
|
On Wed, February 16, 2005 3:35 pm, Dan Maltes said:
|
|
><i> Correct. And you will need to a create sql user(s) that have access
|
|
</I>><i> to that database. Then, the client app must use sql login instead of
|
|
</I>><i> windows authentication.
|
|
</I>
|
|
I'm not a pro at MS-SQL, though I'm kinda learning my way around...
|
|
|
|
So there's a difference between an SQL user and a Windows users? I have 2
|
|
users: Xuser with no Login Name and Permit DB access, and dbo with a Login
|
|
Name of Xuser and Permit DB access. Looking at either users' properties, I
|
|
don't see how to know which type of user they are.
|
|
|
|
As for the type of login, I'm guessing that will be part of the options to
|
|
the connection call rather than the connection string? I don't see anything
|
|
that indicates the type of connection in the connection string...
|
|
|
|
However, since the SQL logging output indicates SQL commands being received,
|
|
it seems that it already knows to use an SQL connection.
|
|
|
|
Thank you very much!
|
|
|
|
><i> From: <A HREF="mailto:mono-list-admin@lists.ximian.com">mono-list-admin@lists.ximian.com</A>
|
|
</I>><i> [mailto:<A HREF="mailto:mono-list-admin@lists.ximian.com">mono-list-admin@lists.ximian.com</A>] On Behalf Of Michael George
|
|
</I>><i> Sent: Wednesday, February 16, 2005 3:19 PM
|
|
</I>><i> To: A Rafael D Teixeira
|
|
</I>><i> Cc: Michael George; MonoList
|
|
</I>><i> Subject: Re: [Mono-list] different behavior between .NET and Mono
|
|
</I>><i>
|
|
</I>><i>
|
|
</I>><i> On Wed, February 16, 2005 2:42 pm, A Rafael D Teixeira said:
|
|
</I>>><i> AFAIK, our ADO.NET provider for SQLServer (it is part of Mono) only
|
|
</I>>><i> can connect with SQL password, as the other protocol is a closed one
|
|
</I>>><i> that ties with ActiveDirectory and/or NT Domain Controllers.
|
|
</I>>><i>
|
|
</I>>><i> Configure your database server to accept SQL connections, otherwise
|
|
</I>>><i> we can't connect to it.
|
|
</I>><i>
|
|
</I>><i> Looking at the properties for my database, the Security tab, under
|
|
</I>><i> Authentication I have "SQL Server and Windows" set. I think that's
|
|
</I>><i> what you're saying to do, right?
|
|
</I>><i>
|
|
</I>><i> -Michael George
|
|
</I>><i> Ideal Solution, LLC
|
|
</I>><i>
|
|
</I>><i> _______________________________________________
|
|
</I>><i> Mono-list maillist - <A HREF="mailto:Mono-list@lists.ximian.com">Mono-list@lists.ximian.com</A>
|
|
</I>><i> <A HREF="http://lists.ximian.com/mailman/listinfo/mono-list">http://lists.ximian.com/mailman/listinfo/mono-list</A>
|
|
</I>><i>
|
|
</I>><i>
|
|
</I>
|
|
|
|
-Michael George
|
|
Ideal Solution, LLC
|
|
|
|
_______________________________________________
|
|
Mono-list maillist - <A HREF="mailto:Mono-list@lists.ximian.com">Mono-list@lists.ximian.com</A>
|
|
<A HREF="http://lists.ximian.com/mailman/listinfo/mono-list">http://lists.ximian.com/mailman/listinfo/mono-list</A>
|
|
|
|
|
|
|
|
|
|
</PRE>
|
|
<!--endarticle-->
|
|
<HR>
|
|
<P><UL>
|
|
<!--threads-->
|
|
<LI> Previous message: <A HREF="025783.html">[Mono-list] different behavior between .NET and Mono
|
|
</A></li>
|
|
<LI> Next message: <A HREF="025815.html">[Mono-list] different behavior between .NET and Mono
|
|
</A></li>
|
|
<LI> <B>Messages sorted by:</B>
|
|
<a href="date.html#25785">[ date ]</a>
|
|
<a href="thread.html#25785">[ thread ]</a>
|
|
<a href="subject.html#25785">[ subject ]</a>
|
|
<a href="author.html#25785">[ author ]</a>
|
|
</LI>
|
|
</UL>
|
|
</body></html>
|