Hello,
I have been using SQLOLEDB without any problems. Today I am getting SQLOLEDB errors with trying to perform the same exact function as yesterday.
oSql:Open( cSql, xSQL )
The source was not changed and it was working perfectly yesterday.
What can I do to insure something did not update on my Windows to cause the problem?
Thank you,
Try a system restore - then set updates to download but you select when to install them
Cheers
Colin
Darrell
Can you be a bit more specific on the error .. your code seems simple enough. Has anything changed on the Sql Server end ? Any field changes that would cause your query to fail ? Has your connection terminated or any new code injected before your Sql Command that may have effected the connection ?
Rick LIpkin
Hi Rick,
It is very, very strange. I am able to run without a problem on any other workstation except mine which is the development machine. I honestly think is has to do with a Java update somehow. I removed Java and now getting strange errors when trying to install. "Computer not connected to Internet" which is absolutely incorrect because I am connected and on the web at the very same time I am installing Java. It is very strange. I may have to wipe workstation and reinstall everything. No Fun!!!
Darrell
Google JavaRA .. this is the java removal tool from MajorGeeks or Softpedia. This will remove all Java traces, folders and reg files.
Once Java has been removed .. get the latest version from Java.com .. Hope that helps.
Rick Lipkin
Thanks Rick,
Well after considerable headaches, I found the problem. There was a Microsoft Security Essentials update that went wrong and basically messed up all my security settings. Once I removed it and re-installed, everything came back to normal. What a pain the B.....
Thanks for your input and assistance.
