p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports (http://p2p.wrox.com/book-professional-microsoft-sql-server-2016-reporting-services-mobile-reports-814/)
-   -   ODBC TEXT DRIVER ERROR (http://p2p.wrox.com/book-professional-microsoft-sql-server-2016-reporting-services-mobile-reports/99579-odbc-text-driver-error.html)

philipsfn July 18th, 2017 09:06 PM

ODBC TEXT DRIVER ERROR
 
Keep getting this error odbc text driver parameters expected 48

Here is the connection string:

DBQ=J:\ISOURCE DATA REPOSITORY;DefaultDir=J:\ISOURCE DATA REPOSITORY;Driver={Microsoft Text Driver (*.txt; *.csv)};DriverId=27;FIL=text;MaxBufferSize=2048;Ma xScanRows=8;PageTimeout=5;SafeTransactions=0;Threa ds=3;UserCommitSync=Yes

This is the SQL:

SELECT otc_sales_history_product_detail_spine.TERRITORY_N UMBER, otc_sales_history_product_detail_spine.TERRITORY_D ESC, otc_sales_history_product_detail_spine.BRANCH_ID, otc_sales_history_product_detail_spine.BRANCH_DESC , otc_sales_history_product_detail_spine.CUSTOMER_NU MBER, otc_sales_history_product_detail_spine.CUSTOMER_NA ME, otc_sales_history_product_detail_spine.CITY, otc_sales_history_product_detail_spine.STATE, otc_sales_history_product_detail_spine.MARKETING_D IVISION_CODE, otc_sales_history_product_detail_spine.MARKETING_D IVISION, otc_sales_history_product_detail_spine.PRODUCT_TYP E_CODE, otc_sales_history_product_detail_spine.PRODUCT_TYP E, otc_sales_history_product_detail_spine.PRODUCT_APP LICATION_CODE, otc_sales_history_product_detail_spine.PRODUCT_APP LICATION, otc_sales_history_product_detail_spine.PRODUCT_LIN E_CODE, otc_sales_history_product_detail_spine.PRODUCT_LIN E, otc_sales_history_product_detail_spine.PRODUCT_GRO UP_CODE, otc_sales_history_product_detail_spine.PRODUCT_GRO UP, otc_sales_history_product_detail_spine.ITEM_GROUP_ CODE, otc_sales_history_product_detail_spine.CATALOG_NUM BER, otc_sales_history_product_detail_spine.SURGEON_NUM BER, otc_sales_history_product_detail_spine.SURGEON_NAM E, otc_sales_history_product_detail_spine.PRIORYEAR_J AN, otc_sales_history_product_detail_spine.PRIORYEAR_F EB, otc_sales_history_product_detail_spine.PRIORYEAR_M AR, otc_sales_history_product_detail_spine.PRIORYEAR_A PR, otc_sales_history_product_detail_spine.PRIORYEAR_M AY, otc_sales_history_product_detail_spine.PRIORYEAR_J UN, otc_sales_history_product_detail_spine.PRIORYEAR_J UL, otc_sales_history_product_detail_spine.PRIORYEAR_A UG, otc_sales_history_product_detail_spine.PRIORYEAR_S EP, otc_sales_history_product_detail_spine.PRIORYEAR_O CT, otc_sales_history_product_detail_spine.PRIORYEAR_N OV, otc_sales_history_product_detail_spine.PRIORYEAR_D EC, otc_sales_history_product_detail_spine.CURRENTYEAR _JAN, otc_sales_history_product_detail_spine.CURRENTYEAR _FEB, otc_sales_history_product_detail_spine.CURRENTYEAR _MAR, otc_sales_history_product_detail_spine.CURRENTYEAR _APR, otc_sales_history_product_detail_spine.CURRENTYEAR _MAY, otc_sales_history_product_detail_spine.CURRENTYEAR _JUN, otc_sales_history_product_detail_spine.CURRENTYEAR _JUL, otc_sales_history_product_detail_spine.CURRENTYEAR _AUG, otc_sales_history_product_detail_spine.CURRENTYEAR _SEP, otc_sales_history_product_detail_spine.CURRENTYEAR _OCT, otc_sales_history_product_detail_spine.CURRENTYEAR _NOV, otc_sales_history_product_detail_spine.CURRENTYEAR _DEC, otc_sales_history_product_detail_spine.F47, otc_sales_history_product_detail_spine.F48
FROM `J:\Isource Data Repository`\otc_sales_history_product_detail_spine .txt otc_sales_history_product_detail_spine

philipsfn July 27th, 2017 07:53 AM

ODBC connection is wha we use to connect an Excel file to the data source. The issue here was that the schema.ini file got deleted hence it could not update. The issue is resolved now. Thank you for your response.


All times are GMT -4. The time now is 08:02 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.