I am doing some dev work with the simple start version of QB,  I intend to used the remote connector to create a linked server in SQL 2005 and do some integration jobs to pull QB data into a datamart for a client.  For some reason I am prompted for a password which I do not know.  I've reset the co password on the sample db to blank.  Any ideas what I am missing?  At this point I am just working on my dev machine, an XP Workstation (not a server).

thanks!

See: I do not want to install QuickBooks on every machine. How do I setup QODBC Remote? 

The username you should be using is: admin regardless whether the password is blank or a value in your company file. It might be easier to turn off (uncheck) require authentication for now.

Thanks Tom,

Even if I have require authentication unchecked I am still presented with a login but admin & null password does not work.  I am using the simple start version with the sample database.  I have verified that the password is null on that file.  Just to be sure I downloaded the new version this morning (.214) but the problem is still present.  

I need to use this to fill up a datamart for a client... I hope I can get it to work!

thanks
LindaB

I was able to solve it!  That's what a good nights sleep will do :-)

The cert was not registered within QB.  Somehow when I uninstalled, it went away but didn't come back when I reinstalled.  I set QB to always ask about certs and when I fired the thing off again, it asked... I said ok and I was able to get a connection.

Now, I can get to work on DTS package.  Thanks!

Note: The rule is ALWAYS use VB Demo to run through the DSN used by your application first before setting up the Remote Connector. Make sure VB Demo can use the connection on the computer with QuickBooks first in unattended mode as per How do I setup QODBC to auto-login into QuickBooks and start it if it's not running?, then setup the QODBC Remote Connector on the computer with QuickBooks and make sure VB Demo still works. Then copy the settings to the computers without QuickBooks as per:  I do not want to install QuickBooks on every machine. How do I setup QODBC Remote?  
 
BTW: The password is the password for the company file, not something made up between the QODBC Remote Connector and the iBiz Remote Connector.

Thanks Tom.

I did what you asked.  Sucessfully used the VBdemo in unattended mode.  Then setup the Remote connector and when I run VBdemo it asks for Login.  I know the password is the password for the co file.  In this case it is null.  And I've told the connector to NOT require authentication.  This is pretty urgent as I am up against an install deadline myself.

Could this be because I am using the free trial of quickbooks?  the Simple Start?  I do not want to have to BUY a copy of QB then find it's the same problem.  Maybe it's that problem with the SDK?

yes, that is what it is.

it prompts me with a login box with the admin as the user, password on that file IS null.

No it's not sucessful.  If it were I could just put a password in a connection string or something.
There is something not working about the Remote Connector.   I've read all the FAQ's and everything I can find.  I need some tech support before I buy this thing.  I think I've got it all set up correctly but it does not work.  Where do I look next?  I am out of ideas!

As I said before I can connect unattended with odbc, but as soon as I put the remote connector into the picture I start getting prompted for login (if "ask for password if invalid" is yes) even tho I've not restricted access.   And no userid / password combination will work, it just wont let me in.  If I uncheck "ask for password" it just fails.

Is the iBiz Remote Connector running in your System tray? If yes, try setting QODBC back "Use the company file that's open in QuickBooks". Make sure QuickBooks and the company file is open and try connecting using the remote connector using VB Demo again.

Note: You must do this on the computer that has QuickBooks on it.

Ok, I have done everything you asked.... it's been that way all along because I read the FAQ.  Now, I have removed the Sample start version of QB and installed a real version of QB Pro 2007.  SAME PROBLEM.  I can not buy this product if I don't get this working!  Please tell me something to check that is not already in the FAQ?  I am using the sample database within QB (sample_product-based business.qbw) could that be a problem?  The password on that file is blank.