|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server 2000 to OracleI need to access Oracle 9i from SQL Server 2000 to get the next number from
an Oracle sequence. What is the simplest way to do this? Is a Microsoft ODBC driver the answer? Hi
One way it to create a linked server and OPENQUERY. You are probably better using either the Oracle or Microsoft OLEDB drivers. More information is in Books Online. John Show quote "parmel" <par***@discussions.microsoft.com> wrote in message news:A4104B06-8FD5-47BF-AF96-220EE665D26B@microsoft.com... >I need to access Oracle 9i from SQL Server 2000 to get the next number from > an Oracle sequence. What is the simplest way to do this? Is a Microsoft > ODBC driver the answer? I'm new to this site. Can you tell me where I go to get to Books Online?
Thanks. Show quote "John Bell" wrote: > Hi > > One way it to create a linked server and OPENQUERY. You are probably better > using either the Oracle or Microsoft OLEDB drivers. More information is in > Books Online. > > John > "parmel" <par***@discussions.microsoft.com> wrote in message > news:A4104B06-8FD5-47BF-AF96-220EE665D26B@microsoft.com... > >I need to access Oracle 9i from SQL Server 2000 to get the next number from > > an Oracle sequence. What is the simplest way to do this? Is a Microsoft > > ODBC driver the answer? > > > If you have the SQL Server client tools installed, navigate to
Programs-->Microsoft SQL Server-->Books Online. You can also download the latest from http://www.microsoft.com/sql/techinfo/productdoc/2000/books.mspx. Online web access is also available via the MSDN Library http://msdn.microsoft.com/library/default.asp under Servers and Enterprise Development. -- Show quoteHope this helps. Dan Guzman SQL Server MVP "parmel" <par***@discussions.microsoft.com> wrote in message news:E6450F27-EF96-4322-B344-951CC4995C4C@microsoft.com... > I'm new to this site. Can you tell me where I go to get to Books Online? > Thanks. > > "John Bell" wrote: > >> Hi >> >> One way it to create a linked server and OPENQUERY. You are probably >> better >> using either the Oracle or Microsoft OLEDB drivers. More information is >> in >> Books Online. >> >> John >> "parmel" <par***@discussions.microsoft.com> wrote in message >> news:A4104B06-8FD5-47BF-AF96-220EE665D26B@microsoft.com... >> >I need to access Oracle 9i from SQL Server 2000 to get the next number >> >from >> > an Oracle sequence. What is the simplest way to do this? Is a >> > Microsoft >> > ODBC driver the answer? >> >> >> Thank you John and Dan. This points me in the right direction.
Show quote "Dan Guzman" wrote: > If you have the SQL Server client tools installed, navigate to > Programs-->Microsoft SQL Server-->Books Online. You can also download the > latest from > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.mspx. Online > web access is also available via the MSDN Library > http://msdn.microsoft.com/library/default.asp under Servers and Enterprise > Development. > > -- > Hope this helps. > > Dan Guzman > SQL Server MVP > > "parmel" <par***@discussions.microsoft.com> wrote in message > news:E6450F27-EF96-4322-B344-951CC4995C4C@microsoft.com... > > I'm new to this site. Can you tell me where I go to get to Books Online? > > Thanks. > > > > "John Bell" wrote: > > > >> Hi > >> > >> One way it to create a linked server and OPENQUERY. You are probably > >> better > >> using either the Oracle or Microsoft OLEDB drivers. More information is > >> in > >> Books Online. > >> > >> John > >> "parmel" <par***@discussions.microsoft.com> wrote in message > >> news:A4104B06-8FD5-47BF-AF96-220EE665D26B@microsoft.com... > >> >I need to access Oracle 9i from SQL Server 2000 to get the next number > >> >from > >> > an Oracle sequence. What is the simplest way to do this? Is a > >> > Microsoft > >> > ODBC driver the answer? > >> > >> > >> > > >  |
|||||||||||||||||||||||
Other interesting topics