RSSBus - Q&A Support Forum
Welcome to RSSBus Forum, where you can ask questions and receive answers from other members of the community.

Most popular tags

Recent questions tagged ado_net

0 votes
1
answer
35 views
asked Sep 11, 2015 by anonymous
I am trying to make an integration with quickbooks . I am using Remote Connector V6 and ADO.NET provider. I am creating an Windows Form Application ,and the connection was ok when I was working with a DB test file that I created just to run some tests. But when I try with another db file ( production db) I get this error : Unknown qbXML COM error What does it mean and How it can be fixed?
0 votes
2
answers
54 views
asked Sep 1, 2015 by anonymous
If I perform 2 calls in succession like this: using(var connection = new QuickBooksConnection(connString)){ SomethingThatUsesTheConnection(connection); SomethingElseThatUsesTheConnection(connection); } I can see in the QuickBooks Desktop UI that the program above is connecting and disconnecting twice. When using the QuickBooks ... way to specify to RSSBus to either use a specified RequestProcessor, session ticket, or just to not end the session after each call?
0 votes
1
answer
331 views
asked Jan 19, 2015 by anonymous
I have downloaded trial version of your ado.net components and am using it to connect to my QBOE company file in my .net VS 2012 console application. I am able to setup a connection to my QBOE company file, retrieve customer information etc but not able to add new customer to my company file. I am following instructions ... a 32-bit process and that QuickBooks 2002 Pro or higher is installed on your system, or use the Remote Connector. (Error: 80040154). Please advise..
0 votes
1
answer
31 views
asked Oct 31, 2014 by anonymous
Hi, I have a problem when getting data from QuickBooks. My PC is set on Danish Culture where the formatting for numbers are opposite the US culture. I have tried forcing my app to the US culture, but this has not helped. Is there a solution to this problem, other then forcing my pc to the US culture?
0 votes
3
answers
189 views
asked Sep 25, 2014 by anonymous
Prior I've been connecting to a QuickBooks Accountant application. The application Im trying to connect to the new Enterprise 15.0 is now completely unable to even see Quickbooks. Any ideas?
0 votes
1
answer
19 views
asked Aug 18, 2014 by anonymous
Is there a way to see if a column is readonly, before you update it? Or do I have to hardcode it defined from your lists? Like this one: http://www.rssbus.com/kb/help/RQR4-A/pg_desktoptable-customers.rst Its with regards to QuickBooks integration V4
0 votes
1
answer
86 views
asked Aug 14, 2014 by anonymous
I'm trying to get all invoice line items for all invoices within a certain time frame. I can query line items like so: SELECT * FROM InvoiceLineItems WHERE InvoiceId = 'ID GOES HERE' When I try to joine InvoiceLineItems I get this error: "Could not execute specified command: QuickBooks only allows certain columns to be ... query by InvoiceId, however when I join Invoices, it isn't aloud. Any help with how I can get by this error would be great. Thanks!
0 votes
1
answer
153 views
asked Jun 22, 2014 by anonymous
When I use Entity Framework to create an invoice like this: QBdb.Invoices.Add(QBInvoice); I want to get the new "ReferenceNumber", but QBInvoice.ReferenceNumber is null after the insert. The new "Id" is there, but I want to use the "ReferenceNumber" in my app. I can close the QB connection, open a new one, and query for the new Invoice as a workaround, but is there a way to get the "ReferenceNumber" from the original Insert?
0 votes
2
answers
1004 views
asked Jan 24, 2014 by anonymous
With the ADO.NET providers for Facebook/Twitter/etc., I can make a post and then immediately retrieve the ID of the post I made with a call similar to: ((TwitterConnection) connection).GetLastResult(); Do I have a way to retrieve this data when using the ADO.NET drivers with a SQL-only interface? It would help if the ... "INSERT INTO Tweets (Text) VALUES ('Make tweet (5:06 PM).')"; DbDataReader rdrDB = cmdDB.ExecuteReader(); // I get no results in this DbDataReader object
0 votes
2
answers
238 views
asked Aug 28, 2013 by anonymous
I get the following error when making an Entity data model from my SAP table: The data type 'time' is currently not supported for the target .NET Framework version; the column 'UPTIM' in table 'RSSBus. SAP.KNA1' was excluded. Let me know how to fix if the error is on my end just following the "Creating An Entity Model" steps In the help file.
0 votes
1
answer
2084 views
asked Oct 23, 2012 by anonymous
I installed QuickBooks Pro 2013 on my server and then tried to run the sample customer.aspx page in your demo. I got the error below. Connection failed: No connection could be made because the target machine actively refused it 127.0.0.1:2080 (Error: FFFFFFFC - Connection failed: No connection could be made because the target machine actively refused it 127.0.0.1:2080).
0 votes
1
answer
787 views
asked Oct 17, 2012 by anonymous
I have tested RSSBus for QB locally and everything works fine. I have referenced it in my project and created a connection string in my web.config. <connectionStrings> <add name="PICSiQBConnectionString" connectionString="Offline=false;Auto Cache=True" providerName="System.Data.RSSBus.QuickBooks" /> </connectionStrings> I then ... problem is. We are evaluating your product and I have gotten the OK to purchase but I would like to resolved this issue first before I do.
0 votes
1
answer
278 views
asked Oct 11, 2012 by anonymous
I noticed in Quickbooks, there can exist multiple jobs for a customer in the Customers table. Whenever I try to insert a job into the table, it adds a new customer instead of making the job a part of the existing customer. How do I add a job to a customer without creating a entire new customer? The insert command I'm using is bascially "INSERT INTO Customers (Name, FullName, ...) VALUES ('JobName', 'Customer:JobName', ...).
0 votes
0
answers
49 views
asked Oct 11, 2012 by anonymous
I noticed in Quickbooks, there can exist multiple jobs for a customer in the Customers table. Whenever I try to insert a job into the table, it adds a new customer instead of making the job a part of the existing customer. How do I add a job to a customer without creating a entire new customer? The insert command I'm using is bascially "INSERT INTO Customers (Name, FullName, ...) VALUES ('JobName', 'Customer:JobName', ...).
0 votes
1
answer
375 views
asked Aug 14, 2012 by anonymous
I am new to salesforce.com but a long time .net developer. I am looking to get data from SF to create dashboards. In using your tool would I be using SOSQL? Do you have information on accessing the SF data such as getting open opportunities and their status?
0 votes
1
answer
1410 views
asked Aug 9, 2012 by anonymous
Hi, We just bought a license for your QuickBooks ADO.NET Data Provider. We have licensed the developer machine and are trying to deploy to our production machine. However, we're getting an error stating "Could not find a valid license for using RSSBus ADO.NET Provider for QuickBooks V3 on this system". Do we need to install the QuickBooks ADO.NET Provider on the server as well as the developer machine?
0 votes
1
answer
218 views
asked Aug 8, 2012 by anonymous
You provide APIs to retrieve information from Salesforce. Is there an option to do the reverse? Push information to Salesforce from 3rd Party Software?
To see more, click for the full list of questions or popular tags.
 
 
Downloads