Alpha DAO problem

[David]

I have A5V9, Qbks 2013 Pre. the newest QODBC (trial version) Windows 7 64 bit
Last week I created an import from Qbks into A5 using QODBC. It was from Salesorderline in Qbks.
Everything worked as expected.
Today when I try to run the import, I get an error message stating that I am trying to open 2 copies of Qbks. I go to the Task Manager and there is 2 instances of QB32.exe
Then A5 is locked and I have to shut it down form Task Manager, then I shut down Qbks normally, then in Task Manage shut down the extra program QB32.exe.
Then when I try again, the xtra program of Qbks doesn't show up until I try to run the import again. If I try to do this with Qbks not running, I get an error message, see attached pic.
I thought when I set this up that it would access the Qbks file that is already open. Something has changed and I don't know what happen


I did not write the code and don't understand it but this is what is used:

dim connectionString as c 
connectionString = "::Name::Qbks1" 

delete options 
dim options as p 
options.ConsolidateArguments= .t.
options.AddTablesToDatabase= .t.
options.ShowProgress= .t.
options.AllowCancel= .t.


delete a_import
dim a_import[0] as p 


a_import[].ObjectName = "SalesOrderLine"
a_import[..].SQLSelectStatement = "SELECT CustomerRefFullName, TxnDate, RefNumber, PONumber, IsManuallyClosed, IsFullyInvoiced, Memo, SalesOrderLineSeqNo, SalesOrderLineGroupDesc, SalesOrderLineGroupQuantity, SalesOrderLineGroupSeqNo, SalesOrderLineTxnLineID, SalesOrderLineItemRefListID, SalesOrderLineDesc, SalesOrderLineInvoiced, SalesOrderLineIsManuallyClosed, CustFldSalesOrderLnBaseColor, CustomFieldSalesOrderLineHOOK, CustFldSalesOrderLnPriority, CustFldSalesOrderLnGrpBaseColor, CustFldSalesOrderLnGrpHOOK, CustFldSalesOrderLnGrpPriority, CustFldSalesOrderLnGrpShippingWt, CustFldSalesOrderLnGrpWire, CustFldSalesOrderLnGrpLnBaseColo, CustFldSalesOrderLnGrpLnHOOK, CustFldSalesOrderLnGrpLnPriority, CustFldSalesOrderLnGrpLnShipping, CustFldSalesOrderLnGrpLnWire, SalesOrderLineItemRefFullName, SalesOrderLineQuantity FROM SalesOrderLine  WHERE (IsManuallyClosed = 0) AND (IsFullyInvoiced = 0)"
a_import[..].SQLType = "Portable"
a_import[..].Arguments = ""
a_import[..].ImportType = "Create table"
a_import[..].LocalTableName = a5.get_path() + chr(92) + "SalesOrderLine"+".dbf"
a_import[..].LocalTableFieldDef = ""
a_import[..].OverwriteOption = "Prompt before overwriting"


dim flagSilent as l
delete args 
dim args as sql::arguments
flagSilent = .f.
delete p 
dim p as p 

p = a5_AlphaDAO_Import(connectionString,a_import,options,flagSilent,args)
'p has an .hasError and .errorText property
'a_import[] has the following properties for each item: .countRecordsImported, .hasError, .errorText, .userCancelled

[David]

Re: Alpha DAO problem

Also in the QODBC setup I have selected "use company file that is now open in Quickbooks"

[Al Buchholz]

Re: Alpha DAO problem

show your connection string

or export it and attach to a message.

[David]

Re: Alpha DAO problem

{A5API=QuickBooks,FileName='.',UserName='Admin'}

[Al Buchholz]

Re: Alpha DAO problem

David did you get a Windows or QuickBooks update in the meantime?

[David]

Re: Alpha DAO problem

I have Windows update set to manual. and last week sometime I turned off automatic updates on Quickbooks. I went and looked and Qbks says last time checked was 09/23/2013, which was Monday of last week and it worked after that. The status says "Nothing new downloaded"

[Al Buchholz]

Re: Alpha DAO problem

Try changing the connection string to open the QB company file and don't have QB already started when you import.

Intuit has been changing the process of allowing multiple copies of QB to run rather than only allowing one copy to run.

You should also reference the QODBC.COM support board to see if there are issues discussed there.

[David]

Re: Alpha DAO problem

I tried the changing the connection string to open the QB company file and QB was not started.

I have posted my problem there and have had several suggestions from them and nothing works yet.

I uninstalled A5 and re-installed and no change. On my uninstall program it allow to delete files that A5 uninstaller does not remove, should I have try to uninstall and remove everything that A5 would have put on my computer?

I have an older verion of QODBC on another compouter using A5 and connecting to QB and have never had this problem.
I have made this connection several times (last week and before) it seems pretty simple and straight forward on how to do this.
One thing that seems to be different is when A5 starts to load, I get a Windows security screen "User Access Control" asking if I want to let A5 to make changes to my hard drive. the first time I ran A5 after the re-install it showed the Publisher as "Alpha" and now it shows "unknown" This may not mean nothing.

[Al Buchholz]

Re: Alpha DAO problem

Guessing - the older computer is XP and the newer computer is a newer windows?

if so, turn off UAC on the new computer and try the import again...

[Tom Cone Jr]

Re: Alpha DAO problem

If the new computer is Windows 7, the advice given here by others (if I recall correctly) is to run the Alpha Five installer as Administrator and specify a destination for the Alpha Five program files OTHER than the default Program Files or Program Files (x86) directories.

[David]

Re: Alpha DAO problem

Guessing - the older computer is XP and the newer computer is a newer windows?

if so, turn off UAC on the new computer and try the import again...

Ok, that worked! Thank you!

I just found it odd that it would stop working, because it had worked at the other setting.

[David]

Re: Alpha DAO problem

If the new computer is Windows 7, the advice given here by others (if I recall correctly) is to run the Alpha Five installer as Administrator and specify a destination for the Alpha Five program files OTHER than the default Program Files or Program Files (x86) directories.

thanks for that, I will search for that and read what it says. I probably won't change anything right now since it is working.