I have a problem in accessing password protected company data file and I need to work with it through the ASP.

If I run QB manually and type login and password in dialog box I can work with company data file in ASP with no problems.

But I need to make synchronization with another database. In order to that I need this file to be opened automatically(with QB) without any dialog box for login/password.

It there way to do it or there is another solution?

 Thanks.

Just setup "Allow this application to login automatically" QODBC auto-login as per: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? 

The point is that I`m do it, but it`s not working.

I`m use this code : (QB it`s not running)

Set conn = CreateObject("ADODB.Connection")

conn.Open "Driver={QODBC Driver for QuickBooks};DFQ=C:\FileRoot\QuickbooksDB\CCAD Russia - 2005-2006.QBW;OpenMode=M;OLE DB Services=-2;"

And when I`m tying to do something I have the erorr :

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.

/adm/db.inc, line 19

Where line 19 - conn.Open "Driver={QODBC Driver for QuickBooks};DFQ=C:\FileRoot\ .....

May be I do something wrong ?

Thanks.

You need to use VB Demo first to see that auto-login is working correctly before trying to debug your DSNless connection string. See: How do I use the VB Demo for testing?  for more.

Also, if you are using Internet Explorer or a Windows Service you will need to use the QODBC Server Edition. See: How can I see QuickBooks data in a Internet Explorer Browser using Windows XP?  for more on using Internet Explorer.

Good day,

First time I writed :

I have a problem in accessing password protected company data file and I need to work with it through the ASP. If I run QB manually and type login and password in dialog box I can work with company data file in ASP with no problems. But I need to make synchronization with another database. In order to that I need this file to be opened automatically(with QB) without any dialog box for login/password. It there way to do it or there is another solution?  Thanks.

I read all link what you writing, but it still not working.

On my PC I have : Win2003 Server, QB 2003, QB driver 6.0.0.155.

Is it possible to work with password protection company file ? 

And what I must do for it ?

Thanks.

Have you checked that auto-login mode works first? See: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? 

If it's setup correctly, you can leave QuickBooks closed (not running) and connect using VB Demo.

Note: You can't open more than one company file at a time in QuickBooks.

I'm running with the trial software to see if this works, and I have the same problem, with Quickbooks loaded it works great.

With Quickbooks not loaded, no go.  (Using Sample VB Demo)

Quickbooks 2006 Premier Retail

One piece of intermation, on my Integrated Apps preferences, under QODBC properties, I have no way to enter a password.

I can check the "Allow this application to access this company file" box, but all below are grayed out, no "Allow this application to login automatically" and no "Login as:".  The Login As: isn't even there, grayed out or not.

I even followed your 17 step procedure, Intuit problem or not, I can not use or purchase your software with it the way it is.  I can not roll back to 2005, too much new data.  I know it's not your cause, but it is your problem.

FYI, my other apps work fine, just QODBC fails.

I seems to me that if the data is corrupted during the conversion process, there must be some way to fix the data.

Dave.

In short (see post in How do I setup QODBC to auto-login...) I fixed my problem by remove all users from quickbooks and then adding them back in, after step 6 in the 17 step process, remove them and add them back.