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]

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

 

[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

 

[Steve Schroeder]

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

<wink>

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

 

[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/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]

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!

 

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

 

[Paul Clement]

¤ 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)