Run time error -2147467259(80004005) for using ADODB.Connection

**VBALearn12** · 03-04-2019, 06:00 AM

I'm trying to connect VBA to sql server f. I'm using Windows server 2016 data center and sql sever management studio V17.3 . So I used following objects in my VBA reference
KiSlR.png
While I'm trying to execute below line

Please Login or Register  to view this content.

I'm getting error message

Run time error -2147467259(80004005)
Automation error,Unspecified error
Can you guide me to resolve this error

**aarona** · 03-04-2019, 06:31 AM

Check the "Microsoft Office 16.0 Access Database engine object library"

please ignore you where trying to connect to SQL, not access.

**VBALearn12** · 03-04-2019, 06:53 AM

Hi aarona, I got access to a client machine & looking like it's Microsoft Azure server. I don't have "Microsoft access" in the system. As per your suggestion, I have added the "Microsoft Office 16.0 Access Database engine object library" Please refer the screen shot.Object Reference.png.
But still I'm getting the same error. Here is the error message
Object Reference.png Kindly suggest

**aarona** · 03-04-2019, 09:50 PM

Hi, maybe you can check your firewall, check this link

**rorya** · 03-05-2019, 02:26 AM

What makes you think the Dim line is causing the problem?

**VBALearn12** · 03-05-2019, 02:59 AM

Hi rorya, I ran the one line code, dim statement initially. The problem got resolved now after changing the statement

Please Login or Register  to view this content.

.
I'm using office 64 bit & wrote following code to pull the data from sql server

Please Login or Register  to view this content.

But I got following error
Object Reference.png

Can you guide me to resolve this issue?

**rorya** · 03-05-2019, 03:03 AM

On which line?

You should never dim as new. Always use separate dim and set lines:

Please Login or Register  to view this content.

**VBALearn12** · 03-05-2019, 05:01 AM

OK rorya. I will do that. Can you please help me to resolve the execution of sql query mentioned in my previous post?

**rorya** · 03-05-2019, 05:13 AM

Maybe, if you answer my question about which line actually causes the error?

**VBALearn12** · 03-05-2019, 05:50 AM

Originally Posted by rorya

Maybe, if you answer my question about which line actually causes the error?

Please Login or Register  to view this content.

**rorya** · 03-05-2019, 05:57 AM

I'd guess you either don't have a table1, don't have permissions to access it, or you need to qualify it with an owner, like dbo.Table1

Run time error -2147467259(80004005) for using ADODB.Connection

LinkBack

Thread Tools

Rate This Thread

Display

Run time error -2147467259(80004005) for using ADODB.Connection

Re: Run time error -2147467259(80004005) for using ADODB.Connection

Re: Run time error -2147467259(80004005) for using ADODB.Connection

Re: Run time error -2147467259(80004005) for using ADODB.Connection

Re: Run time error -2147467259(80004005) for using ADODB.Connection

Re: Run time error -2147467259(80004005) for using ADODB.Connection

Re: Run time error -2147467259(80004005) for using ADODB.Connection

Re: Run time error -2147467259(80004005) for using ADODB.Connection

Re: Run time error -2147467259(80004005) for using ADODB.Connection

Re: Run time error -2147467259(80004005) for using ADODB.Connection

Re: Run time error -2147467259(80004005) for using ADODB.Connection

Thread Information

Users Browsing this Thread

Similar Threads

Run time error'-2147467259(80004005)':

run-time error '-2147467259(80004005)':

[SOLVED] Run-time error '-2147467259(80004005)'

Excel 2010 Run Time Error '-2147467259 (80004005)'

[SOLVED] Run time error '-2147467259 (80004005) adding icon

[SOLVED] Run time error '-2147467259 (80004005) adding icon

Run time error '-2147467259 (80004005) adding icon

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions