SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:05 PM
| ||||
| ||||
 ODBC Data Source to a linked SQL Server I'd like to set up an ODBC Data Source to a table in a linked SQL Server, via my local SQL Server. When I use the ODBC Data Sources program to set up the ODBC DSN, it only shows databases in the local SQL Server, not in the linked one. If I try typing it in: [NAMEOFLINKEDSERVER].databasename - it tells me that it is an invalid table. How can I create an ODBC Data Source which uses a database in the linked server as its default database?      |
|
02-27-2008, 09:06 PM
| ||||
| ||||
| Re: ODBC Data Source to a linked SQL Server I've got a similar question. In my case I linked an Oracle database to my SQL Server 2005 Standard database. I also want to see the tables in the linked server. I hope someone can answer this for both of us... Randall Arnold <listrecv@gmail.com> wrote in message news:1137940173.907969.215550@o13g2000cwo.googlegr oups.com... > I'd like to set up an ODBC Data Source to a table in a linked SQL > Server, via > my local SQL Server. > > When I use the ODBC Data Sources program to set up the ODBC DSN, it > only > shows databases in the local SQL Server, not in the linked one. If I > try typing it in: [NAMEOFLINKEDSERVER].databasename - it tells me that > it is an invalid table. > > How can I create an ODBC Data Source which uses a database in the > linked server as its default database? > |
Linear Mode
