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
I'm getting error message
Please Login or Register to view this content.
Run time error -2147467259(80004005)
Automation error,Unspecified error
Can you guide me to resolve this error
Check the "Microsoft Office 16.0 Access Database engine object library"
please ignore you where trying to connect to SQL, not access.
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
Last edited by VBALearn12; 03-04-2019 at 06:56 AM.
Hi, maybe you can check your firewall, check this link
What makes you think the Dim line is causing the problem?
Everyone who confuses correlation and causation ends up dead.
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
But I got following errorPlease Login or Register to view this content.
Object Reference.png
Can you guide me to resolve this issue?
On which line?
You should never dim as new. Always use separate dim and set lines:
Please Login or Register to view this content.
OK rorya. I will do that. Can you please help me to resolve the execution of sql query mentioned in my previous post?
Maybe, if you answer my question about which line actually causes the error?
Originally Posted by rorya
Please Login or Register to view this content.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks