VB.Net Joining Paradox and SQL Server Table?

Has anyone done this yet? I know it is easily done in Paradox, but I would
like to do it in VB.Net.

Can anyone point me in the right direction?


Thanks,

Rog

Steve
Fri Apr 01 11:47:34 CST 2005

Would it make more sense to just link the Paradox database in MS SQL, create
a procedure that returns the records you want, and then just have VB.Net
display the results?

"Roger" <davisro@netins.net> wrote in message
news:%23m5flJuNFHA.3188@TK2MSFTNGP10.phx.gbl...
> Has anyone done this yet? I know it is easily done in Paradox, but I
would
> like to do it in VB.Net.
>
> Can anyone point me in the right direction?
>
>
> Thanks,
>
> Rog
>
>

Roger
Fri Apr 01 11:56:44 CST 2005

I would like to change the paradox table. So this query would have to be
created dynamically. We have lots of paradox tables with the same name but
in differnt folders.

Roger


"Steve Schroeder" <sschroeder@merchant-gould.com> wrote in message
news:uetbkMuNFHA.3336@TK2MSFTNGP09.phx.gbl...
> Would it make more sense to just link the Paradox database in MS SQL,
create
> a procedure that returns the records you want, and then just have VB.Net
> display the results?
>
> "Roger" <davisro@netins.net> wrote in message
> news:%23m5flJuNFHA.3188@TK2MSFTNGP10.phx.gbl...
> > Has anyone done this yet? I know it is easily done in Paradox, but I
> would
> > like to do it in VB.Net.
> >
> > Can anyone point me in the right direction?
> >
> >
> > Thanks,
> >
> > Rog
> >
> >
>
>

smith
Fri Apr 01 12:03:04 CST 2005

VB is a general programming tool, Paradox is a database engine. Look to the
database engines for the functionality. In this case the Jet engine can be
used (with VB/C#/Delphi/Whatever speaks COM) to help you out.

If you create a temporary Jet mdb file and programmatically link the
SQLServer and Paradox tables to it (and/or lotus and/or excel and/or Oracle
and/or xBase and/or other Jet files/tables) then you can run SQL against the
linked tables since the Jet engine treats linked tables pretty much the same
as native tables. With this you could possibly get the general results
you're looking for. The Jet engine's unique advantage among engines is that
it makes great middleware.

Look up ADOX for information on doing table linking.

Robert Smith
Kirkland, WA
www.smithvoice.com

"Roger" <davisro@netins.net> wrote in message
news:%23m5flJuNFHA.3188@TK2MSFTNGP10.phx.gbl...
> Has anyone done this yet? I know it is easily done in Paradox, but I
> would
> like to do it in VB.Net.
>
> Can anyone point me in the right direction?
>
>
> Thanks,
>
> Rog
>
>

Steve
Fri Apr 01 12:19:48 CST 2005

Jet still has it's uses??? <gasp>

<wink>

"smith" <rcsTAKEOUT@smithvoiceTAKEOUT.com> wrote in message
news:s1g3e.1756$EE2.1337@newsread2.news.pas.earthlink.net...
> VB is a general programming tool, Paradox is a database engine. Look to
the
> database engines for the functionality. In this case the Jet engine can
be
> used (with VB/C#/Delphi/Whatever speaks COM) to help you out.
>
> If you create a temporary Jet mdb file and programmatically link the
> SQLServer and Paradox tables to it (and/or lotus and/or excel and/or
Oracle
> and/or xBase and/or other Jet files/tables) then you can run SQL against
the
> linked tables since the Jet engine treats linked tables pretty much the
same
> as native tables. With this you could possibly get the general results
> you're looking for. The Jet engine's unique advantage among engines is
that
> it makes great middleware.
>
> Look up ADOX for information on doing table linking.
>
> Robert Smith
> Kirkland, WA
> www.smithvoice.com
>
> "Roger" <davisro@netins.net> wrote in message
> news:%23m5flJuNFHA.3188@TK2MSFTNGP10.phx.gbl...
> > Has anyone done this yet? I know it is easily done in Paradox, but I
> > would
> > like to do it in VB.Net.
> >
> > Can anyone point me in the right direction?
> >
> >
> > Thanks,
> >
> > Rog
> >
> >
>
>

smith
Fri Apr 01 12:31:25 CST 2005

:)

As a bulletproof mulituser database it's value will always be hotly debated,
and I really don't want to step into that particular fire today ;-)

Did you see the previous post about MS announcing that they will be
"overhauling" Jet and releasing a 64bit version? I think Exchange 200x using
Jet under the hood (and MSMQ too, right? Or am I mistaken on that one) is
pretty telling about its power when used correctly for the right goals.
http://redmondmag.com/reports/article.asp?EditorialsID=128

For things like mixing datasources and simply converting ISAMs or converting
big irons to end-user ISAMs without 3rd party costs, Jet is still the king
of the hill.

smith


"Steve Schroeder" <sschroeder@merchant-gould.com> wrote in message
news:OHaWleuNFHA.2520@tk2msftngp13.phx.gbl...
> Jet still has it's uses??? <gasp>
>
> <wink>
>
> "smith" <rcsTAKEOUT@smithvoiceTAKEOUT.com> wrote in message
> news:s1g3e.1756$EE2.1337@newsread2.news.pas.earthlink.net...
>> VB is a general programming tool, Paradox is a database engine. Look to
> the
>> database engines for the functionality. In this case the Jet engine can
> be
>> used (with VB/C#/Delphi/Whatever speaks COM) to help you out.
>>
>> If you create a temporary Jet mdb file and programmatically link the
>> SQLServer and Paradox tables to it (and/or lotus and/or excel and/or
> Oracle
>> and/or xBase and/or other Jet files/tables) then you can run SQL against
> the
>> linked tables since the Jet engine treats linked tables pretty much the
> same
>> as native tables. With this you could possibly get the general results
>> you're looking for. The Jet engine's unique advantage among engines is
> that
>> it makes great middleware.
>>
>> Look up ADOX for information on doing table linking.
>>
>> Robert Smith
>> Kirkland, WA
>> www.smithvoice.com
>>
>> "Roger" <davisro@netins.net> wrote in message
>> news:%23m5flJuNFHA.3188@TK2MSFTNGP10.phx.gbl...
>> > Has anyone done this yet? I know it is easily done in Paradox, but I
>> > would
>> > like to do it in VB.Net.
>> >
>> > Can anyone point me in the right direction?
>> >
>> >
>> > Thanks,
>> >
>> > Rog
>> >
>> >
>>
>>
>
>

Steve
Fri Apr 01 12:41:49 CST 2005

Great article.

I use it for prototyping and simple apps all the time...solid. First cut my
teeth on Jet, hemmed and hawed when ADO first came out, but eventually
absorbed it.

Kinda feel the same about XML and quote-comma-delimited files...but I won't
win any arguments there, lol!

"smith" <rcsTAKEOUT@smithvoiceTAKEOUT.com> wrote in message
news:1sg3e.1763$EE2.877@newsread2.news.pas.earthlink.net...
> :)
>
> As a bulletproof mulituser database it's value will always be hotly
debated,
> and I really don't want to step into that particular fire today ;-)
>
> Did you see the previous post about MS announcing that they will be
> "overhauling" Jet and releasing a 64bit version? I think Exchange 200x
using
> Jet under the hood (and MSMQ too, right? Or am I mistaken on that one) is
> pretty telling about its power when used correctly for the right goals.
> http://redmondmag.com/reports/article.asp?EditorialsID=128
>
> For things like mixing datasources and simply converting ISAMs or
converting
> big irons to end-user ISAMs without 3rd party costs, Jet is still the king
> of the hill.
>
> smith
>
>
> "Steve Schroeder" <sschroeder@merchant-gould.com> wrote in message
> news:OHaWleuNFHA.2520@tk2msftngp13.phx.gbl...
> > Jet still has it's uses??? <gasp>
> >
> > <wink>
> >
> > "smith" <rcsTAKEOUT@smithvoiceTAKEOUT.com> wrote in message
> > news:s1g3e.1756$EE2.1337@newsread2.news.pas.earthlink.net...
> >> VB is a general programming tool, Paradox is a database engine. Look
to
> > the
> >> database engines for the functionality. In this case the Jet engine
can
> > be
> >> used (with VB/C#/Delphi/Whatever speaks COM) to help you out.
> >>
> >> If you create a temporary Jet mdb file and programmatically link the
> >> SQLServer and Paradox tables to it (and/or lotus and/or excel and/or
> > Oracle
> >> and/or xBase and/or other Jet files/tables) then you can run SQL
against
> > the
> >> linked tables since the Jet engine treats linked tables pretty much the
> > same
> >> as native tables. With this you could possibly get the general results
> >> you're looking for. The Jet engine's unique advantage among engines is
> > that
> >> it makes great middleware.
> >>
> >> Look up ADOX for information on doing table linking.
> >>
> >> Robert Smith
> >> Kirkland, WA
> >> www.smithvoice.com
> >>
> >> "Roger" <davisro@netins.net> wrote in message
> >> news:%23m5flJuNFHA.3188@TK2MSFTNGP10.phx.gbl...
> >> > Has anyone done this yet? I know it is easily done in Paradox, but I
> >> > would
> >> > like to do it in VB.Net.
> >> >
> >> > Can anyone point me in the right direction?
> >> >
> >> >
> >> > Thanks,
> >> >
> >> > Rog
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Stephany
Fri Apr 01 16:36:49 CST 2005

I think you might have misunderstood what is meant by linking here.

In SQL Server 2000, you create a 'linked server' which means that you are
linking to the entire Paradox database, not just a specific table.

Once linked you can code the SQL statement as dynamically as you like, but
it is executed against SQl Server, not Paradox thus:

select <column list> from <paradox table> left join <sql server table> on
... etc.

Check out the SQl Server Books On Line for further information.


"Roger" <davisro@netins.net> wrote in message
news:eF76rQuNFHA.1392@TK2MSFTNGP10.phx.gbl...
>I would like to change the paradox table. So this query would have to be
> created dynamically. We have lots of paradox tables with the same name
> but
> in differnt folders.
>
> Roger
>
>
> "Steve Schroeder" <sschroeder@merchant-gould.com> wrote in message
> news:uetbkMuNFHA.3336@TK2MSFTNGP09.phx.gbl...
>> Would it make more sense to just link the Paradox database in MS SQL,
> create
>> a procedure that returns the records you want, and then just have VB.Net
>> display the results?
>>
>> "Roger" <davisro@netins.net> wrote in message
>> news:%23m5flJuNFHA.3188@TK2MSFTNGP10.phx.gbl...
>> > Has anyone done this yet? I know it is easily done in Paradox, but I
>> would
>> > like to do it in VB.Net.
>> >
>> > Can anyone point me in the right direction?
>> >
>> >
>> > Thanks,
>> >
>> > Rog
>> >
>> >
>>
>>
>
>

Paul
Mon Apr 04 07:57:57 CDT 2005

On Fri, 1 Apr 2005 11:44:02 -0600, "Roger" <davisro@netins.net> wrote:

¤ Has anyone done this yet? I know it is easily done in Paradox, but I would
¤ like to do it in VB.Net.
¤
¤ Can anyone point me in the right direction?
¤

What are the data types of the fields you are trying to join?


Paul
~~~~
Microsoft MVP (Visual Basic)