VB6 Error that connects to SyBase SQL database

Asked By 0 points N/A Posted on -

Hey techyv experts,

I have a macro that I am trying to open a page on a web site, select and copy the entire contents of the page, then paste it into a new workbook. At first, it works properly but when I run it the second time after rebooting my computer, an error message popped up on my screen. Here is the exact error:

Run-time error ‘-2147217865 (80040e37)’”

Automation error

After it appeared, I always get this error every time I make an internet connection. I already tried to set the code to: Refresh BackgroundQuery:= False, but it didn’t make any difference. I immediately got the same error message. I hope someone can help me.

Thanks in advance  to those who will post their assistance!

Answered By 0 points N/A #84260

VB6 Error that connects to SyBase SQL database


Normally Error 80040E37 is generated due to some error in the LDAP domain database table. Ensure that there is no syntax error in the LDAP/domain line. You need to roll back for past LDAP occurrences. Sometimes it may be with the DSN less connection not functioning well. Test the Connection and see it works fine. It may be an illegal memory reference or some hardware failure. Reboot the PC and check again for error. Clean the workspace and rebuild the code. Otherwise I suppose that this code has accidentally integrated the system files. So do a complete system repair and update in order to restore the windows files.

Login/Register to Answer

Related Questions