Hi

I am tring to connect to quickbook from c# windows application.

it is working in the development machine but when i try to install the same thing is the server

it gives me this error. VB demo is running fine, PHP Web app is running fine. only this one gives me this error

I am trying to do a simple search thats all. query = "select * from item"

I have tried all the possible connection string as

and "DNS=QuickBooks Data"

but nothing happening . seems like it is able to open the odbc connection and then when i am tring to fill a datatable then it gives this error

" ERROR[IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. "

The following code is the minimal code required to create a DataSet from the SQL statement and attaches the dataset to a DataGrid:

Dim cnQODBC As System.Data.Odbc.OdbcConnection
Dim daQODBC As System.Data.Odbc.OdbcDataAdapter
Dim dsQODBC As System.Data.DataSet

cnQODBC = New System.Data.Odbc.OdbcConnection("DSN=QuickBooks Data")
cnQODBC.Open()
daQODBC = New System.Data.Odbc.OdbcDataAdapter("SELECT ListID, FullName, CompanyName FROM Customer", cnQODBC)
dsQODBC = New System.Data.DataSet

daQODBC.Fill(dsQODBC)
dgDataGrid.DataSource = dsQODBC
dgDataGrid.DataBind() 'May or maynot be required depending on where you put this code.

Sorry Still Gives the same error.

It is working in one machine but on the other machine it is not working

i have checked the access rules and almost every thing i knew. but no clue.

:(

Thanks its all working now.