Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
why i cant access a company file through windows service developed in vb.net |
Author |
Message |
joy |
|
Group | : Members |
Posts | : 2 |
Joined | : 2006-08-14 |
|
Profile |
|
Posted : 2006-08-14 19:09:41 |
I had created a windows service in vb.net to access a company file.Bout i am unable to access the company file.If i am accessing throug an application in vb.net i am abel to access the file.Why this is not working in windows service.The error message i am getting is given belove. Microsoft.Data.Odbc.OdbcException: ERROR [00000] [QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.
ERROR [00000] [QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.
at Microsoft.Data.Odbc.OdbcConnection.Open() at estimates.estimates.Get_QBConnection() in D:\VB.Net-Project\Windows Service\joyestimates\estimates\estimates.vb:line 111
I will paste the code belove
Try ' for opening connection to quickbooks If (msodbcConnection Is Nothing) Then msodbcConnection = New OdbcConnection End If If (msodbcConnection.ConnectionString <> "DSN=" & "Quickbooks Data") Then msodbcConnection.Close() msodbcConnection.ConnectionString = "DSN=" & "Quickbooks Data" msodbcConnection.Open() End If Get_QBConnection = True Exit Function Catch ex As Exception 'MsgBox("Invalid DSN Name: " & Err.Description) m_streamWriter.BaseStream.Seek(0, SeekOrigin.End) m_streamWriter.WriteLine(" estimate: QuickBookDatabase error " & ex.ToString & Constants.vbLf) m_streamWriter.Flush() m_streamWriter.Close() Get_QBConnection = False Exit Function End Try
ami doing anything wrong....can anyone of u can help me in this |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-14 23:52:21 |
Our Server Edition of QODBC will allow you to use any web tool you wish to use (IIS, ASP, Cold Fusion, PHP and others) or Windows Service to access data live from QuickBooks without conversion in real time.
The Server Edition is a separate product from the normal desktop editions of QODBC. The reason for this is twofold:
Firstly, as a licensing issue, we must allow for use by potentially hundreds of login's to the machine remotely using the web or Windows Service.
Secondly, not all editions of QuickBooks run as a system service (background task) which is what IIS Web Server Software runs as, so we have developed special software to allow us to communicate with QuickBooks running on the desktop.
See: How do I automatically setup the QODBC DCOM Servers? |
|
|
|
joy |
|
Group | : Members |
Posts | : 2 |
Joined | : 2006-08-14 |
|
Profile |
|
Posted : 2006-08-15 17:00:29 |
Hi Tom, Where can i get trial version(30 days) of QODBC Server Edition.I have licenced copy of desktop version 5.If i get a trial version of server edition i can test it.
Thanks and regards joy.k.k |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-15 20:46:13 |
Because you already have a licensed version of QODBC v5, QODBC v6 will run in that license mode and not in its 30 day evaluation mode when you install it on the computer with the v5 license.
You can either download and install QODBC v6 on another computer, or if you still wish to use the same computer, apply for a 30 day evaluation v6 CD Key by purchasing a QODBC Priority Support Incident. Please be sure to state what version of QuickBooks, including country, you are using.
See: How does the 30 day evaluation work? How can I evaluate the Desktop Edition? |
|
|
|
|