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

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

System DSN created on x64 08 server but not visible - SQL08 x64 to be used by x32 app

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
Hi all, I am trying to create a SystemDSN on a 64bit Windows 2008 server. The application that will use it is a 32bit app so i go into C:\Windows\SysWOW64 and run as admin odbcad32.exe I then go ahead to create a systemDSN to a SQL2008 database using the SQL native client. All off the steps of the systemdsn creation wizard go thrugh and i get a success at the end. But then i get no new systemDSN listen in the box. The user that is doing the creation is a domain administrator and also in the admin group on the particular server. This is really strange to me. Has anyone seen this behaviour? SQL server 08 is x64 on a x64 machine. The reason i am using the 32bit ODBC is beacause the app is x32 app. Any advice? Cheers Dan

View Complete Post

More Related Resource Links

System.IO.Packaging is not visible


I am new to ASP.net, I installed VS2005 and IIS 5 on my PC and set up my first website using IIS (not the embedded webserver in VS).

For some reason I cannot find the Assembly: "System.IO.Packaging", please let me know if I am allowed to use it in that medium and how can I reference it?

Thanks in advance.

how i can install sql server in my system


which edition of sql server  are best for me  Developer edition or express editon for development purpose.

i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.

Team System: Team Foundation Server Event Service


Use the Team Foundation Server EventService to create and manage event subscriptions or create a Web service to receive and process events.

Brian A. Randell

MSDN Magazine May 2008

Team System: Team Foundation Server Version Control


In this new column, Brian Randell begins his long look at how to extend and enhance Visual Studio Team System.

Brian A. Randell

MSDN Magazine January 2007

Types in Yukon: Managed UDTs Let You Extend the SQL Server Type System


The next version of SQL Server, code-named "Yukon," will offer enhanced support for user-defined types (UDTs). Because UDTs can be managed by the CLR, you can represent a wide variety of data structures to create types not possible with previous versions of SQL Server. With UDTs you can more precisely control the kind of data your type accepts, resulting in better data management. This article explores UDTs in "Yukon" and covers their design and implementation.

Peter W. DeBetta

MSDN Magazine February 2004

Windows Server 2003: Discover Improved System Info, New Kernel, Debugging, Security, and UI APIs


There's a lot to say about Windows Server 2003. First of all, it's the first operating system with built-in .NET Framework support, and it's the first 64-bit OS from Microsoft. But wait, there's more! There are lots of new features and APIs in this version as well. For instance, Windows Server 2003 features Hot Add Memory and a number of other arcane new tidbits. There are new APIs for handling threads, directories, and files, and new features like the low fragmentation heap for managing memory and system information. There's vectored exception handling and new UI APIs as well.OS internals expert Matt Pietrek takes a look at the additions he finds most interesting and useful so you'll have a good place to start when you dive into Windows Server 2003.

Matt Pietrek

MSDN Magazine June 2003

MS Word Component Not Getting Created on Windows 2008 64 bit Web Server Edition When I Try Using ASP

Hi All, This might look like a similar question to a lot of you considering there are a lot of web activity happening in terms of blogs/forums/suggestions that I have seen with reference to changes that one needs to do in COM+ Services to enable their ASP.NET Web Application to be able to create Word Objects & I have actually used them personally & they worked for me on Windows 2003 32 bit/64 bit servers. The issue started some 1 month back when I was told that we are upgrading our server to Windows 2008 Web Server edition 64 bit ‘cause of some real benefits it offers if used only as a web server. This was just great as we tested a lot of features /functionality that we were using on our existing server & everything seems to be working just fine on this product by Microsoft. However we also have one web module which is responsible for opening up a MS Word 2007 template file at runtime and fill it with data & is then converted into a PDF document. A lot of ideas on Web suggested that we should move onto Open XML standards to generate documents at runtime, which I have been able to do with no issues. But one activity which still requires me to create a Word document is when I have to convert/SaveAs the Word (docx) document into PDF. I tried all the COM+ & registry related changes that I did on my Windows 2003 64 bit server, but nothing seems

HOWTO add a C#.NET library to SQL Server as an assembly that uses such references as system.web.

HOWTO add a C#.NET library to SQL Server as an assembly that uses such references as system.web. I have a C# library (dll) I want to add to SQL Server via "CREATE ASSEMBLY", but the DLL uses these references: Microsoft.VisualBasic System System.Core System.Data System.Data.DataSetExtensions System.Drawing System.Management System.Web System.Web.Extensions System.Web.Mobile System.Web.Services System.Xml System.Xml.Linq And just to be clear, the DLL is a .NET 3.5 app, with the SQL Server being SQL Server 2008. Right off the bat, the "CREATE ASSEMBLY" call fails due to System.Web, which strangely, is The CREATE ASSEMBLE says this error: Msg 10301, Level 16, State 1, Line 1 Assembly 'MyLibrary' references assembly 'system.web, version=, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request. I have tried to use VS 2010, to create a SQL Server DB project, and it point blank does not let one add references to things like System.Web. When trying to use "Add Ref", VS 2010 literally lo

SSL Using Server Created Certificate

We need to secure a SQL server using an SSL certificate and I understand there are a couple of ways of doing it.  One of which is having SQL Server generate a self-signed certificate which exposes the man-in-the-middle attack vulernability.  Thus we want to avoid this approach.  My question is, can we just allow the Windows Server 2003 we are running to be configured to be a Ceriifcate Authority and ust it create an SSL certificate.  Is that just a secure as getting an SSL certificate from a third party company such as Verisign?  If it is better to go with a third party company, how do you get a certificate from them when it is not going to be used for a website? Thanks NickNick's Programming Tips

Unable to open physical file - Operating system error 5: 5(error not found) Microsoft SQL Server: Er

I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.   I get the following message: Unable to open physical file "C:\ArrowSQL\Arr@Data\Arrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".   I have loaded SQL and the database fiel and directory with the same user acccount which is a local adminstrator ont hsi machine. I have checked that I have read/write access to the file.   The machine runs Windows Vista Business. SQL has SP 2 loaded.   What causes this?

'System.OutOfMemoryException' SQL Server 2005

Looking for a solution to SQL Server 2005 'System.OutOfMemoryException' error, or at least the root cause of this error.   Following please find:1) Description of problem2) Exact error message3) Query that fails (against large 'SourceTable', but works against smaller subsets of 'SourceTable' )4) Query that works (above, split apart) on any size table5) Machine and SQL configuration and versions DESCRIPTION OF PROBLEM-------------------------------------------------------I am getting a 'System.OutOfMemoryException' error running a simple query on a large table in SQL SERVER 2005. If I run with a fresh boot, only me on the server, and only SQL Server Management Studio open with 1 query window, I'll get this error when I run it against my full-sized SourceTable.  Task Manager indicates there is still more than 7 Gig of physical memory available! (see system configuration at end of this note).   The query runs to competion if I run it against a smaller 'SourceTable'.    If I break out the matchup to the derived table from the query into a separate step, the query will run until completion against any size table I throw at it.   I've searched the web, and found that people are getting this error with SQL Server 2005, but not with SQL Server 2000.  It looks like people are encountering it in various queries that should work, and in other circumstances such as when runn

unable to create new table in sql server 2000 enterprise manager on windows7(Operating system)

i have successfuly installed sql server 2000 on windows7 and i am able to browse all the tables and edit aswell(on enterprise manager) but i have a problem while creating new tables it says ' MMC has detected an error in a snap-in' and provides options to either continue with the error or send a report to microsoft ,   Please help regarding this compatibility issue   Thanks in advance !

I am getting System.Web.Services.Protocols.SoapHeaderException: Server unavailable error?..

 Hi,    I am using WSE 3.0 for my applicaton. when run from the client end I am getting following error.System.Web.Services.Protocols.SoapHeaderException: Server unavailable, please try later ---> System.ApplicationException: WSE841: An error occured processing an outgoing fault response. ---> System.Web.Services.Protocols.SoapHeaderException: Microsoft.Web.Services3.Security.SecurityFault: Header http://schemas.xmlsoap.org/ws/2004/08/addressing:Action for ultimate recipient is required but not present in the message.  at Microsoft.Web.Services3.Design.RequireSoapHeaderAssertion.RequireSoapHeaderFilter.ProcessMessage(SoapEnvelope envelope)  at Microsoft.Web.Services3.Pipeline.ProcessInputMessage(SoapEnvelope envelope)  at Microsoft.Web.Services3.WseProtocol.FilterRequest(SoapEnvelope requestEnvelope)  at Microsoft.Web.Services3.WseProtocol.RouteRequest(SoapServerMessage message)  at System.Web.Services.Protocols.SoapServerProtocol.Initialize()  at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)  --- End of inner exception stack trace ---  --- End of inner exception stack trace ---         Help needed on this. re

Where is System.Web.Extensions.dll now? Fails on remote hosted server.

I've read all the notes about how from RC2 to ajax.net the name space has changed. "The core ASP.NET AJAX assembly has been changed from Microsoft.Web.Extensions.dll to System.Web.Extensions.dll. In addition, the namespace has changed from Microsoft.Web.* to System.Web.*. For some reason, my app runs on my local machine but when I copy it to a remote server (that does not have the ajax updated installed) it fails.  How can I get an IIS installation to work?  Am I missing a dll that I can push up to the remote server?  I can't run the install on the remote machine becasue it's a hosted server. Thanks

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object canno

hello,i am using a web servicewrtitten in .net and i access the webservice from my wepApplication i get this error System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object cannot be cast from DBNull to other types.my code is access webservice: protected void btnSave_Click(object sender, EventArgs e)        {            int intStatusCode;            dtProjectStatus = (DataTable)ViewState["dtProjectStatus"];            try            {                objService.Credentials = System.Net.CredentialCache.DefaultCredentials;                if(dtProjectStatus.Rows.Count>0)                {                  intStatusCode = objService.InsertTest(dtProjectStatus);                }   

need help moving System Center SQL Databases to new SQL Server about30 databases to be moved...

We are running various System Center products, SCSM, SCVMM, SCCM, DPM, OPALIS. and a few other servers all using the same SQL server, which currently is a VM. We have configured and built a new Physical box that will replace this. In the past we have moved SQL databases by doing a full backup and then restoring the backup on the new server, then renaming the servers, both network name and internal sql name.  This has worked fine in the past. However I've never had to move 30 databases before, nor have I had to move reporting services. Is there a better method. a recomended method? 

System.Diagnostics.Process.Start not work with IIS, but on ASP.NET Development Server

System.Diagnostics.Process.Start not work with IIS, but on ASP.NET Development Server 
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