I receive the error "20532 - Missing database dll" on the .action in the code below. The code works fine on the development machine, and on one other. When I load it on the 3rd machine I get the error. I've researched this and all articles I've found point to msvcp60.dll and crpe32.dll...
I need to manipulate data in sql tables and then write that data out to a dbaseIII+ file. Is there any way to dump the data out in chunks of multiple records instead of one record at a time?
Yes. Its the exact same database on both machines. I've tried it with the 'left' not there.
set rsttable = cnn.execute("select * from oldnew where new = 'HOME'")
It gives me the same error.
I've tried that. Forgot to add this this will run correctly on Window98 but not its now loaded on windows 2000 server and will not run. If I just use "select * from oldnew" it works but anything more than that, it gives me the error.
I'm trying to run a select query in vb 6 and get the error "too few parameters, expected 1". I believe it has to do with the syntax of the script, but I can't figure out what it is.
Here's my code:
strcnn = "Provider=MSDASQL.1;Persist Security info=False;Data Source=dBASE...
How can I connect to a sql database based on input from the user? In an Access form, the user will enter the name of the server, and the name of the database to be used in the connection string. I need help ASAP. Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.