Wrox Programmer Forums
|
BOOK: Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports by Paul Turley; ISBN: 978-1-119-25835-3
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 18th, 2017, 09:06 PM
Registered User
 
Join Date: Jul 2017
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
 
Old July 27th, 2017, 07:53 AM
Registered User
 
Join Date: Jul 2017
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
[Microsoft][ODBC SQL Server Driver] TIME OUT ERROR rtr1900 ASP.NET 2.0 Basics 1 November 12th, 2008 09:36 AM
ODBC to text driver mnolting Word VBA 0 October 6th, 2008 06:52 PM
ERROR [42000] [Microsoft][ODBC driver for Oracle][ sanjeev jha General .NET 0 June 28th, 2008 12:50 AM
VBA/ODBC Error. Provider Not Found.Driver not I manO-kumar Access VBA 2 November 24th, 2004 12:59 PM
[ODBC Microsoft Access Driver] !!!Error!!! Varg_88 Classic ASP Databases 3 August 30th, 2004 06:19 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.