Search results for query: *

Don't quite know which forum to put this in so sorry if wrong one. Having trouble with linked server under sql server 7.0 that links to .dbf files using ms jet ole 4.0 provider. when i query a large table it returns around 1000 records then bombs out with error "search key not found in any...

Don't quite know which forum to put this in so sorry if wrong one. Having trouble with linked server under sql server 7.0 that links to .dbf files using ms jet ole 4.0 provider. when i query a large table it returns around 1000 records then bombs out with error "search key not found in any...

tried a couple other options. set up a linked server in enterprise manager using microsoft.jet.oledb.4.0 as the provider and 'dbase III' as the provider string. using query analyzer this statement works: select * from openquery(dbflink,'select * from dbtable') however, if i open the dbf file...

thx john76 for the reply. that is what i ended up doing also and it worked. haven't double checked the results yet as to accuracy but it appears ok. concern i originally had was if there needed to be any parens used to correctly group the data.

using the following text to open copies of .dbf files located on the server: select distinct * from openrowset('Microsoft.Jet.OLEDB.4.0','DBASE III;database=" & serverdb3directory & "','select fld1, fld2 from db3table') " however, now when i want to use the "live" versions of the .dbf files on...

need syntax help on the following join example (all left joins with the field names shown as links). the problem i run into is the link from tbl2 to tbl5 and the proper placement of the parens: tbl1 (fld1) | +--->tbl2 (fld1,fld2) | +--->tbl3 (fld2,fld3) | |...

thot i should update the post. after a LOT of trial and error i got the insert into ... openrowset syntax to work and its very fast. hardest part was the proper setup of the dbase provider syntax. however, as always, once it works the answer looks so simple!!

Unfortunately it is a recordset i have (versus tables) so that is the reason for my question. i need to join the dbase tables/files and have found that the only reliable method is to use the dao provider. so i'm stuck at this point with a dao recordset. the recordset methods include a...

Have a VB6 app that transfers info from dbase to SQLSERVER 7 tables. the app use a dao recordset to join several dbase files and select/group/sum the records. the recordset is then inserted to an sql table using the addnew method. two questions: 1) is there a way to use the "insert into"...

thx again for the input. we actually reinstalled win95 on the pcs that need the app since the alternative was unacceptable. will let you know what i come up with.

After some research decided using sql temp tables would meet my needs. thanks for the suggestion tho.

thx. will pass the info on to our clipper programmer.

Moving single user access db to multi user sql7 db. Currently have a salesman, customer, and orders table. The salesman table has a boolean (yes/no) field. the user is presented with a bound grid where they can select which salesman to include in an orders report by "checking" the boolean...

Need some ideas. Clipper app was moved to fresh win 98 and xp installs from win 95. a routine to search and retrieve data from the win nt 4 server on the old win 95 pcs took around 5 seconds. on the SAME pc with win 98 the routine now takes almost 30 seconds! (and about 15 seconds on a hot...

That worked like a charm. Thx for the help.

i want to send a simple condensed print command thru a dos batch file to my hp laserjet 1200 printer. In the past I have always used Esc&k2S to set my hp Laserjet 6P to condensed. Also i used the same pcl command on an earlier hp 1200. Just hooked up a new hp 1200 and now it won't go...

thx for the posts. it was so simple once i looked closely. there was indeed a reference to a file that was missing. i just copied the file from the programming computer to the users computer and it worked.

did you ever get this issue figured out? i just moved an access application to another computer and all the aggregate queries that use trim(), date() etc get this error. using access 97 on win 95 and moved it to a win98 machine. i am perplexed to say the least.