Knowledgebase
[QXL-ALL] How to export to SQL Server - using SQL Default Driver & ODBC
Posted by Jack - QODBC Support on 24 April 2017 11:33 AM

How to export to SQL Server - using SQL Default Driver & ODBC

Problem Description:

I am using QXL & I want to export QuickBooks Data to SQL Server.

How can I export QuickBooks Data to SQL Server using QXL?

Solution:

You can export QuickBooks Data to SQL Server using QXL. There is two way to export QuickBooks Data to SQL Server.

1. Using SQL Server default driver.
2. Using SQL Server ODBC Driver

Using SQL Server default driver

The first step in adding SQL Server connection is to click on settings icon for QXL options details.

Navigate to "Pro Edition" & click "Add New" button for adding the New connection.

 

Enter connection details (i.e. Connection Name, Connection String) select "SQL Server Driver" as a Connection Type and click "Test Connection" button.

You can insert any value for Connection Name.

Sample SQL Server Connection String Format: Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;

For Example: Server=WIN-O8RQBVCMJFC;Database=Desktop;User Id=sa;Password=sa;

Test Connection Successful.

Click "Save" button to save connection details.

Connection information updated.

The connection is added in the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close".

Now data is ready to export into SQL Server. You can export by clicking on the Export icon from QXL Setup Screen.

QuickBooks Data is exported to the SQL Server.

Using SQL Server ODBC Driver

First, You need to create ODBC DSN for SQL Server which will point to your Database.

I have already created ODBC DSN for SQL Server below property of the DSN.

SQL Server ODBC DSN test connection successful. We will use this DSN in QXL.

The first step in adding ODBC connection is to click on settings icon for QXL options details.

Navigate to "Pro Edition" & click "Add New" button for adding the New connection.

 

Enter connection details (i.e. Connection Name, Connection String) select "ODBC Data Source" as a Connection Type & "Microsoft SQL Server" as Mapping Type and click "Test Connection" button.

You can insert any value for Connection Name.

Sample ODBC Connection String Format: DSN = Data Source Name

For Example: DSN=QXLSQL

Test Connection Successful.

Click "Save" button to save connection details.

Connection information updated.

The connection is added in the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close".

Now data is ready to export into SQL Server. You can export by clicking on the Export icon from QXL Setup Screen.

QuickBooks Data is exported to the SQL Server.

 

(0 vote(s))
Helpful
Not helpful

Comments (1)
Asad Ch
12 June 2017 05:47 PM
Finding the connection string from Visual Studio while connecting your application with database sometimes difficult.Recently I found a simple way to get accurate connection string to connect to the database.
1.Go to server explorer in Visual Studio.
2.Select your current database and the open its properties.
3.Here you can find the connection string. Simply copy it and use it in the code.
4.That's it

Source: - <a href="http://www.thepaktech.com/easiest-way-get-sql-server-database-connection-string-visual-studio/">Easiest way to get connection string from visual studio</a>
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).