.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Does "Microsoft OLE DB Provider for SQL Server" get different versions for SQL2005 and SQL2008?

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
We know SQLServer OLE DB have two driver types: SQL Native Client and Microsoft OLE DB Provider. I know The former one have different versions for SQLServer2005 and SQLServer 2008 (SQLNCLI.DLL, SQLNCLI10.DLL), right? And for latter one, does it have different versions? I only got SQLOLEDB.dll under system32 folder, but have no idea whether it have different versions. Can some one help me?   Thanks Spring  

View Complete Post

More Related Resource Links

SQL2005 and SQL2008 installed on the same environment - Application problems connecting to SQL2005 d


We have an environment with SQL 2005 and SQL2008 instances - failover 2 node cluster 64 bit.

We installed a new web application and we cannot connect to the databases on the SQL2005 instance.

We are able to connect to the database using the same credentials used by the web site using a udl file and using SQL Management Studio. However, the web site tells that we do not have authorisation to access the web site.

I wonder whether there is something to do with the fact that we have the two SQL versions on the same environment.

We had a similar problem on another mixed environment. On that particular case the connection failed on a SSIS package. We tried the same package on a SQL2005 and the package ran.

If the mixture of the two versions is affecting new applications to connect to the databases, is there a way around to resolve this problem? Unfortunately, the environments contain live databases.

Thank you in advance for your help.

Remove SQL2005 from domain and then add a new SQL2008 back using the same name?


We have an email complaince application using a SQL 2005 server which is part of the domain.  I want to build a new Windows 2008 / SQL 2008 server to replace the priginal SQL 2005.

Now to change the SQL connection within the application itself is a nightmare.  With this I am curious if I could first, shut down the compliance application so no data is going to the current DBs.  Next, backup these DBs and then shut down the current SQL 2005 server.

Now, build on new hardware a Windows / SQL 2008 server.  Go into AD and remove the original SQL2005 server and then simplay re add it using the same server name.  Once this is done, join the new 2008 server to the domain using the old server name.  Reload SQL and create the original security accounts.  Once this is done, create the databses and then restore using the backups.

Now the hope is that once this is all done, that I bring up the complaince application and it just connects to the new server and is happy as a clam.

Does this sound solid or am I looking to create other severe headaches by doing this and should just fight through the rebuilding SQL and then messing with the application to point it to the new server?



Unable to connect Traditional VB6 Application to SQL2008 - After Upgrade from SQL2005



We have  VB6 application working and it uses ADO to connect to SQL2005.   We have upgraded server to SQL2008
Now VB6 application is unable to connect,  the Code Line object_ADOConnection.Open  Fails,  meaning it gets hung-up.

Any Directions what could be wrong or anything that needs to change in code.?


Slowness writing to database after upgrade from SQL2005 to SQL2008/R2



We have recently upgraded our SQL server and moved from SQL2005 to SQL2008/R2.

A program we use continuously inserts rows of data into a table in the database.

The process used to write approximately 200 lines of data per second, but since upgrading it will only write one line per second.

We have tried to mirror the configuration of the server as accurately as possible, but does anyone know of a setting that could be causing the data to be written so slowly?

Kind Regards,


SQL2008 - Assembly versioning: Two versions of assembly '...'. Keep one version and drop the other



If someone has a suggestion of how to handle .NET dll assembly versions in a SQL Server 2008 database I would be very happy if you could explain how to do it.

First some background though so you'll understand the situation I'm in.

I've created a SQLCLR stored procedure in .NET with some code doning calculations in the database. Now I need to update the code according to some new business rules. Unfortunately we don't have a test environment where I can upload the code and test it until it works. Therefore I would like make the changes necessary in the code and somehow change the version number of the dll and deploy that to the database while the old dll is still used in production.

I've heard of the workaround with strong/weak assembly names but I'm wondering if there's a real versioning method around yet.

And yes I know the "easiest" way would be to create a testenvironment and ahve the normal setup with test/production servers but I still would like to know if my original idea is possible in any way.

Kind regards


.net difference between versions


 what is the difference between .net 2.0/3.0/ 3.5

Error: Encountered multiple versions of the same assembly with GUID...try pre-importing...TlbImp


Hi!  Can someone tell me how I can troubleshoot the following error: "Encountered multiple versions of the same assembly with GUID...try pre-importing one of these assemblies".

The website developed in VS 2010 (.Net 3.5). This error is only received on my workstation.  Another person developing the site does not experience this issue at all.  Also, not sure if this matters, but on my workstation the 'Assembly Information...' dialog contains no values even though the 'AssemblyInfo.vb' file does specify values for the title, desc, etc.  The GUID being referenced in the error is the main project of the three projects within the solution.

I tried looking through the GAC, but do not see any references to the projects or DLLs in the VS solution and am not sure what else/where to look.

If I delete the copy of the solution on my local machine and pull down a copy from source control (AnkhSVN) the solution will build with no error.  Once I make any changes, such as adding a new aspx file, then the error is received.

I can provide any additional information needed.

Advanced Serialization: Format Your Way to Success with the .NET Framework Versions 1.1 and 2.0


While .NET offers adequate support for the simple serialization cases, issues arise when you're attempting to support delegates and subscribers, versioning, and class hierarchies. . In addition, the introduction of generics in The .NET Framework breaks new ground in the complexity of the serialization task and the power of serialization tools. This article discusses these issues and related pitfalls, suggests techniques and workarounds that address them, and recommends when and how to best use the new serialization abilities.

Juval Lowy

MSDN Magazine October 2004

List views for versions



We have a list with versioning enabled. When an item is edited a new version is created for the particular item.
Is it possible to create a view to list only a particular version of items and data in that version?


SQL2005 backup Issue

After moving the SPS 2003 portal from one disk to another, I am having a problem in backing up the portal from the spsbackup tool as well as through the SQL Server 2005 database backup option . Following is the error am getting:-   ============================================================================================================================= Backup failed for Server 'sql server name'.  (Microsoft.SqlServer.Smo)   ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476   ------------------------------ Program Location:      at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)    at Microsoft.SqlServer.Management.SqlManagerUI.BackupPropOptions.OnRunNow(Object sender)   ===================================   System.Data.SqlClient.SqlError: The backup of the file or filegroup "sysft_ix_ContentDatabaseName" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)   ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=

SQL2008 - Cannot Restore a new database from a full backup of a different one, database in use

I am trying to restore a brand new database from a copy of another one and am encountering an error message stating: System.Data.SqlClient.SqlError: The file <Backup source database file location> cannot be overwritten.  It is being used by database <Backup Source Database>. (Microsoft.SqlServer.Smo) I am running the Restore procedure with the REPLACE option and am wondering why it is stating that the source database is the database in use when I am trying to restore and overwrite a completely different database. This issue happens when running the replace both in C# using SMO and when manually restoring with SqlServer Management Studio Interesting note is, the original source database is created / deployed using a database project within VisualStudios 2010 and then deployed to SqlServer through VisualStudios. Any thoughts on why this is happening? Thanks in advance for any help!



SQL2008 Standard setup failed. The performance counter registry hive is corrupted.

OS: Windows7 Ultimate 64bit (Traditional Chinese HKSAR) SQL: SQL Sever2008 RC2 Standard English (either x86 or x64) I have searched for answers on the web, tried all of them and still cannot get pass. 1. manually rebuild Performance Counter Library values as suggested in http://support.microsoft.com/kb/300956/en-us 2. string test = string.Format ("{0,3}", CultureInfo.InstalledUICulture.Parent.LCID.ToString ("X")).Replace (" ", "0"); which shows "31748" for me, added it under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib (with values from 009) 3. C:\windows\systrem32\lodctr /r to rebuild counters.   The error just won't go. Actually, I just want to use the management studio to connect to SQL Server2008.. Is there a way to install only the management studio? I am willing to give up installing SQL Server2008 on my Windows7.   Thanks in advance.

Detect other versions of SQL Server, or SQL server instances on a computer

Hi All, I want to detect other versions of SQL Server, or SQL server instances on a computer. I used the recommended Microsoft C# example by using the SQL Server Windows® Management Instrumentation (WMI) provider. http://msdn.microsoft.com/he-il/library/dd981032(en-us,SQL.100).aspx SQL server 2005 has been correctly identified on my PC with Windows 7 64 bit OS. Then I uninstalled the SQLserver and all its tools/components. But even after uninstall the utility detects the SQL server 2005 as if it was not removed. What is an alternative for the correct detection of the SQL server installed on PC? Thanks in advance Dmitry

Connecting to Sql2008 from vb6 using sqlncli

I used to connect to a sql2005 database from Vb6 with this connectionstring, using sqlncli:   "Provider=SQLNCLI;MARS Connection=True;Integrated Security=SSPI;Initial Catalog=Y1;Data Source=thinkpadfp2\instancename;"   Today i uninstalled Sql2005 and installed Sql2008 RTM.   Using the same connectionstring, now i receive the error:   "3076 - Unable to find provider".   In vb.net i can succesfully connect using sqlclient namespace, the problem is only in vb6.   sqlncli is correctly installed.   Any suggestion?   Thanks.

CSS Validation versions

I have VS2010, doing a web site.  When I build, I get CSS warnings for some properties because they don't validate against css 1.0.How do I change from CSS 1.0 to 2.0 by default?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend