VB6 Error that connects to SyBase SQL database

Asked By anddy. 0 points N/A Posted on - 07/18/2011

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!

• Status: Open
• Question Views: 1564
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Sybase Database

Answered By Andrew99 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.

About Andrew99

Questions
0

Answers
5

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 07/28/2011
• Question Category: Sybase Database