Connecting to Quickbooks the first time

[joychs]

Re: Connecting to Quickbooks the first time

Yes - Open Quickbooks as Admin - Preferences - Integrated Applications - Remove the Flexquarters entries save, close the screen and then connect from QRB again...

Thanks, that worked!

-Joy

[Kushy]

Re: Connecting to Quickbooks the first time

Yes - Open Quickbooks as Admin - Preferences - Integrated Applications - Remove the Flexquarters entries save, close the screen and then connect from QRB again...

Hi, I can not connect with quickbooks. I receive this:
Could not create ResultSet from DataSource definition.

Could not connect to Database. Error reported was:

Database API specific error
[Microsoft][Administrador de controladores ODBC] Error de SQLSetConnectAttr del controlador
SQL State is: IM006
[QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.

SQL State is: 00000.

I have quickbooks premier 2007 canadian version, with windows 7
Thank you

[Al Buchholz]

Re: Connecting to Quickbooks the first time

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

I have quickbooks premier 2007 canadian version, with windows 7
Thank you

Is this QB CA 2007 with multi currency or not?

I take it you just installed on win 7?
In 2007, windows 7 was barely a dream in Gates' eyes, so I'd try some type of XP mode... If I had win 7 I'd try it for you, but I don't.

Look at this thread from QODBC

I don't have any experience with 2007 and win 7, but if it were my system, I'd google a lot of places and see if any one else has tried this..

(taking my own advice, I found a number of articles regarding this error...) Most of them talk about the QB installation not being complete or trying to run in auto login mode. Do you have QB open to the company file that you want to use and are you using the QuickBooks_cuurentlyopen DNS?

In simple terms are you refreshing a table that QRB already built or one of your own?

When I attack a connection problem, I refresh the company table since it has only one record in it. Then I work on the remaining tables. (Crawl before walking, before jogging.....)

I'd also suggest that you go to QODBC.com and download the latest driver and install it. You can treat the QODBC driver like a trial, but QRB has special magic to avoid the QODBC trial trap so you can use it as long as your QRB license is valid.

Please let us know what you find.

[hairyfingers]

Re: Connecting to Quickbooks the first time

Hi

same problem as everyone else here. my error message:


Could not create ResultSet from DataSource definition.

Could not connect to Database. Error reported was:

Database API specific error
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
SQL State is: IM006
[QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks.

SQL State is: 00000


Quickbooks is open with the company file I want to access logged on. I am in single user mode. It is UK QB2008 Premier Accountant Edition. release R14P. All latest updates installed. I am using Windows XP SP3

- started quickbooks
- logged on to company
- started report builder
- reated new project
- refreshed data, selected company table to download
- got error message

What am I doing wrong?

thanks

Martin

[Al Buchholz]

Re: Connecting to Quickbooks the first time

I am in single user mode. It is UK QB2008 Premier Accountant Edition. release R14P.

go to QODBC.com and download the latest trial of QODBC.

Install, skip the license/registration info, and try again.

Then advise us of the results.

Cheers.

[hairyfingers]

Re: Connecting to Quickbooks the first time

Hi Al

thanks for the reply. I have donwloaded the latest driver (version 10.00.00.269). It doesn't seem to have made any difference I got this message.


Could not create ResultSet from DataSource definition.

Could not connect to Database. Error reported was:

Database API specific error
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
SQL State is: IM006
[QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks.

SQL State is: 00000

I have tried accesing QB direct from the QODBC setup screen using the "test connection to quickbooks" option and it just says quickbooks is not started - when it clearly is.

[Al Buchholz]

Re: Connecting to Quickbooks the first time

If you have multiple versions of QB on your machine, you may need to run the reboot.bat file located in the program directory of the version that you want to run.

It resets the dlls to use that version and can eliminate the problem.

Have you checked with the Intuit sites to see if there are permission issues with your QB version with win 7? Could be something with that. I'm using US versions with win 7 without problems, but non-US versions are an unknown ( to me ).....

[hairyfingers]

Re: Connecting to Quickbooks the first time

excellent!!! that did it. I also have a 2003 version of QB so that must be what was causing the conflict.

thanks very much

Martin

[Al Buchholz]

Re: Connecting to Quickbooks the first time

excellent!!! that did it. I also have a 2003 version of QB so that must be what was causing the conflict.

thanks very much

Martin

Outstanding. You got QB 2003 (UK?) to run on win 7? Another outstanding job..

You may need to use the reboot.bat to move from one QB version to the other... let us know if that is needed or not.

[hairyfingers]

Re: Connecting to Quickbooks the first time

Hi

I'm on windows XP not 7 so UK QB2003 is OK. I'm only using the report builder with QB2008 so hopefully I won't have to use the reboot.bat file again.

thanks for your help

[Al Buchholz]

Re: Connecting to Quickbooks the first time

Hi

I'm on windows XP not 7 so UK QB2003 is OK. I'm only using the report builder with QB2008 so hopefully I won't have to use the reboot.bat file again.

thanks for your help

OK I read another posting in this thread and mistakenly referenced to you.

Thanks for clearing that up.