[ JustinTime @ 23.09.2009. 15:57 ] @
Pozdrav svima,

pokušavam da se konektujem na ORACLE bazu sa SQL Server Management Studio Expressa. Generalno, pratio sam uputstvo na ovom sajtu. Nakon što sam ispoštovao uputstvo, prije sedmog koraka, pojavi se poruka:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

"The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?"

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "MONV". (Microsoft SQL Server, Error: 7302)


Ima li iko ideju?
[ stevs986 @ 23.09.2009. 23:21 ] @
>

Probaj TOAD for ORACLE, fin klijentski alat...

--
S' po�tovanjem
Sla�an Nikoli�

--001485f6cd1887a5f504744623c7
Content-Type: text/html; charset=ISO-8859-2
Content-Transfer-Encoding: quoted-printable

<br><br><div class="gmail_quote">2009/9/23 JustinTime <span dir="ltr">&lt;<a href="mailto:[email protected]">[email protected]</a>&gt;</span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Pozdrav svima,<br>
<br>
poku�avam da se konektujem na ORACLE bazu sa SQL Server Management Studio Expressa. Generalno, pratio sam uputstvo na (ovom sajtu: <a href="http://www.ideaexcursion.com/2...ing-to-oracle-from-sql-server/" target="_blank">http://www.ideaexcursion.com/2...cle-from-sql-server/</a> ). Nakon �to sam ispo�tovao uputstvo, prije sedmog koraka, pojavi se poruka:<br>

<br>
TITLE: Microsoft SQL Server Management Studio Express<br>
------------------------------<br>
<br>
&quot;The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?&quot;<br>
<br>
------------------------------<br>
ADDITIONAL INFORMATION:<br>
<br>
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)<br>
<br>
------------------------------<br>
<br>
Cannot create an instance of OLE DB provider &quot;OraOLEDB.Oracle&quot; for linked server &quot;MONV&quot;. (Microsoft SQL Server, Error: 7302)<br>
<br>
<br>
Ima li iko ideju?<br><font color="#888888">
<br>
<br>
--<br>
<a href="http://www.elitesecurity.org/p2395380" target="_blank">http://www.elitesecurity.org/p2395380</a><br>
<br>
Prijave/odjave: <a href="http://www.elitesecurity.org/liste" target="_blank">http://www.elitesecurity.org/liste</a><br>
<br>
Ne menjajte sledece dve linije ukoliko odgovarate putem emaila!<br>
esauth:376463:130c163dfabfdb1aab9e3ac073761652<br>
[ JustinTime @ 24.09.2009. 08:08 ] @
Hm. Da, ali poenta je da želim da olakšam sebi migriranje nekih podataka iz oracle-a u SQL Server, tako da mi treba baš konekcija iz SQL Server Management Studija