"Philip Wagenaar" wrote:

> I have an application that can be 'queried' by sending an http post, in
> return I get an XML file.
>
> I have another application that can only work with ODBC.
>
> I am asked to write a 'bridge' between these two.
>
> What would be the best way to achieve this?

"raulavi" wrote:

> Hi philip:
> You could achieve this using a DataSet.
> a Dataset can read and write data and schema as XML documents.
> then, depending on what is next use ado.net classes to continue working with
> the dataset.
> I access all my ODBC tables using ds
> search the help for dataset class
> good luck
>
> "Philip Wagenaar" wrote:
>
> > I have an application that can be 'queried' by sending an http post, in
> > return I get an XML file.
> >
> > I have another application that can only work with ODBC.
> >
> > I am asked to write a 'bridge' between these two.
> >
> > What would be the best way to achieve this?

"Philip Wagenaar" wrote:

> How can an application access the DataSet through odbc?
>
> "raulavi" wrote:
>
> > Hi philip:
> > You could achieve this using a DataSet.
> > a Dataset can read and write data and schema as XML documents.
> > then, depending on what is next use ado.net classes to continue working with
> > the dataset.
> > I access all my ODBC tables using ds
> > search the help for dataset class
> > good luck
> >
> > "Philip Wagenaar" wrote:
> >
> > > I have an application that can be 'queried' by sending an http post, in
> > > return I get an XML file.
> > >
> > > I have another application that can only work with ODBC.
> > >
> > > I am asked to write a 'bridge' between these two.
> > >
> > > What would be the best way to achieve this?

"raulavi" wrote:

> I use a function where I pass my sql strint parameter and return the datatable
>     Public Function ReturnTbl(ByVal SQLParm As String) As DataTable
>         Dim cn As New OdbcConnection(CnString)
>         Dim da As New OdbcDataAdapter(SQLParm, cn)
>         Dim dt As New DataTable
>         Try
>             da.Fill(dt)
>         Catch ex As Odbc.OdbcException
>             '??            Throw New
> DataException(MessageBox.Show(ex.ToString & vbLf & "", "DataBaseException "))
>             'User error msg
>             MsgBox(SQLParm _
>                        & vbLf & vbLf & " " & ex.Message,
> MsgBoxStyle.Critical, "SOSErr ")
>         Catch DBex As DataException
>             Throw New DataException("Unable to retrieve data")
>         End Try
>
>         Return dt
>
>     End Function
>
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconxmldataset.asp
>
>
> "Philip Wagenaar" wrote:
>
> > How can an application access the DataSet through odbc?
> >
> > "raulavi" wrote:
> >
> > > Hi philip:
> > > You could achieve this using a DataSet.
> > > a Dataset can read and write data and schema as XML documents.
> > > then, depending on what is next use ado.net classes to continue working with
> > > the dataset.
> > > I access all my ODBC tables using ds
> > > search the help for dataset class
> > > good luck
> > >
> > > "Philip Wagenaar" wrote:
> > >
> > > > I have an application that can be 'queried' by sending an http post, in
> > > > return I get an XML file.
> > > >
> > > > I have another application that can only work with ODBC.
> > > >
> > > > I am asked to write a 'bridge' between these two.
> > > >
> > > > What would be the best way to achieve this?

> Hi Philip,
>
> Thanks for your post!
>
> For the current issue, as far as I know, there is no interface of XML which
> can be accessed directly by using ODBC driver. If you want to use other
> applications (no .NET application) to access the XML data source, I think
> using XML SDK is a good way.
>
> In addition, you can import the XML data to SQL server and use the ODBC to
> access the SQL Server. Thanks for your understanding!
>
> Regards,
>
> Yuan Ren [MSFT]
> Microsoft Online Support
>
>

> Hi Philip,
>
> Thanks for your reply!
>
> If you use the SQL express, I suggest you save the data as MDF file. And
> then, the client will use it conveniently. If the client has the office
> component, you can also use the Access. It is easy to use as the desktop
> data base engine. Thanks for your understanding!
>
> Regards,
>
> Yuan Ren [MSFT]
> Microsoft Online Support
>
>

> Hi Philip,
>
> Thanks for your reply!
>
> I'm sorry maybe I have a little confusion about the current issue. I
> thought you want to deploy the database to the client so that I suggested
> you save the data base to the mdb file. If you deploy the data base to the
> server, please use ODBC driver to connect the SQL data base freely. It's
> OK. Thanks for your understanding!
>
> Regards,
>
> Yuan Ren [MSFT]
> Microsoft Online Support
>
>