VB.Net Joining Paradox and SQL Server Table?

[Roger]

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 Schroeder]

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" <da*****@netins.net> wrote in message
news:%2****************@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]

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" <ss********@merchant-gould.com> wrote in message
news:ue**************@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" <da*****@netins.net> wrote in message
news:%2****************@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]

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" <da*****@netins.net> wrote in message
news:%2****************@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 Schroeder]

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

<wink>

"smith" <rc********@smithvoiceTAKEOUT.com> wrote in message
news:s1*****************@newsread2.news.pas.earthl ink.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" <da*****@netins.net> wrote in message
news:%2****************@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]

:)

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/articl...itorialsID=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" <ss********@merchant-gould.com> wrote in message
news:OH**************@tk2msftngp13.phx.gbl...

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

<wink>

"smith" <rc********@smithvoiceTAKEOUT.com> wrote in message
news:s1*****************@newsread2.news.pas.earthl ink.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" <da*****@netins.net> wrote in message
news:%2****************@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 Schroeder]

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" <rc********@smithvoiceTAKEOUT.com> wrote in message
news:1s****************@newsread2.news.pas.earthli nk.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/articl...itorialsID=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" <ss********@merchant-gould.com> wrote in message
news:OH**************@tk2msftngp13.phx.gbl...

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

<wink>

"smith" <rc********@smithvoiceTAKEOUT.com> wrote in message
news:s1*****************@newsread2.news.pas.earthl ink.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" <da*****@netins.net> wrote in message
news:%2****************@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 Young]

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" <da*****@netins.net> wrote in message
news:eF**************@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" <ss********@merchant-gould.com> wrote in message
news:ue**************@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" <da*****@netins.net> wrote in message
news:%2****************@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 Clement]

On Fri, 1 Apr 2005 11:44:02 -0600, "Roger" <da*****@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)