Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Exclamation Unanswered: How to connect to SQL server database from Oracle 9ias Application Server (9.0.3)

    How to connect to SQL server database from Oracle 9ias Application Server (9.0.3) & Test & Verify the Connection. Is it posible.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How to connect to SQL server database from Oracle 9ias Application Server >(9.0.3) & Test & Verify the Connection. Is it posible?
    9iAS is NOT a monolithic product.
    Since 9.0.3 is primarily just J2EE, I'd suspect you could use JDBC to get to SQL Server.
    Which component(s) do you need to connect to SQL Server?
    It might be easier to connect to an Oracle DB and use it to get to the desired
    SQL server data via a DBLINK.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Question How to connect to SQL server database from Oracle 9ias Application Server (9.0.3)

    Through Oracle Containners for java ( OCJ4 ) Instance

    In Create Datasource Section ( Through EM website ).
    What are the values for the below inorder to connect to SQL SERVER database. & How to verify the connection.

    JDBC URL: ?????
    JDBC Driver: ?????

    Thanks

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I'm confused.
    >What are the values for the below inorder to connect to SQL SERVER >database. & How to verify the connection.
    >JDBC URL: ?????
    >JDBC Driver: ?????
    Why are you asking an Oracle Forum how to connect via JDBC to SQL Server?

    The SQL Server Forum is down the hall two doors & on the left side.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Angry How to connect to SQL server database from Oracle 9ias Application Server (9.0.3)

    Why are you asking an Oracle Forum how to connect via JDBC to SQL Server?
    ??
    Cause in this instance Oracle has the power(Driving the process). Would you really wont to really on SQL server Driving a process like that. Oracle is at the server level and sql is at the user level. We are not asking to connect via jdbc.

    Database.Driver=com.microsoft.jdbc.sqlserver.SQLSe rverDriver
    Database.URL=jdbc:microsoft:sqlserver://xxxxx016:1433;DatabaseName=temp;SelectMethod=curso r;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •