The OLE DB provider "Ifxoledbc.2" has not been registered.

• Faheem Ansari-432485

  Old Hand

  Points: 320

  More actions

  May 31, 2007 at 4:30 am

  #178858

  Hi,

  I used to add the link server in sql server 2005

  exec sp_addlinkedserver @server = 'test6',

  @srvProduct = 'ifxoledbc',

  @Provider = 'Ifxoledbc.2',

  @datasrc = orixtts@srvtest,

  @provstr = 'Provider=Ifxoledbc.2;Data Source=orixtts@srvtest;Persist Security Info=true'

  EXEC sp_addlinkedsrvlogin 'test6', 'false', 'recover', 'tts', 'password'

  When I run the following command

  select * from test6..tts.cardtbl

  then I get the following error

  Msg 7403, Level 16, State 1, Line 1

  The OLE DB provider "Ifxoledbc.2" has not been registered.

  How can I register Ifxoledbc.2 ?

  Thanks.

  Faheem Ansari

• Johan Bijnens

  SSC Guru

  Points: 135551

  More actions

  May 31, 2007 at 4:50 am

  #709952

  maybe let the system determine the driverversion itself.

  @Provider = 'Ifxoledbc',

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• Faheem Ansari-432485

  Old Hand

  Points: 320

  More actions

  May 31, 2007 at 6:58 am

  #709975

  Hi,

  I found net that we should use @Provider = 'Ifxoledbc.2' then I got good performance.

  Thanks.

  Faheem Ansari

• Johan Bijnens

  SSC Guru

  Points: 135551

  More actions

  June 1, 2007 at 5:07 am

  #710281

  isn't ifxoledbc.1 the most recent installed one ?

  maybe uninstalling and reinstalling the pre-latest version would do the trick.

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• Faheem Ansari-432485

  Old Hand

  Points: 320

  More actions

  June 4, 2007 at 6:02 am

  #710571

  Hi,

  Ifxoledbc.2 is latest one. How can I register Ifxoledbc.2 on sql server 2005?

  Thanks.

  Faheem Ansari

• Faheem Ansari-432485

  Old Hand

  Points: 320

  More actions

  June 4, 2007 at 6:03 am

  #710574

  Hi,

  Ifxoledbc.2 is latest one. How can I register Ifxoledbc.2 on sql server 2005?

  Thanks.

  Faheem Ansari