Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server > SQL Server Forums > SQL Server Data Access > connect to SQL server using pro*c

Answered connect to SQL server using pro*c

    •  
      Monday, September 19, 2011 11:10 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hi Guys,

      Can someone tell me how to connect MS SQL server using pro*C in Unix box.

      -Ram

       

    Answers

    All Replies

    • Monday, September 19, 2011 11:36 AM
       
       
      Sign In to Vote
      1
      Sign In to Vote

      Is pro*C ORACLE? then you must ask this question in Oracle forum. Because you will have configure Oracle & not MS SQL to get a connection.

      If it was opposite, from MS SQL Server to Oracle/pro*C then creating a Linked Server in SQL Server pointing to Oracle would do.

       

      Check creating Linked Server in Oracle/pro*C

      ~manoj | email: http://scr.im/m22g
      http://sqlwithmanoj.wordpress.com
      MCCA 2011
       
    • Monday, September 19, 2011 11:41 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Thanks Manoj.

      But i want to connect MS Sql server using pro*C running in unix box and nothing to do with Oracle.

      Ram
       
    • Monday, September 19, 2011 11:50 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      AFAIK this link is concerned, pro*C is related to Oracle: http://infolab.stanford.edu/~ullman/fcdb/oracle/or-proc.html

       

      Your pro*C provides an environment to run your SQL queries in Oracle engine.

      So you would need to configure a Linked Server in Oracle that will point to SQL Server. So check this stuff in Oracle forum, or bing/google the topic.

      ~manoj | email: http://scr.im/m22g
      http://sqlwithmanoj.wordpress.com
      MCCA 2011
       
    • Monday, September 19, 2011 12:07 PM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      I have never used the word oracle, why are you assuming it as oracle.

      pro*C can connect to any database, unless you have libraries in hand to connect it.

      i just want to know if anyone has connected to MS SQL server using pro*C and if you had connected to it, then how?

      we want to do this in Unix box.

      nobody will encourage to have linked server from oracle to do it.

      Ram
       
    • Monday, September 19, 2011 12:25 PM
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote

      Ok, I agree... I'm not the one from Oracle & pro*C/UNIX environment, thus the answer.

       

      As I've already mentioned please put up you question in appropriate forum to get your query resolved, this place is only for T-SQL.

      ~manoj | email: http://scr.im/m22g
      http://sqlwithmanoj.wordpress.com
      MCCA 2011
       
    • Sunday, April 29, 2012 10:04 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hi Ram,

      Did you get an answer in the end?

      I am also looking for an answer on the same questions.