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 10: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

Anoushka July 27th, 2017 04:14 AM

Recently I have undertaken Java Training in Chennai. But I am not in Clear in the Connection. Please explain me the ODBC Connection with an example.

Keep following me to gain knowledge in JAVA
Java Training | Java Course in Chennai

philipsfn July 27th, 2017 08: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.

Anoushka July 28th, 2017 06:06 AM

Data Management
 
Whatever may be the domain you are working. Nowadays data are in huge level to maintain properly. Even to give ODBC connection data management is the thing to know first. Make use of Hadoop Training Chennai to manage data in high level.


Keep following my profile to know more about Big Data course in Chennai

Anoushka July 29th, 2017 02:59 AM

Test your application
 
It is not the matter to write code and run it. Please test your application with the effective testing tools like Selenium

Selenium Training in Chennai | Selenium Course in Chennai

Anoushka July 29th, 2017 03:00 AM

Test your application
 
It is not the matter to write code and run it. Please test your application with the effective testing tools like Selenium

Selenium Training | Selenium Training in Velachery

Anoushka July 31st, 2017 06:10 AM

Improve your Website Ranking
 
Java is also used to develop a website like with the help of NetBeans IDE. it is essential to improve your website ranking for your business.

SEO Course in Chennai | Best SEO Training in Chennai

samdee123 August 7th, 2017 03:33 AM

Just for Info
 
Can you name all the Programming language according to their advancement.


All times are GMT -4. The time now is 11:19 PM.

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