473,371 Members | 1,508 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,371 software developers and data experts.

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
Nov 21 '05 #1
8 2181
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
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
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
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
:)

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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Vilmar Braz„o de Oliveira | last post by:
Hi all, What can be wrong in the database connection bellow to connect paradox? What is missing?? ----------------------------------------------------------------------------...
4
by: TonyMontana | last post by:
Hello, I've the following problem. I've to read out the data of a custom application. I think (I'm not sure) this application is using a Paradox DB to store it's information. I don't know it...
0
by: Steve Barker | last post by:
I am trying to access Paradox through a .NET Windows application I am writing. I have added a Data Connection to the Paradox table in the Server Explorer of Visual Studio .NET. I have used the...
2
by: Michael Gerbasio | last post by:
Hi, I'm an amateur programmer and I have been using Delphi but want to start using C#. I need to connect to some existing Paradox database tables but I'm not having any luck with it using C#...
0
by: eselk | last post by:
I've got an old DOS Paradox database that I can't get rid of. We have way to many scripts and forms to convert everything at once. Instead we would like to be able to access the Paradox data from...
4
by: eselk | last post by:
I've never really setup or used MS SQL Server (just a couple hours, one day, several months ago). I think MS SQL Server has the ability to use "linked tables", like MS Access does. Is this...
2
by: John Navratil | last post by:
Anyone having any success with the paradox extension? 'pear install paradox' doesn't work. 'pecl install paradox' seem to do something, but none of the px_??? wrapper functions are found. I do...
1
by: Harvest Wind | last post by:
Hi: I have a program in VB 6.0 that connects to an access database and connects to a paradox database (directory)... I query an Access table and it returns the data I need...as the program...
0
by: =?Utf-8?B?dmlzaHJ1dGg=?= | last post by:
how to write data from data set in dotnet to paradox database in c# In this code from Archive Sql Server database, Table named:tmsarcdata I want all the details from tmsarcdata table to move to...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.