User Profile

Collapse

Profile Sidebar

Collapse
pmurch
pmurch
Last Activity: Nov 13 '13, 10:28 PM
Joined: Nov 12 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pmurch
    replied to Calling a SQL Server Stored Proc that contains a CREATE TABLE
    in Excel
    Thanks, Rabbit. That appears to be the issue. Had looked at the permissions at the beginning of troubleshooting , but apparently missed an important setting. Your pointing me back to permissions was an excellent idea -- thanks!
    See more | Go to post

      Leave a comment:

    • pmurch
      replied to Calling a SQL Server Stored Proc that contains a CREATE TABLE
      in Excel
      Sorry -- I debated how much detail to get into, and apparently I erred too much on the lean side.

      What's the macro code?
      ---------------------
      Code:
      cnnConnect.Open "Provider=SQLOLEDB.1;Initial Catalog=" & dbnShort _
            & ";Data Source=myservername;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;" _
            & "Use Encryption for Data=False;Tag with column
      ...
      See more | Go to post
      Last edited by Rabbit; Nov 12 '13, 11:45 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.

        Leave a comment:

      • pmurch
        started a topic Calling a SQL Server Stored Proc that contains a CREATE TABLE
        in Excel

        Calling a SQL Server Stored Proc that contains a CREATE TABLE

        I have a VBA macro that kicks off a SQL Server stored procedure. During development all was well, until we added code to the stored proc to take a before/after snapshot of changes made. Without modifying the VBA macro, if we remove the CREATE TABLE code, the macro works fine. If we include it, it crashes with an 8004E021 error. We've tried creating the table both in memory and on disk; behavior is the same.

        Is there a setting on...
        See more | Go to post
        No activity results to display
        Show More
        Working...