View Complete Post
Every day a developer somewhere needs to write code to iterate through SQL ServerT system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata.
MSDN Magazine November 2004
I am probably doing something stupid BUT I am creating a linked server to an excel file, I have done this on sql2005sp2x64 using the ace ole 12 provder, and replicated on another machine running sql2005sp2x32 using the jet4 provider and I am having the same
problem on both. I have turned allow inprocess option on on both providers. I as an administrator on the machine where the database and datafile are residing have no problem accessing the linked server and the file underneath however any enduser
that is not in the local administrators group gets the error Cannot initialize the data source object of OLE DB provier "Either provider I have tried" for linked server SQL Server Error 7303. I have checked file permissions,
and they are open to the world, I have tried both use existing authentication and use no authentication when accessing the linked server. and I have tried endless different combinations of providers and provider strings. I have went as far as having
the enduser create a linked server to an excel file on his local machine (which he is admin on and I am not) and he can access the file .. and I can not. so I am just assuming there is some sort of security setting somewhere .. that I am
I have 2 SQL Server instances that I need to query from. I have figured out how link the 2 servers, I just don't know how to get the value from the other instance/table and put it in the case statement.
Here are the tables:
Instance: Default Database:GAD
Instance: MSSQL Database:SCA
Here is the Select Statement with the when clause in it.
Select top (1)V301054A as MW, Availability = case when V301054A <= '.1' then 'Deployed' else '0' end FROM [Default].[SCA].[dbo].[SAMPLES1] AS SAMP1
Group by V301054A
order by MW desc
What I need to do is get the value from this Select Statement and put it where the 'Deployed' is in the above When Clause.
I am testing an upgrade from SQL Server 2005 to SQL Server 2008 R2. I have a stored procedure which attempts to use the serializable transaction isolation level on a distributed transaction (linked server).
The query fails on SQL Server 2008 R2 with
OLE DB provider "SQLNCLI10" for linked server "SERVER1" returned message "No transaction is active.".
Msg 7391, Level 16, State 2
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "SERVER1" was unable to begin a distributed transaction.
If I change the isolation level to read committed, the transaction succeeds. This same procedure worked on SQL Server 2005 but now fails on SQL Server 2008 R2 using the same isolation level.
Is there a way to get this isolation level to work with linked servers on SQL Server 2008 R2?
I've been having a very tough time trying to get the simplest of linked server to work. I've managed to create similar linked servers on my home PC, but the Management Studios on my office PC is hanging whenever I try to do anything with a linked server.
I have both SQL Server 2005 and 2008 express editions installed on my work PC. I also have a number of ODBC DSNs to a variety of data sources (ACCESS DBs, another MS SQL server (2005), an Oracle server, EXCEL files, .gdb databases, etc.). These DSNs
all work properly to create connections, all have been tested outside of the Management Studio without any problem.
I can create the Linked Servers in both 2005 and 2008 Servers, but any time I try to interact with them, the Management Studio hangs.
For example, if I:
- Test Connection in 2008
- Expand the Linked Server catalog in 2008
- Run any form of query against the Linked server (This includes both direct queries and OpenQuery() queries)
- Alter any of the Linked Server Properties.
Pretty much the only thing that I can do is create the linked server. Any other action on the linked server causes the Management Studio the hang, regardless of any timeout that I specify.
This has m
I need to build a service that copies new rows from SqlServerA.DB1.TABLE_X to SqlServerB.DB2.TABLE_X. Direction is from SqlServerA to SqlServerB
Source and destination tables are the same structure. SqlServerA and SqlServerB are located in two different cities and there is VPN connectivity between them. The
VPN is based on Internet and reasonably fast.
The service need to be able to recover when VPN is down and try again later when VPN is running again.
I wonder if linked servers are suitable for this scenario? I can avoid joining distributed tables together and leverage linked servers by using INSERT statements.
I am aware of MERGE replication and I wonder if MERGE replication is a simpler alternative?
I have to connect two sql server 2008 standard edition as linked servers. Is there any possible way to compress the data passed between two linked servers?
I'm having a strange time trying to get an instance of Enterprise Edition SQL 2008 R2 to link with a Web Edition. We've been able to link to other instances without issues, and whenever we go to link with the Web Edition, we get the error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)
The two VMs are on the same domain, with the same permissions, and this error does not appear when we link two Enterprise servers. I've googled around and I couldn't see anything that says we can't link the two versions up, and the error implies some kind
of permissions thing, but both servers share the same Active Directory, and have the same logins.
I'm stumped. Any ideas on how to start solving this?
Edit: to clarify, the users are in AD Groups, "user_Admin". The group is added as a login and mapped to the various DBs on both servers. We can only use SSPI authentication - no SQL Server Authentication.
i am developed on simple user registeration application in that i gave address field .when i am trying to enter something like this (1st main,b'lore) but wont take while inserting.
my query is
sqlcommand cmd=new sqlcommand("insert into registeration_form(name,address)values('"+txtname.text+"','"+txt_address+"')",con);
how can i pass the quotes also to my query please if any one know reply me.
hey guy, i need help in a very troubling matter. I want to make a textbox with a specific style, within this style a set of images as background parts, how can i attach these images to the custom control as whenever i take the .dll file and add it to the toolbar the images do not appear. So i tried to make them as resource files and their property as embedded in .resx file, so how to make the css style background image url to be linked to any of those image.
thanks in advance
MSDN Magazine February 2001
Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here. The article begins with a description of the SQL Server database used to store state information, the stored procedures used to update it, and the retrieval of session data. ASP code drives the session manager tool and the COM and COM+ components that run the stored procedures.
MSDN Magazine October 2000
Windows 2000 is the first version of COM to support asynchronous method calls, which permit clients to make nonblocking calls to COM objects and objects to process incoming calls without blocking the calling threads. COM clients benefit from asynchronous method calls because they can continue working while waiting for outbound calls to return. Objects benefit because they can queue incoming calls and service them from a thread pool. Our SieveClient and SieveServer sample apps demonstrate how to create and use asynchronous clients and servers in COM-based distributed applications.
MSDN Magazine April 2000