The account and password needs to be the QuickBooks administrator account: admin

Only the admin account can allow access for the first time.

Your QuickBooks company file must be setup to work in unattended mode. Switch off the remote connector and get it working on the computer running QuickBooks.

First, get auto-login working as per: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? 

Then get the remote connector going on the computer running QuickBooks as per: I do not want to install QuickBooks on every machine. How do I setup QODBC Remote? 

And only then copy the QODBC settings on any computers not running QuickBooks.

I went through all these steps and everything was already set up as discussed in the links you gave me.  When I connect with QB open everything is fine, the second I close it nothing will connect at all, even the VB application.  I then go in to the setup screen and configure it to use the Remote Connector and provide a username and password, I type in admin and the same password that I use to log into QB.  When I then go to run the VB Demo I am prompted to enter the username and password but they don't seem to work. 

I stated that in my first post on this thread and you've never really addressed my issue, you just keep pointing me to things created for other issues. Please be a little more helpful than pointing me to all the documentation that I've already used to get this this point.

I'm going to list my error messages for your reference:
2007-05-03 09:12:29 QODBC Ver:  7.00.00.214 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused

2007-05-03 09:13:02 QODBC Ver:  7.00.00.214 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused

2007-05-03 09:13:47 QODBC Ver:  7.00.00.214 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 8004041d, This application is not allowed to log into this QuickBooks company data file automatically. The QuickBooks administrator can grant permission for automatic login th
rough the Integrated Application preferences.
Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"

2007-05-03 09:15:14 QODBC Ver:  7.00.00.214 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040414, A modal dialog box is showing in the QuickBooks user interface. Your application cannot access QuickBooks until the user dismisses the dialog box.
Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"

2007-05-03 09:18:14 QODBC Ver:  7.00.00.214 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. User Canceled

2007-05-03 09:27:05 QODBC Ver:  7.00.00.214 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. User Canceled

One more note, the QB file is on the same machine as SQL and where I'm using the VB Demo, I'm only using the Remote connector because if I don't use the connect I get errors, if I do use the connector I at least get a login prompt which tells me that I'm at least hitting the QB file.

I just tried turning it off again and the VB Demo would not work at all, then I opened QB and tried it and it runs fine.

Thoughts?

Matt

Like it or not, unattended mode is still not working. This means you will not be able to connect to the company file unless QuickBooks and the company file is open.

You must get auto-login working as per: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? 

And as you already said, "I've done that", but that doesn't matter if it doesn't work? The same topic also points to: After upgrading to QuickBooks 2006 or 2007, QODBC "auto-login" unattended mode no longer works? which provides a workaround to get unattended mode working. There is a known problem that exists in the QuickBooks qbXML SDK from Intuit, caused by QuickBooks when upgrading an existing QuickBooks company file to the new 2006 (or 2007) USA format or even adding new user accounts to your QuickBooks company file.