SQL Server – How to Setup a Data Source in SSRS to MS Access, MS Excel, and CSV Files #ms #access #crm


#

SQL Server How to Setup a Data Source in SSRS to MS Access, MS Excel, and CSV Files

Not all data will come from a SQL Server database when you are creating reports in SSRS. There will be times you will need to create a data source to .CSV files, Excel spreadsheets, and MS Access databases.

Recently, I had a customer request setting up sample data sources to these types of files to help the developers complete a migration project.

Items Needed to be Installed on the SSRS Server

The first thing you will need are executables from Microsoft to enable OLEDB and ODBC connections to the source data. SSRS will not be able to use ODBC or OLEDB until the specific drivers for these types of files are installed on the server.

You will need to download and install the following on your SSRS server. While these look to be just for MS Access, they include the drivers for connecting to Flat files and MS Excel as well.

NOTE: I would recommend installing the 64 bit version first, and then the 32 bit version to help save some time troubleshooting the issue of trying to install a 64 bit version once the 32 bit version is already installed.

For Testing

The system is ready to set up the data sources once the drivers are installed on the server. For testing purposes, I have a folder containing sample files for the different types of data sources I would like to connect to:

How to Create a Data Source for MS Excel Files (.xls. xlsx)

We will need to create an ODBC connection on the server to the Excel file before creating a data source in Report Manager.

1. Create a system DNS using the Microsoft Excel Driver (*.xls)

2. Create a meaningful name for your data source. The name will be used later in SSRS when creating the connection string.

3. Make sure to select the correct version of Excel you are wanting to connect and then select Workbook button:

4. Navigate to the location of the document and select the file. Complete the process of creating the system DSN.

You will now be able to create and test your data source in SSRS.

Creating the Data Source in SSRS

1. Open the Report Manager and navigate to the folder structure of where you would like to save your data source. Select New Data Source .

2. Give your data source a descriptive name. Create a good description of the data source for documentation purposes.

3. Select ODBC as your Data Source Type from the drop down menu.

4. Your connection string is Dns=xxx , where xxx is the name you gave your system DSN.

5. Make sure to test your connection, and then select OK.

When writing your query for the report, you will reference your sheet in the excel file which has the data you are wishing to display on the report.

Example: select * from [Sheet1$]

Creating a Data source to .CSV file

For this process, you will use OLEDB to connect to the data source. The main item to note is the data source is defined to look a directory instead of a physical file. If you use a central location for all the .csv files to be located, you will only need to create one data source in SSRS. The queries inside your report will dictate which file the report is pulled from. If you are worried about security, you could set up multiple locations for the files and create individual data sources for the structure.

Unlike connecting to a MS Excel file, you will not need to create a SYSTEM DNS before creating your data source in SSRS.

Navigate to the location you would like your data source to be stored in Report Manager and select new data source.

Give your data source a meaningful name and don t forget to provide a description for documentation purposes.

For your Data Source Type select OLEDB. You will be using the Microsoft.ACE.OLEDB.12.0 provider which was installed with the executables during the system set up listed above.

For your connection string, your provider is Microsoft.ACE.OLEDB.12.0 and the source is the path to the folder which contains your file. For this example, we are assuming the file does not contain a header row. (HDR=No in the properties)

Your connection string will look something like this.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:SampleDataSourceFilesSampleDataSourceSampleFiles;Extended Properties= text;HDR=No;FMT=Delimited

Once your Data source connection has been created, you can test it by creating a simple report. Below is an example of a query you would use in Report Builder to display the information from a file called samplecsv.csv .

Example: select * from samplecsv.csv

To Create a Data Source to an MS Access database (*.accdb files)

To create a data source to an MS Access database, you will use OLEDB Data source type. The sample shown below is a connection to the MS Access 2010 version of the Adventureworks database.

For your connection string, your provider will be Microsoft.ACE.OLEDB.12.0 and your source will be the physical location of the .accdb file.

After the Data sources have been setup, I always like to create a couple of quick same reports to insure they are working as expected.

This process was testing on the following architecture:

Windows 2012R2, SQL Server 2014, Reporting Services 2014

Windows 2008r2 SP1, SQL Server 2012, Reporting Services 2012

Thanks for taking the time to read this post. Feedback is always welcome.

If you have questions on getting Data Sources set up in SSRS or need assistance with configuring SSRS for performance or SQL Server in general, reach out to us! XTIVIA can assist you with your Reporting Service needs.

Related posts:


Treatment Guidelines for Lyme Disease from ILADS #ms #treatment #guidelines


#

Treatment Guidelines

Evidence Assessments and Guideline Recommendations in Lyme disease:

The Clinical Management of Known Tick Bites, Erythema Migrans Rashes and Persistent Disease

by The International Lyme and Associated Disease Society (ILADS)

The ILADS guidelines address three clinical questions – the usefulness of antibiotic prophylaxis for known tick bites, the effectiveness of erythema migrans treatment and the role of antibiotic retreatment in patients with persistent manifestations of Lyme disease.

  • Grading of Recommendations Assessment, Development and Evaluation-based analyses found the evidence regarding these scenarios was of very low quality due to limitations in trial designs, imprecise findings, outcome inconsistencies and non-generalizability of trial findings.
    • It is impossible to state a meaningful success rate for the prevention of Lyme disease by a single 200 mg dose of doxycycline because the sole trial of that regimen utilized an inadequate observation period and unvalidated surrogate end point.
    • Success rates for treatment of an EM rash were unacceptably low, ranging from 52.2 to 84.4% for regimens that used 20 or fewer days of azithromycin, cefuroxime, doxycycline or amoxicillin/phenoxymethylpenicillin (rates were based on patient-centered outcome definitions and conservative longitudinal data methodology).
    • In a well-designed trial of antibiotic retreatment in patients with severe fatigue, 64% in the treatment arm obtained a clinically significant and sustained benefit from additional antibiotic therapy.
  • The optimal treatment regimen for the management of known tick bites, EM rashes and persistent disease has not yet been determined. Accordingly, it is too early to standardize restrictive protocols.
  • Given the number of clinical variables that must be managed and the heterogeneity within the patient population, clinical judgment is crucial to the provision of patient-centered care.
  • Based on the Grading of Recommendations Assessment, Development and Evaluation model, International Lyme and Associated Diseases Society recommends that patient goals and values regarding treatment options be identified and strongly considered during a shared decision-making process.

Reconciling divergent guidelines

The ILADS panel recommendations differ from those of the IDSA. Different guideline panels reviewing the same evidence can develop disparate recommendations that reflect the underlying values of the panel members, which may result in conflicting guidelines. The IOM explains that conflicting guidelines most often result ‘when evidence is weak; developers differ in their approach to evidence reviews (systematic vs non-systematic), evidence synthesis or interpretation and/or developers have varying assumptions about intervention benefits and harms. Conflicting guidelines exist for over 25 conditions and there is no current system for reconciling conflicting guidelines. Supplementary Appendix I reconciles the differences between the ILADS and IDSA treatment recommendations by clinical situation.

Click here for full access to the 2014 ILADS peer reviewed guidelines.

1. Shaneyfelt TM, Centor RM. Reassessment of clinical practice guidelines: go gently into that good night. Jama, 301(8), 868-869 (2009).

2. Clinical Practice Guidelines we can trust. Available from http://www.nap.edu/catalog.php?record_id=13058. last accessed 10/30/14.

Diagnostic Hints and Treatment Guidelines for Lyme and Other Tick Borne Illnesses:

by Joseph J. Burrascano Jr. MD

In general, you can think of Lyme disease as having three categories: acute, early disseminated, and chronic. The sooner treatment is begun after the start of the infection, the higher the success rate. Undertreated infections will inevitably resurface, usually as chronic Lyme, with its tremendous problems of morbidity and difficulty with diagnosis and treatment So, while the bulk of this document focuses of the more problematic chronic patient, strong emphasis is also placed on earlier stages of this illness where closest attention and care must be made.

Amazingly, this edition is not only the sixteenth in the series, but as the first edition appeared in 1984, this reflects twenty four years of effort!

Since the last edition, enough new information has become available to justify this revision. New insights regarding co-infections, tests and treatment regimens are included. Information included here is based on the literature, presentations at scientific meetings, the many valuable observations noted by my colleagues, plus experience from caring for my own patients. Please use the information presented in this document as an information resource and guide. It can never replace your own experience and clinical judgment. To download the entire 16th edition of the guidelines, click below

ILADS Response to IDSA Treatment Guidelines Process

Below is a letter from ILADS to the Infectious Diseases Society of America (IDSA), the American Academy of Neurology (AAN), and the American College of Rheumatology (ACR) regarding their Lyme Disease Clinical Practice Guideline Development Panel.


Saint Joseph’s University #online #mba, #online #master’s #of #business, #master’s #of #business, #master’s #business, #business #master’s, #m.s. #in #business, #ms #in #business, #master’s #of #business #administration, #masters #of #business #administration, #haub #mba, #sju #mba, #saint #joseph’s #university #mba, #part-time #mba, #part #time #mba, #mba #rankings, #mba #programs, #top #mba #programs, #international #mba #ranking, #mba #ranking, #mba #business #school #rankings, #collegeville #mba, #collegeville #business #program, #philadelphia #mba, #part-time #philadelphia #mba, #philly #mba, #fast #track #mba, #accelerated #mba, #professional #mba, #top #ranked #mba, #top-ranked #mba, #us #news # # #world #report #mba, #full-time #mba, #part-time #mba #gmat #prep


#

Welcome to Philadelphia s top-ranked Erivan K. Haub School of Business. MBA Program. Our uniquely flexible graduate business program is focused on you and your career, combining strategic leadership skills with relevant functional expertise. By integrating creative thinking, effective communication, project management, and technology applications into a relevant business context, this program provides the foundation you need to effectively succeed and distinguish yourself in your field, your organization, and your industry.

Click below to learn about our MBA Direct Admissions Program with Ursinus College.

Saint Joseph s University offers you the flexibility of an evening program at our convenient Philadelphia Main Campus location. We also offer a Fully Online program with no residency requirement. You can choose to customize your schedule by blending online and on campus options. You can also expect the same tuition rate for on campus and online courses. What s more, our staff, faculty, and students are united in the Jesuit ideal of cura personalis, care for the whole person, and are dedicated to helping you succeed in the classroom as well as in life.

The Haub School is AACSB-accredited in Business and Accounting less than 5% of business schools worldwide meet this dual standard of excellence.

U.S.News World Report, Princeton Review, and Business Week have all ranked the Haub School as one of the nation s top graduate business schools.

Saint Joseph’s University is one of only 142 schools nationwide with a Phi Beta Kappa chapter and AACSB business school accreditation, and has been recognized by Beta Gamma Sigma for five consecutive years with Outstanding Chapter Awards, including the 2010 Gold Chapter Award.


MS in Mathematics #ms #mathematics


#

M.S. In Mathematics

Program Overview

The Master of Science option is primarily a program in applied mathematics. It provides an alternative to the traditional MS degree in mathematics. The program is designed to serve those interested in the application of mathematics in industry, business, and government. The program stresses the development, analysis, and evaluation of mathematical models of real-world problems and those areas of pure and applied mathematics that are germane to this process.

Admission Requirements

Prerequisites: baccalaureate degree in mathematics, engineering, or another scientific or technical area; and should have completed a sequence in calculus and analytic geometry, as well as courses in linear algebra and differential equations; and at least eight credits in junior-or senior-level mathematics courses.

GRE Requirement. Not Required

Degree Completion Requirements

MS degree candidates must earn 36 credit hours distributed as follows:

Required Introductory course

· MTH 514 – Linear Algebra And Functions Of Several Variables

Any 7 of the following courses:

· MTH 516 – Complex Analysis

· MTH 521 – Time Series Analysis

· MTH 520 – Combinatorial Mathematics

· MTH 524 – Applications of Probability

· MTH 525 – Mathematical Methods In Engineering And Science I

· MTH 531 – Categorical Data Analysis

· MTH 534 – Differential Geometry

· MTH 537 – Operations Research I

· MTH 567 – Applied Linear Models I

· MTH 571 – Statistical Methods for Genetic Data

· MTH 577 – Numerical Methods I

· MTH 587 – Dynamical Systems

· MTH 593 – Special Topics In Mathematics

· MTH 693 – Special Topics In Mathematics

· MTH 597 – Readings In Mathematics

· MTH 697 – Readings In Mathematics

· MTH 626 – Mathematical Methods In Engineering And Science II

· MTH 638 – Operations Research II

· MTH 668 – Applied Linear Models II

· MTH 675 – Applied Multivariate Statistics

· MTH 678 – Numerical Methods II

Upto eight credits of approved courses at or above the 400-level, offered by other departments

· MTH 696 – MATHEMATICS EXIT PROJECT

Scheduling of Courses

Courses in the Master of Science program are offered in the evening during the academic year only. Courses are scheduled as indicated below. Other courses also may be offered. It is highly recommended that students complete MTH 514 in their first year of study.

With department approval, students may apply a maximum of eight 400-level credits taken as a Graduate Student at Cleveland State offered by a department other than Mathematics toward a master’s degree in Mathematics.

Faculty Research

Mathematics faculty members are active in many areas of research in pure and applied mathematics, including algebra, algebraic geometry, algebraic topology, applied mathematics (especially numerical analysis, ordinary and partial differential equations, and fluid dynamics), computer science, functional analysis, general topology, harmonic analysis, mathematics education, operator theory, probability theory, and statistics. Some department members are the authors of widely used mathematics textbooks, both graduate and undergraduate.

Financial Assistance

A limited number of graduate assistantships and tuition grants are available to qualified students. Assistantships include a stipend and tuition support. Contact the Department of Mathematics for further information. (See the section on Financial Aid and Expenses: Graduate Assistantships in this Catalog.)

Career Information

The demand for people trained in mathematics will continue to grow because of the central role of mathematics in the physical sciences, in engineering, and in business. Qualified secondary school teachers of mathematics are in demand, as are applied mathematicians to work in industry and government. There are opportunities in statistics, actuarial work, operations research, and computer science fields that all require a solid background in mathematics.


Microsoft Word 2007 Tutorial – Free – Online #online #ms #finance


#

By Denise Etheridge

Microsoft Word is a word processing software package. You can use it to type letters, reports, and other documents. It gives you the ability to use your computer for desktop publishing. This tutorial teaches Microsoft Word 2007 basics. Although this tutorial was created for the computer novice, because Microsoft Word 2007 is so different from previous versions of Microsoft Word, even experienced users may find it useful.This lesson will introduce you to the Word window. You use this window to interact with Word.

Lesson 1 familiarized you with the the Microsoft Word window. You are now ready to learn how to create a Word document. This lesson covers typing, using the Backspace key, using the Delete key, inserting text, bolding, underlining, and italicizing.

The features in Word 2007 can make your work easier, make your documents more attractive, and/or enable you to work more efficiently. This Microsoft Word lesson teaches you how to open a file, cut, copy, paste, use AutoText, use spell check, use Find and Replace, and change fonts. All of these features either make your work easier or make your document more attractive.

When you type information into Microsoft Word, each time you press the Enter key Word creates a new paragraph. You can format paragraphs. For example, you can indent the first line of a paragraph, you can set the amount of space that separates paragraphs, and you can align a paragraph left, right, center, or flush with both margins. Styles are a set of formats you can quickly apply to a paragraph. For example, by applying a style, you can set the font, set the font size, and align a paragraph all at once. In this lesson, you will learn about the various formats you can apply to a paragraph and about styles.

If you have lists of data, you may want to bullet or number them. When using Microsoft Word, bulleting and numbering are easy. The first part of this lesson teaches you to bullet and number. After you have completed your document, you may want to share it with others. One way to share your document is to print and distribute it. However, before you print you may want to add page numbers and tell Word such things as the page orientation, the paper size, and the margin setting you want to use. In this lesson you will learn how to layout and how to print your documents.

Our Free Tutorials


The City of Ridgeland Ridgeland #ms #bids


#

Ridgeland. There s More Here.

It’s time to get back to the basics of good recycling. The fact is that some recycling actions make a bigger impact than others. So please remember the essentials:

  • Recycle all bottles, cans and paper.
  • Keep items clean and dry.
  • No plastic bags in the recycling.

Visit Waste Management s new website Recycle Often.Recycle Right. for up-to-date information on current recycling information.

If you are a resident of Ridgeland, you already know! We simply have more here! Families and individuals thrive in Ridgeland with the benefits of award winning schools, premier shopping, fine dining, abundant outdoor recreational amenities, and plenty of festivals and cultural events. All of our residents enjoy a convenient location in the metro area, access to a scenic park, the Natchez Trace Parkway, a 33,000 acre lake, the Ross Barnett Reservoir, and an extensive walking and biking trail system.

One of the most decorated cities in the state of Mississippi, nestled in Madison County, Ridgeland has an award-winning master plan that is being used to guide our community development efforts, incorporating green spaces and smarter developments. Ridgeland is recognized as a Tree City USA, a Bicycle Friendly Community, top 100 place to live named by MONEY® Magazine in 2007.

Visitors feel a uniquely warm welcome when doing business, shopping, dining or relaxing in a very special community that blends big city energy and small town charm. Whether you are training for a marathon, having a family outing or enjoying a classic dining experience, Ridgeland has it all.


How to recover a damaged MS SQL Server database? #repair, #mdf, #file,, #mdf, #sql, #server, #recovery, #tool, #microsoft, #database, #ms, #fix, #recover, #recovery, #restore


#

MS SQL database recovery software

Recovery Toolbox for SQL Server (download ) is a comprehensive recovery solution for damaged MS SQL Server database files.

Features of the MDF Recovery software:

  • Recover unreadable databases with the Suspend state
  • Fix corrupted SQL Server databases from different versions of Microsoft SQL Server: SQL Server 7/2000/2005/2008/2008 R2/2012/2014
  • Recover the most important and valuable elements of MS SQL databases: data types, table data, views, stored procedures, custom functions, triggers, indexes, primary and foreign keys, restrictions and more
  • Recover databases split into several files (*.mdf + *.ndf)
  • Fix damaged partition tables during the recovery of mdf files
  • The SQL MDF Recovery software can export the recovered data directly onto a Microsoft SQL Server
  • Save the recovered data as SQL scripts on a hard drive
  • Export data directly to a new database
  • Select specific data for saving
  • Perform a recovery of an SQL Server running Windows 98/NT 4.0/2000/Me/XP/Vista/7/8/10/Server 2008/Server/2012
  • MS SQL database recovery software includes a multi-language interface with 14 languages
  • Preview of the recovered objects and data from a corrupted MDF file

The MDF fix tool helps fix database errors:

  1. SQL Server Page Level Corruption
  2. SQL Server Table Corruption Error
  3. Database consistency errors reported by DBCC CHECKB
  4. Corruption on data pages
  5. Metadata corruption Error
  6. The header for the file ‘filename.mdf’ is not a valid database file header.

A deeply optimized SQL Server recovery tool that is capable of repairing all types of database damage and *.mdf file corruption.

Requirements: Windows 98 or above

Select a corrupted database in MS SQL Server format to repair data from

Analyze of system information from corrupted database

Preview the data, that can be retrieved from corrupted files with *.mdf extension


Jackson State University #ms #in #educational #psychology


#

Department of Psychology

The Department of Psychology at Jackson State University is a unit of the School of Social and Behavioral Science in the College of Liberal Arts.

The Department of Psychology is committed to enhancing knowledge of psychological principles and practices through scholarship, research, undergraduate service-learning, and graduate clinical training. In addition, the faculty to promote the discipline of Psychology through professional service at the national and local levels. The Department has 12 faculty members, all of whom have diverse training and research interests. We currently offer two degree programs:

Jackson State University first received American Psychological Association accreditation for its Clinical Psychology Ph.D. program in 2001, but its history stretches back to 1877 and includes a rich heritage as a coeducational historically black institution. Founded in Natchez, Mississippi as a seminary to educate ministers and teachers, the original goals of the school encompassed expanding the opportunities for freed American Negroes living in the Deep South through moral, intellectual, and religious education, thus providing its graduates with the ability to serve society and become leaders within their communities. This grounding vision has shaped each step of JSU s development, from its early move to the city of Jackson through its evolution into being far more than a teacher s college. These principles impacted how psychology came to be taught at the institution and spurred its search for continued excellence through expansion into graduate programs.

By the time JSU officially gained university status from Mississippi s state legislature in 1979, the Department of Psychology s primary focus on research made its move to the School of Liberal Arts a natural transition. Then, Dr. Janet St. Lawrence, a faculty member and clinical psychologist at JSU, began to investigate HIV and STD issues in vulnerable populations during the advent of the AIDS epidemic. Out of this work with those in drug treatment, people contending with incarceration, or people from other at-risk groups, came the genesis of the Community Health Program (CHP). This program became the foremost research division within the Psychology Department and works to provide community service while training students and conducting original studies, which gain national attention. Additionally, during this time period, Dr. Cynthia Ford designed a course to teach psychology from an afro-centric perspective. This type of enhancement to the curriculum highlights JSU s focus on both cultural and individual diversity and remains a popular elective in the discipline.

After years of preparing undergraduates to pursue advanced research degrees, JSU began to develop its own plan for graduate study. Spearheading this movement was a working group whose goal was to design a program in clinical psychology that would provide multicultural training. The idea behind such multiculturalism is that the most effective clinical psychologists are those who have separated themselves from their personal biases and that this can only occur through in depth understanding of other cultures. In 1995, program was launched with a charter class of five students. APA accreditation then followed in 2001, and the first dissertation defense occurred in 2002. The concept of multicultural training remains a primary mission and requires the program actively to support those from diverse ethnic and racial backgrounds while ensuring that even the most traditional of graduate students becomes immersed in as many different environments as possible. This occurs most directly through practica, externships, and field research experience with underserved people; in the area of Jackson, this most often means rural and African-American populations.

College of Liberal Arts Building-2nd Floor
1325 J. R. Lynch Street
P.O. Box 17550
Jackson, MS 39217-0350
601.979.2371


Used Cars Olive Branch MS #buy #any #car


#used autos for sale
#

Welcome to Desoto Auto Sales

At Desoto Auto Sales, we pride ourselves on delivering an excellent value to our customers as well as a pleasant buying experience on every used vehicle we sell.

Located in Olive Branch MS, since 2008 Desoto Auto Sales has been helping customers from all across the county find the best used automobiles for sale. Our selection of used vehicles for sale comprises a wide range of used trucks, used cars, used SUVs, and used vans.

We carry almost every make of used domestic vehicles for sale, including Cadillac, Chevrolet, Chrysler, Dodge, Ford, GMC, and Jeep. We also carry almost every make of used import vehicles for sale, including BMW, Honda, Hyundai, Infiniti, Kia, Lexus, Mazda, Mercedes, Mini, Nissan Toyota, Volkswagen, and more.

We take great care to price every used car and used truck we sell fairly. To ensure this, we use advanced software that analyzes thousands of vehicles for sale in the market and automatically adjusts our price points so we always stay one step ahead of our competitors.

Desoto Auto Sales takes the risk away from buying a used car or used truck with our exclusive 60 day / 3,000 mile guarantee. We inspect every used car and truck we sell and do our very best to make sure you are getting a quality vehicle. However, it is comforting to know that when you purchase from us, if a major problem does come up at a later date we will be there to help you solve it quickly.

Desoto Auto Sales is proud to offer a free Carfax Vehicle History Report on every used vehicle we sell.

The combination of fair market based pricing, a 60 day / 3,000 mile zero risk guarantee, a free vehicle history report, and our huge selection of quality used vehicles for sale has made us one of the fastest growing used car dealerships in the Mid-South. We invite you to come by. take a test drive, for experience the dealership for yourself.


Drug Shows Breakthrough Promise for Advanced MS #ocrelizumab, #ocrevus, #ms, #multiple #sclerosis, #ms #treatments, #advanced #ms, #ms #medications, #ms #drugs


#

Drug Shows ‘Breakthrough’ Promise for Advanced MS

By Dennis Thompson

THURSDAY, Dec. 22, 2016 (HealthDay News) — A new drug slows the progress of multiple sclerosis. including an advanced form of the degenerative nerve disease for which there currently is no treatment, according to a pair of new clinical trials .

One MS specialist called the intravenous drug, ocrelizumab, a “breakthrough.”

Ocrelizumab reduced the advance of MS -related disability by 24 percent in people with primary progressive MS compared to a placebo. results from one clinical trial show.

Researchers compared ocrelizumab against a placebo, or dummy drug, because there’s no approved treatment available for primary progressive MS. This form affects about 15 percent of MS patients, said Dr. Stephen Hauser, chair of neurology at the University of California, San Francisco.

“It does represent new hope for people with progressive MS,” said Hauser, who worked on both reports.

Ocrelizumab also proved superior in treating people with relapsing multiple sclerosis, the most common form of MS, compared with other available medicines, the other clinical trial found.

“The data are really quite dramatic,” Hauser said. “They show by MRI that new areas of inflammation in the brain were reduced by 95 percent compared with the current treatment.”

Ocrelizumab, under the brand name Ocrevus, is awaiting approval by the U.S. Food and Drug Administration. The FDA had been set to approve the drug this month, but recently extended its review into March.

“We’re very hopeful the drug will be available in the spring,” said Dr. Aaron Miller, medical director of Mount Sinai’s Corinne Goldsmith Dickinson Center for Multiple Sclerosis in New York City. “I expect it will get widespread use.”

Hauser explained that multiple sclerosis occurs when the immune system attacks the protective sheath that covers nerve fibers, which is composed of a fatty substance called myelin .

Ocrelizumab treats MS by depleting the immune cells that produce antibodies to attack the myelin, Hauser said.

Initially, multiple sclerosis features inflammation that crops up as the immune system actively attacks the myelin. In this phase, known as relapsing multiple sclerosis, patients alternate between active MS attacks followed by periods of remission. Hauser noted.

Continued

But, after the myelin sheath has been destroyed, some MS patients will settle into a lengthy degenerative phase known as primary progressive multiple sclerosis. Instead of having attacks of the disease, patients experience a slow and progressive worsening of their motor function, Hauser said.

MS affects an estimated 2.3 million people around the world, including about 400,000 people in the United States, the study authors said in background notes.

Although there’s no cure for any form of MS, multiple treatments are available for relapsing MS to ease symptoms. The clinical trial involving this form of the disorder compared ocrelizumab against the drug interferon beta-1a, which is a current standard-of-care medication.

Ocrelizumab reduced new inflammation, and also produced up to a 47 percent reduction in relapses and a 43 percent reduction in disability compared to interferon. the clinical trial reported. Hauser served as scientific steering committee chair for this trial.

Miller said that the drug also showed itself to be the first real ray of hope for people with progressive MS, slowing the disorder’s advance in a limited but meaningful way.

“We have never had any adequate treatments for primary progressive MS. In that respect, this is a breakthrough,” Miller said. “Obviously one would like to see higher levels of greater reduction, but this is definitely a very significant finding for appropriate patients.”

The drug also was very well-tolerated by patients, Hauser and Miller said.

About one-third of patients suffered a reaction to the infusion of the drug, but other medications helped treat these symptoms with no long-term effects, Hauser said. Only 1.3 percent of patients developed a serious infection, compared to 2.9 percent of those treated with interferon.

Both clinical trials were sponsored by the drug’s manufacturer, F. Hoffmann-La Roche. The results were published Dec. 21 in the New England Journal of Medicine.

WebMD News from HealthDay

Sources

SOURCES: Stephen Hauser, M.D. chair, department of neurology, University of California, San Francisco; Aaron Miller, M.D. medical director, Mount Sinai’s Corinne Goldsmith Dickinson Center for Multiple Sclerosis, New York City; Dec. 21, 2016, New England Journal of Medicine