|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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 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? Show quote "Roger" <davi***@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 > > 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 Show quote "Steve Schroeder" <sschroe***@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" <davi***@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 > > > > > > 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. Show quote "Roger" <davi***@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" <sschroe***@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" <davi***@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 >> > >> > >> >> > > 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 Show quote "Roger" <davi***@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 > > Jet still has it's uses??? <gasp>
<wink> Show quote "smith" <rcsTAKE***@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" <davi***@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 > > > > > > :) 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 Show quote "Steve Schroeder" <sschroe***@merchant-gould.com> wrote in message news:OHaWleuNFHA.2520@tk2msftngp13.phx.gbl... > Jet still has it's uses??? <gasp> > > <wink> > > "smith" <rcsTAKE***@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" <davi***@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 >> > >> > >> >> > > 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! Show quote "smith" <rcsTAKE***@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" <sschroe***@merchant-gould.com> wrote in message > news:OHaWleuNFHA.2520@tk2msftngp13.phx.gbl... > > Jet still has it's uses??? <gasp> > > > > <wink> > > > > "smith" <rcsTAKE***@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" <davi***@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 > >> > > >> > > >> > >> > > > > > > On Fri, 1 Apr 2005 11:44:02 -0600, "Roger" <davi***@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)  |
|||||||||||||||||||||||
Other interesting topics