Search Results

Search found 9 results on 1 pages for 'sqlncli'.

Page 1/1 | 1 

• difference between sql providers SQLOLEDB and SQLNCLI

  - by salman

  Hi Everyone I just need to know what's the difference between sql providers SQLOLEDB and SQLNCLI. I have one scenario where one SSIS package should fail. Now when I use SQLNCLI provider in the connection string the package terminates by throwing the error as expected. However when I use SQLOLEDB provider, the package behaves abnormally by ending…

  Read the article

• Linked servers SQLNCLI problem. "No transaction is active"

  - by Felipe Fiali

  Im trying to execute a stored procedure and simply insert its results in a temporary table, and I'm getting the following message: The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "MyServerName" was unable to begin a distributed transaction. OLE DB provider "SQLNCLI" for linked server "MyServerName"…

  Read the article

• Error- The SQLNCLI provider is not registered on the local machine.

  - by superartsy

  I get the above error in one of my apps. However there is no reference to using the SQLNCLI provider. I know before the ConnectionString had "Provider=SQLNCLI".However now its changed to "Provider=SQLOLEDB" (using OLEDB since the same app connects to Access and SQL database). Why then do I still get the error?

  Read the article

• Why does SQL 2005 SSIS component install fail?

  - by Ducain

  I am trying to install SSIS on our production SQL 2005 SP2 box. Each time I try, the install/setup screen results in failure, starting with the native client, and moving on down. Screen shots below show what I see: Here is the result of clicking on the status link to the right of the native client after the install failed: ===…

  Read the article

• FIX: A network error occurred during SQL Server Native Client installation

  - by Greg Low

  One of the things that I have been pestering the SQL team to do is to name their updates according to what is contained in them. For example, instead of just: sqlncli.msi What I'd prefer is that the file was called something like: SQLServerNativeClient2k8SP1CU3x64.msi So I normally rename them as soon as I receive them, to avoid…

  Read the article

• Linked server problem on SQL Server 2005

  - by BradyKelly

  I have a weird issue and I hope someone can steer me in the right direction for resolving this please. When I execute the following query against a linked server, I get the following error. I can connect to the server in SSMS as a separate server, and execute a similar query against its Deposits table. The nn.nn is my own…

  Read the article

• sp_addlinkedserver on sql server 2005 giving problem

  - by Jit

  I am trying to create a link server of a remote database(both the servers are SQL serve2005). I am able to connect that remote server from my SQL Server management studio. I used the following syntax to create it. EXEC sp_addlinkedserver @server = N'LINKSQL2005', @srvproduct = N'', @provider = N'SQLNCLI',…

  Read the article

• Is INT the correct datatype for ABS(CHECKSUM(NEWID()))?

  - by Chad Sellers

  I'm in the process of creating unique customers ID's that is an alternative Id for external use. In the process of adding a new column "cust_uid" with datatype INT for my unique ID's, When I do an INSERT into this new column: Insert Into Customers(cust_uid) Select ABS(CHECKSUM(NEWID())) I get a error: Could…

  Read the article

• Is there a generic way of dealing with varying connection strings in C#?

  - by James Wiseman

  I have an application that needs to connect to a SQL database, and execute a SQL Agent Job. The connection string I am trying to access is stored in the registry, which is easily enough pulled out. This appliction is to be run on multiple computers, and I cannot guarantee the format of this connection string…

  Read the article

1