I get the following exeption:

Message:
Invalid authorization specification
Invalid connection string attribute

Source:
Microsoft OLE DB Provider for SQL Server

Any ideas guys?

AB

ASP.NET
How to: Connect to an QODBC Database Using the SqlDataSource Control

You can use the SqlDataSource control to connect to any database that supports Open Database Connectivity (ODBC) by storing connection string information in the Web application's Web.config file and then referencing the connection string from your SqlDataSource control.

To configure a connection string for ODBC in the Web.config file
Open the Web.config file in the root directory of your ASP.NET application. If you do not have a Web.config file, create one.

In the Configuration element, add a ConnectionStrings element if one does not already exist.

Create an add element as a child of the ConnectionStrings element, defining the following attributes:

name Set the value to the name that you want to use to reference the connection string.

connectionString Assign the connection string that is required by the database you are connecting to, setting the appropriate driver, server name, and authentication information.

providerName Assign the value "System.Data.Odbc", which specifies that ASP.NET should use the ADO.NET System.Data.Odbc provider when making a connection with this connection string.

The connection string configuration will be similar to the following example. In this example, the connection string values are used to connect to QuickBooks by using an ODBC provider.

<configuration>
    <connectionStrings>
        <add
            name="QODBCDataConnectionString"
            connectionString="DRIVER={QODBC Driver for QuickBooks};DFQ=D:\Data\em1996.qbw;SERVER=QODBC;UseDCOM=Y;OpenMode=F;"
            providerName="System.Data.Odbc"
        />
    </connectionStrings>
</configuration>

Save the Web.config file and close it.

To reference the ODBC connection string from a SqlDataSource control
In the page in which you want to connect to the QODBC database, add a SqlDataSource control.

In the SqlDataSource control, specify the following properties:

SelectCommand Set to the query that you want to execute for this data control. The syntax of the query depends on the data source you are accessing.

ConnectionString Set to the name of the connection string that you created in the Web.config file.

ProviderName Set to the name of the provider that you specified in the Web.config file for the corresponding connection string.

Note:  You can also define UpdateCommand, InsertCommand, and DeleteCommand properties. The SqlDataSource control supports commands and functionality not covered here.

The following example shows a SqlDataSource control configured to access the QODBC data source. In the example, the SelectCommand property is set to a SQL query.

<asp:SqlDataSource
    ID="SqlDataSource1"
    Runat="server"
    SelectCommand="Select * From Customer"
    ConnectionString="<%$ ConnectionStrings:QODBCDataConnectionString %>"
    ProviderName="<%$ ConnectionStrings:QODBCDataConnectionString.ProviderName %>" />

You can now bind other controls, such as the GridView control, to the SqlDataSource control.

While your focus has been on how or on how you don't want to use ASP.NET, I think it might be worthwhile at this point to make sure that IIS, QODBC and QuickBooks can all talk to each other first before questioning ASP.NET connection types and connection strings.

See: How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? for the IIS/QODBC/QuickBooks setup requirements and a simple web example to test.

I have attempted to create an asp.net applicatio that runs the following sql : "select * from Customer".

The testdcom.asp works perfectly and successfully. However when running in asp.net I always receive the following error when openning a connection;

ERROR [00000] [QODBC] QB Open Connection Failed. Create DCOM Instance Error = 80070005, Unknown error.. Created qbXMLRP2 OK. ERROR [00000] [QODBC] QB Open Connection Failed. Create DCOM Instance Error = 80070005, Unknown error.. Created qbXMLRP2 OK.

Also QBCust.asp works perfectly. Do you have any idea why asp.net cannot create an instance of the dcom server exectuables?

Do you have a working asp.net project or file that I could download?

I am using iis 5.0 and the version 7.0 of qodbc.

You have QODBC working from your .asp webpages, so it appears that your DCOMs are running. This looks wrong:

string DSN = @"Provider=System.Data.Odbc;DRIVER={QODBC Driver for QuickBooks};DFQ=D:\Data\em1996.qbw;SERVER=QODBC;UseDCOM=Y;OpenMode=F;DSN=Quickbooks Data;OLE DB Services=-2;";

should be:-

string DSN = @"Provider=System.Data.Odbc;DRIVER={QODBC Driver for QuickBooks};DFQ=D:\Data\em1996.qbw;SERVER=QODBC;UseDCOM=Y;OpenMode=F;";

I have attempted to use : "Provider=System.Data.Odbc;DRIVER={QODBC Driver for QuickBooks};DFQ=C:\Program Files\Intuit\QuickBooks Enterprise Solutions 6.0\sample_service-based business.qbw;SERVER=QODBC;UseDCOM=Y;OpenMode=F" as the connection string.

I still receive the same error. I have a hunch that maybe there is a communication issue with qodbc when using IIS and ASP.NET when using the DCOM Servers. Can you reproduce the same error? The exception is thrown when "connection.Open();" is called.