ODBC Connection using Alternate windows credentials

Hi,
We have a server in a workgroup that users in our active directory
will need to access.
How can we configure an odbc connection to use a different username
and password (windows not sql) than the one they are currently logged
on on as. (The application we are using only supports windows
authentication not sql)
example : I am logged onto my workstaion a 'Jane', but i Need to use
user id 'janey' to connect to the odbc, and i dont want to have to
log
on to the workstation as janeyHi
Unless you are logged on as the user you wish to authenticate as I don't
think you can do this!
John
"zach" <neopotent@.gmail.com> wrote in message
news:5e0669bb-e86f-4610-8713-5bd06084daa1@.a23g2000hsc.googlegroups.com...
> Hi,
> We have a server in a workgroup that users in our active directory
> will need to access.
>
> How can we configure an odbc connection to use a different username
> and password (windows not sql) than the one they are currently logged
> on on as. (The application we are using only supports windows
> authentication not sql)
>
> example : I am logged onto my workstaion a 'Jane', but i Need to use
> user id 'janey' to connect to the odbc, and i dont want to have to
> log
> on to the workstation as janey
>

Obtain XML from URL with SQL Server 2005?

Hi guys,
With SQL Server 2000 I used to create a virtual directory and obtain a XML
from a URL using "http://server/myVirtualDir?sql=select * from myTable FOR
XML RAW &root=root"
Recently we installed SQL Server 2005 (not my fault, lol) and I just don't
know how to do this (neither the guy who is in charge of the server, lol).
I've been searching but I dind't find a thing. Would anybody be soooo kind
to shed some light over this for me?
=)
Thanks a lot!
You have to go to msdn.microsoft.com and download SQLXML 3.0
SQLXML 4.0 that comes with SQL Server 2005 does not support the ISAPI
extension any longer that provided VDIR access.
If you miss this, please go to http://connect.microsoft.com/sqlserver and
file a request ;-)
Best regards
Michael
"Carlos Sosa Albert" <betun (at) hotmail> wrote in message
news:uCVYqZHpHHA.588@.TK2MSFTNGP06.phx.gbl...
> Hi guys,
> With SQL Server 2000 I used to create a virtual directory and obtain a XML
> from a URL using "http://server/myVirtualDir?sql=select * from myTable FOR
> XML RAW &root=root"
> Recently we installed SQL Server 2005 (not my fault, lol) and I just don't
> know how to do this (neither the guy who is in charge of the server, lol).
> I've been searching but I dind't find a thing. Would anybody be soooo kind
> to shed some light over this for me?
> =)
> Thanks a lot!
|||Hehehehe
Thanks a lot Michael!
Yes... I found it in the weekend. What a @.$#)@.( =P Specially since they
don't mention "officially" in the changes and compatibility issues...
Luckily, the old SQLXML is compatible.
Now I'm trying to figure out how the SQLXML works, since I don't fully
understand how I have to work from .NET and how the SQL works... But well,
in a few weeks I'll have some time to work on it. =/
Thanks again!
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:ekrva6MpHHA.3736@.TK2MSFTNGP03.phx.gbl...
> You have to go to msdn.microsoft.com and download SQLXML 3.0
> SQLXML 4.0 that comes with SQL Server 2005 does not support the ISAPI
> extension any longer that provided VDIR access.
> If you miss this, please go to http://connect.microsoft.com/sqlserver and
> file a request ;-)
> Best regards
> Michael
> "Carlos Sosa Albert" <betun (at) hotmail> wrote in message
> news:uCVYqZHpHHA.588@.TK2MSFTNGP06.phx.gbl...
>
|||Hi Carlos. you may also look at the new Astoria project
http://astoria.mslivelabs.com that provides the REST like APIs similar to
the SQLXML component.
Best regards
Michael
"Carlos Sosa Albert" <betun (at) hotmail> wrote in message
news:%23IQFSjqpHHA.4872@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> Hehehehe
> Thanks a lot Michael!
> Yes... I found it in the weekend. What a @.$#)@.( =P Specially since they
> don't mention "officially" in the changes and compatibility issues...
> Luckily, the old SQLXML is compatible.
> Now I'm trying to figure out how the SQLXML works, since I don't fully
> understand how I have to work from .NET and how the SQL works... But well,
> in a few weeks I'll have some time to work on it. =/
> Thanks again!
> "Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
> news:ekrva6MpHHA.3736@.TK2MSFTNGP03.phx.gbl...

Obtain XML from URL with SQL Server 2005?

Hi guys,
With SQL Server 2000 I used to create a virtual directory and obtain a XML
from a URL using "http://server/myVirtualDir?sql=select * from myTable FOR
XML RAW &root=root"
Recently we installed SQL Server 2005 (not my fault, lol) and I just don't
know how to do this (neither the guy who is in charge of the server, lol).
I've been searching but I dind't find a thing. Would anybody be soooo kind
to shed some light over this for me?
=)
Thanks a lot!You have to go to msdn.microsoft.com and download SQLXML 3.0
SQLXML 4.0 that comes with SQL Server 2005 does not support the ISAPI
extension any longer that provided VDIR access.
If you miss this, please go to http://connect.microsoft.com/sqlserver and
file a request ;-)
Best regards
Michael
"Carlos Sosa Albert" <betun (at) hotmail> wrote in message
news:uCVYqZHpHHA.588@.TK2MSFTNGP06.phx.gbl...
> Hi guys,
> With SQL Server 2000 I used to create a virtual directory and obtain a XML
> from a URL using "http://server/myVirtualDir?sql=select * from myTable FOR
> XML RAW &root=root"
> Recently we installed SQL Server 2005 (not my fault, lol) and I just don't
> know how to do this (neither the guy who is in charge of the server, lol).
> I've been searching but I dind't find a thing. Would anybody be soooo kind
> to shed some light over this for me?
> =)
> Thanks a lot!|||Hehehehe
Thanks a lot Michael!
Yes... I found it in the wend. What a @.$#)@.( =P Specially since they
don't mention "officially" in the changes and compatibility issues...
Luckily, the old SQLXML is compatible.
Now I'm trying to figure out how the SQLXML works, since I don't fully
understand how I have to work from .NET and how the SQL works... But well,
in a few ws I'll have some time to work on it. =/
Thanks again!
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:ekrva6MpHHA.3736@.TK2MSFTNGP03.phx.gbl...
> You have to go to msdn.microsoft.com and download SQLXML 3.0
> SQLXML 4.0 that comes with SQL Server 2005 does not support the ISAPI
> extension any longer that provided VDIR access.
> If you miss this, please go to http://connect.microsoft.com/sqlserver and
> file a request ;-)
> Best regards
> Michael
> "Carlos Sosa Albert" <betun (at) hotmail> wrote in message
> news:uCVYqZHpHHA.588@.TK2MSFTNGP06.phx.gbl...
>|||Hi Carlos. you may also look at the new Astoria project
http://astoria.mslivelabs.com that provides the REST like APIs similar to
the SQLXML component.
Best regards
Michael
"Carlos Sosa Albert" <betun (at) hotmail> wrote in message
news:%23IQFSjqpHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hehehehe
> Thanks a lot Michael!
> Yes... I found it in the wend. What a @.$#)@.( =P Specially since they
> don't mention "officially" in the changes and compatibility issues...
> Luckily, the old SQLXML is compatible.
> Now I'm trying to figure out how the SQLXML works, since I don't fully
> understand how I have to work from .NET and how the SQL works... But well,
> in a few ws I'll have some time to work on it. =/
> Thanks again!
> "Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
> news:ekrva6MpHHA.3736@.TK2MSFTNGP03.phx.gbl...