OLE DB provider 'MSDASQL' reported an error

Fusei

New Member
I'm trying to run this code: \[code\]<%Dim rsSelectOrderDim rsSelectOrder_numRowsSet rsSelectOrder = Server.CreateObject("ADODB.Recordset")rsSelectOrder.ActiveConnection = MM_conn_to_mhwebdb_STRINGrsSelectOrder.Source = "SELECT * from " & ActinicPersons &" p, " &ActinicOrders&" o WHERE p. [Contact ID] = o.[Invoice Contact ID] AND o.[Order Number] NOT IN ( SELECT OrderNumber from dbo.tbl_OrdersEntered )"rsSelectOrder.CursorType = 0rsSelectOrder.CursorLocation = 2rsSelectOrder.LockType = 1rsSelectOrder.Open()rsSelectOrder_numRows = 0%>\[/code\]Using the following connection:\[code\]<%' FileName="Connection_odbc_conn_dsn.htm"' Type="ADO" ' DesigntimeType="ADO"' HTTP="true"' Catalog=""' Schema=""Dim ActinicPersons, ActinicOrders, ActinicOrderLines, ActinicPaymentsActinicPersons = "OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\inetpub\ActinicOrderFiles\;','select * FROM persons.csv')"ActinicOrders = "OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\inetpub\ActinicOrderFiles\;','select * FROM orders.csv')"ActinicOrderLines = "OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\inetpub\ActinicOrderFiles\;','select * FROM orderlines.csv')"ActinicPayments = "OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\inetpub\ActinicOrderFiles\;','select * FROM payments.csv')"%>\[/code\]Unfortunately even running this code in server management I see the following error message: OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".Any ideas on how to fix it? I have setup DSN for the connection
 
Back
Top