Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-28 : 10:36:51
|
| John writes "I am setup on a shared instance of SQL Server 2000. I was able to get the administrator to install and add my odbc connection on the SQL Server Windows machine. But, I cannot access it. I am unable to create a linked server and or execute the sp_addlinkedserver stored procedure. Is there any other way I can access my ODBC without having to be an administrator or have the administrator setup the linked server?Thanks ahead of time." |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-28 : 10:49:09
|
| Need more information. Where is the instance of SQL Server located? On your machine? On a server? Where and how are you accessing it from? The query analyzer, an application, Access etc...? Do you have a login setup in the SQL Server? Can you ping the server if there is one? Are you getting an error? What is it?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
 |
|
|
Mountain_Nerd
Starting Member
28 Posts |
Posted - 2005-06-28 : 14:01:25
|
| You could possibly use the OPENDATASOURCE command rather than establishing a linked server. See BOL.SELECT *FROM OPENDATASOURCE( 'SQLOLEDB', 'Data Source=ServerName;User ID=MyUID;Password=MyPass' ).Northwind.dbo.Categories |
|
|
|
|
|
|
Utilizing ODBC connections