Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old July 18th, 2017, 09:06 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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
Reply With Quote
  #2 (permalink)  
Old July 27th, 2017, 07:53 AM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 08: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 11:59 AM
[ODBC Microsoft Access Driver] !!!Error!!! Varg_88 Classic ASP Databases 3 August 30th, 2004 06:19 AM



All times are GMT -4. The time now is 12:55 PM.


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