Current Position:Home > Problem with SQL driver

Problem with SQL driver

Update:10-11Source: network consolidation
Advertisement
Hi
We're on Sap Dataservices version 4.1
We're trying to control the SQL driver to be used for communicating with external warehouse.
currently we get this error <[Microsoft][ODBC SQL Server Driver] Optional feature not implemented
We have had a look at note 1624626 - seems like our problem, but we're not able to perform that tasks specified.
Install Native Client for MS SQL Server 2008 - done
Modify all data sources associated with the job to use the native client - how??
Modify db connection of the datastore associated with the job
Restart Job Service
Run the job.
Any help will be appreciated.

The Best Answer

Advertisement
Hi Henrik,
As per the trailing post, when you had installed/updated the Native Client for MS SQL SERVER 2008, then there are some changes you need to take care about the repository connections as well as data store connections.
Every job server is associated with at least one repository, In your case if the job server has a repository in MS SQL SERVER 2008 then do refresh the connection by going into
DS server manager -> Config EDIT -> select the job server -> select the repository-> click on edit and reenter the credentials.
Then do click on close and restart, only by doing so the services will restart and changes will take effect.
By doing these steps, you had Restarted the job service as well as modified data connection to the repository associated to the job server.
Lastly log on to the Designer and refresh all the data stores associated with MS SQL SERVER 2008.
You can do this by just selecting the data store from the project explorer, right clicking on it and click on edit. Reenter the login credentials and click on apply.
Regards,
Mubashir Hussain
  • Problem with SQL driver Update:10-11

    Hi We're on Sap Dataservices version 4.1 We're trying to control the SQL driver to be used for communicating with external warehouse. currently we get this error <[Microsoft][ODBC SQL Server Driver] Optional feature not implemented We have had a look

  • Problem accessing Sql server Procedure from Crystal with JDBC driver Update:11-30

    I have some Crystal reports using SQL Server procedures, most of them are working very well; however, I have 2 that have problems accessing sql server procedures. These reports are working using OLE DB connection without problem, but when I try to re

  • Problem in SQL Query Execution Update:11-30

    Hi, I have tried to Insert Data in Table (Using MySQL) , and as far as i know there is no error in my program and it's executing well with out showing any error and throwing exception. Database connected successfully. I have given the full code here.

  • Problem using JDBC driver with JSP Update:11-30

    Hi, I am trying to connecto to my mysql server via a JSP page, but it seems that there is a problem with the driver call or something in my configuration that unables me to connect. I have the mysql-connector-java-3.0.7-stable driver. This is how my

  • New gsl.sql.driv.Driver();    //???? Update:11-30

    I bought the book:"Java Swing" and I have problems with an Example, in this case the mistake is with the follow line: new gsl.sql.driv.Driver(); Do you know why I have problems with this line? The mistake message is: C:\My Documents\Java\Swing&g

  • Backup problem with tape Drive Update:11-30

    Hi My company buys new server( HP Proliant ML 570 with HP LTO ULTRIUM 232 Tape Drive. OS (Windows 2003 Enterprise - SP1) see it correctly (nt backup works, diagnostic tools don't report problems) But SQL Server 2005 - SP1 don't see this tape drive (

  • Problem with display driver Update:10-11

    Hello, Im using Photoshop CC and when it starts up it sometimes gives me this error message: 'Problem with display driver and has temporary disabled enhancements which use graphics hardware.' What does this mean? Then it tells me to download the lats

  • Local Network Connection Problem with SQL Server 2008 R2 Update:10-11

    Hi, I have CRM application which uses SQL server 2008. Weird thing is that I have no problems connecting from client machines to the server when using a particular router (via LAN) and when I upgrade the firmware of the same router (A common open sou

  • Ipod nano not showing up in itunes and getting message about problem with this drive, ipod nano not showing up in itunes and getting message about problem with this drive Update:10-11

    My ipod nano has been working fine for at least three years.  All of a sudden I get two messages.  First, "there is a problem with this drive, scan and fix it". And, an Ipod has been detected but can't be identified properly.  It's a 6th generat

  • Suddenly my nano (6th gen) can't be detected and windows 8.1 says there is a problem with the drive, but it can't be fixed Update:10-11

    I've had this for sometime and this laptop for about 1 year. Never saw this before, but haven't tryed to line up with ITunes for a while. I get a notice from windows that there is a problem with the drive and it asks it i want to fix it. Nothing happ