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, 03:14 AM
Registered User
Points: 15, Level: 1
Points: 15, Level: 1 Points: 15, Level: 1 Points: 15, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2017
Location: Chennai
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Last edited by Anoushka; August 28th, 2017 at 02:07 AM.
Reply With Quote
  #3 (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
  #4 (permalink)  
Old July 28th, 2017, 05:06 AM
Registered User
Points: 15, Level: 1
Points: 15, Level: 1 Points: 15, Level: 1 Points: 15, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2017
Location: Chennai
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

Last edited by Anoushka; August 28th, 2017 at 02:08 AM.
Reply With Quote
  #5 (permalink)  
Old July 29th, 2017, 01:59 AM
Registered User
Points: 15, Level: 1
Points: 15, Level: 1 Points: 15, Level: 1 Points: 15, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2017
Location: Chennai
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

Last edited by Anoushka; August 28th, 2017 at 02:08 AM.
Reply With Quote
  #6 (permalink)  
Old July 29th, 2017, 02:00 AM
Registered User
Points: 15, Level: 1
Points: 15, Level: 1 Points: 15, Level: 1 Points: 15, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2017
Location: Chennai
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

Last edited by Anoushka; August 28th, 2017 at 02:09 AM.
Reply With Quote
  #7 (permalink)  
Old July 31st, 2017, 05:10 AM
Registered User
Points: 15, Level: 1
Points: 15, Level: 1 Points: 15, Level: 1 Points: 15, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2017
Location: Chennai
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
  #8 (permalink)  
Old August 7th, 2017, 02:33 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Just for Info

Can you name all the Programming language according to their advancement.
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 11:47 PM.


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