I am trying to change the SQL command to an odbc database connection
I recorded that in excel and then when I try to run it I get an error of:
Please Login or Register to view this content.
When I debug it highlights this line:Application-defined or object-defined error
Any help would be appreciated thank you.Please Login or Register to view this content.
I found that from an MSDN post but do not fully understand it. I have lots of pivot tables for each connection. How would I go about doing this workaround?Please Login or Register to view this content.
Edit: I also found
Another forum where the guy solved the problem but I can't follow exactly
In the second link I think the guy changed the type of connection then edited the .Commandtext field then changed type of connection back. Could anyone help me confirm this and if so what is the best way to implement it.
Last edited by bugmenot; 07-21-2009 at 05:05 PM.
Correct. If you look at post #8 in that thread there are two subs. The first changes all pivotcache connections from ODBC to OLEDB, the second changes them back. I don't know offhand if that will work as posted in 2007 (which I don't have to test with just now) but you could try it!Originally Posted by bugmenot
Remember what the dormouse said
Feed your head
While I understand the basic concept of it:
I do not understand how I should specifically do this.
My connection string is:
DSN=QuickBooks Data;DFQ=I:\QB.QBW;SERVER=QODBC;OptimizerDBFolder=%UserProfile%\QODBC Driver for QuickBooks\Optimizer;OptimizerAllowDirtyReads=N;SyncFromOtherTables=N
What I'm not sure about as I'm no VB guru is how to change their script.
Here is what I would assume I should try to do:
I am not sure as to exactly what many of the thing in the top and bottom scripts do so it is hard to change them for my sheet. Thanks for the help, I feel like we're almost at the bottom of this!Please Login or Register to view this content.
Anyone able to help me?
Bump
10chars
Bump
help please!
bump. anyone?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks