ODBC and XML

Hi all,
I'm writing an app to export my ODBC connection information to XML format.
There is already a standard File .DSN format, but was wondering if there's
already an XML DTD or XML Schema for DSN's out there. I definitely don't
want to reinvent the wheel, and if I'm able to export my info in a format
that would (presumably) be compatible with other applications in the future,
so much the better.
Thanks,
Michael C.I know that Microsoft has not defined anything in this area, and I
haven't heard of any other ISVs doing this.
Brannon
Michael C wrote:

> Hi all,
> I'm writing an app to export my ODBC connection information to XML format.
> There is already a standard File .DSN format, but was wondering if there's
> already an XML DTD or XML Schema for DSN's out there. I definitely don't
> want to reinvent the wheel, and if I'm able to export my info in a format
> that would (presumably) be compatible with other applications in the futur
e,
> so much the better.
> Thanks,
> Michael C.
>

ODBC and XML

Hi all,
I'm writing an app to export my ODBC connection information to XML format.
There is already a standard File .DSN format, but was wondering if there's
already an XML DTD or XML Schema for DSN's out there. I definitely don't
want to reinvent the wheel, and if I'm able to export my info in a format
that would (presumably) be compatible with other applications in the future,
so much the better.
Thanks,
Michael C.
I know that Microsoft has not defined anything in this area, and I
haven't heard of any other ISVs doing this.
Brannon
Michael C wrote:

> Hi all,
> I'm writing an app to export my ODBC connection information to XML format.
> There is already a standard File .DSN format, but was wondering if there's
> already an XML DTD or XML Schema for DSN's out there. I definitely don't
> want to reinvent the wheel, and if I'm able to export my info in a format
> that would (presumably) be compatible with other applications in the future,
> so much the better.
> Thanks,
> Michael C.
>

Octopus - Open Source Java/XML ETL Tool from Enhydra

Hi all,
I just want to inform you that the final version 2.2 of
Octopus is released.
Octopus is a simple Java-based Extraction, Transformation,
and Loading (ETL) tool. It may connect to any JDBC data
sources and perform transformations defined in an XML
file.
Many different types of databases can be mixed (MSSQL,
Oracle, DB2, QED, JDBC-ODBC with Excel and Access, MySQL,
CSV-files, XML-files,...)
Octopus supports Ant and JUnit to create a database /
tables and extract /load data during a build or test
process.
Now with new default-value mechanisms and XML validation !
Octopus Development Team
Home page: http://octopus.enhydra.org
Objectweb project:
http://forge.objectweb.org/projects/octopus
Download page:
http://forge.objectweb.org/project/showfiles.php?
group_id=39Looks like SPAM, smells like SPAM.
SPAM by any other name is STILL SPAM!!
"Enhydra Development Team" <enhydra@.prozone.co.yu> wrote in message
news:168b01c387fc$81fe2250$a101280a@.phx.gbl...
> Hi all,
> I just want to inform you that the final version 2.2 of
> Octopus is released.
> Octopus is a simple Java-based Extraction, Transformation,
> and Loading (ETL) tool. It may connect to any JDBC data
> sources and perform transformations defined in an XML
> file.
> Many different types of databases can be mixed (MSSQL,
> Oracle, DB2, QED, JDBC-ODBC with Excel and Access, MySQL,
> CSV-files, XML-files,...)
> Octopus supports Ant and JUnit to create a database /
> tables and extract /load data during a build or test
> process.
> Now with new default-value mechanisms and XML validation !
> Octopus Development Team
> Home page: http://octopus.enhydra.org
> Objectweb project:
> http://forge.objectweb.org/projects/octopus
> Download page:
> http://forge.objectweb.org/project/showfiles.php?
> group_id=39
>

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...