By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,579 Members | 1,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,579 IT Pros & Developers. It's quick & easy.

VB.Net Joining Paradox and SQL Server Table?

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
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

Nov 21 '05 #2

P: n/a
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


Nov 21 '05 #3

P: n/a
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

Nov 21 '05 #4

P: n/a
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


Nov 21 '05 #5

P: n/a
:)

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



Nov 21 '05 #6

P: n/a
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
>
>



Nov 21 '05 #7

P: n/a
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
>
>



Nov 21 '05 #8

P: n/a
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)
Nov 21 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.