Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Anyway to connect to Oracle on the fly without tnsnames entry?

  As the title indicates, I'm curious if anyone knows of a way to connect to an Oracle database from …

  Mr Corn Man

  8 replies

  8 years, 2 months ago

  By: maudzedunjp

• Oracle's OLEDB Provider VS Microsoft OLEDB Provider for Oracle in SSIS

  It has been a couple of years since I worked with Oracle within SSIS and I seem to recall having pr…

  Welsh Corgi

  54 replies

  8 years, 3 months ago

  By: Welsh Corgi

• ORA-00932: inconsistent datatypes: expected FILE got BINARY when Initializing SQL 2k8R2 Publication to Oracle 12c Sub

  I'm attempting to setup a Non-SQL subscriber (Oracle 12c) on a SQL 2k8R2 instance. Once I setup the…

  raz.the.cat

  8 replies

  8 years, 5 months ago

  By: Ronzo

• Difference between MySQL and Oracle? What's better?

  Hello all! I wanna studying Oracle after a long time working with MySQl.. Is really really difficul…

  Cathydoesloans

  10 replies

  8 years, 7 months ago

  By: kevaburg

• Oracle 10G to SQL Server (2008 and above)DB migration process

  Does working on an Oracle DB 10g database migration to SQL Server using SSMA involve more of Oracle…

  mtz676

  2 replies

  8 years, 7 months ago

  By: Lowell

• Oracle Connector doesn't work

  I've been asked to edit an existing SSIS job importing Data from Oracle 11g to SQL 2012. When I tr…

  dan-572483

  2 replies

  8 years, 7 months ago

  By: kevaburg

• oracle noob.

  So I no very little of Oracle: col is a date datatype. There's something about the way Oracle is d…

  snomadj

  6 replies

  8 years, 7 months ago

  By: kevaburg

• Need name of 32-bit Oracle client that contains ODAC

  I typically install the Oracle 12.x client on our newly built SQL Servers (2012, 2014). Our Develo…

  Express12

  2 replies

  8 years, 7 months ago

  By: kevaburg

• SQL to Tsql

  Hi friends, In our application, we use the code below in Oracle database SET $WeekDay TO …

  newbieuser

  9 replies

  8 years, 9 months ago

  By: Kalegley

• create table via Linked server

  Hi friends, We would need to create tables in Oracle via Linked Server in SQL Server.. I tried se…

  newbieuser

  2 replies

  8 years, 11 months ago

  By: teenujohn555

• Connecting to Oracle from SQL Server

  I am needing some help if anyone has a moment and could give advice. I have a SQL 2008R2 database w…

  DataAnalyst011

  2 replies

  9 years ago

  By: crk5070

• Oracle Provider for OLE DB

  I've had the Oracle client installed on the server (Oracle 11) however, when I go to create a linke…

  Sioban Krzywicki

  6 replies

  9 years, 1 month ago

  By: AMagruder

• Oracle BETWEEN DateTime statement

  Hello, I've connected to a new database at work via VBA. I've entered SQL script into my VB code an…

  jimtimber

  6 replies

  9 years, 2 months ago

  By: Ed Wagner

• SQL convert

  Hi friends, I'm converting a complex oracle sql join query to SQL Server. I'm using lpad in oracl…

  newbieuser

  8 replies

  9 years, 3 months ago

  By: newbieuser

• Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server

  I am periodically getting the following message when I attempt to query my linked server: Cannot ge…

  Mark Harley

  2 replies

  9 years, 3 months ago

  By: Gracia