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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Problems migrating 32-bit SQCLR routine to 64-bit SQL Server

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
 
Greetings. I have written a 32-bit SQLCLR routine that uses the 10.2g Oracle.DataAccess library to draw Oracle data through SQLServer queries. (This tool was necessary due to issues we had with the Oracle native client). This has been in place and working without issue for about two years. This tool required the independent registration of about six (?) other system assemblies, which worked without incident (various warnings about using unsupported assemblies aside). We use permission_set = unsafe for all these DLL's. We are now in the process of migrating this tool to the newer 64-bit version of SQL Server 2008 on our Windows 2008 Server R2, and we have a problem. We took our list of base assemblies from the 32-bit installation and registered them against the Framework64 version of the same DLL's on the SQL Server 2008 box, and that step worked. We found that the Oracle.DataAccess library we had could not be registered in the 64-bit SQL Server because it was an x86-specific version. We then discovered that the 64-bit version of the Oracle.DataAccess library was available only in the 10.2.0.4 update patchset, which we obtained and installed. Unfortunately, adding the assembly now fails: When I attempt the CreateAssembly on the 64-bit Oracle.DataAccess.dll within the 64-bit instance of SQL Server, I now receive a new error, to-wit: "Assembly '


View Complete Post


More Related Resource Links

Migrating aspnet tables to dev server - having issues

  

Hi,

We're trying to migrate a one of our apps to our dev server for testing and development, but we're having problems with the membership functionality. We can add users, but there seems to be a disconnect with roles. We can query the aspnet_users table and find the new user in there, but when we query the aspnet_usersinroles table, that user id is not present.

We're also unable to run the Roles.GetUsersInRole("somerole") method. It returns 0 records. When I run Roles.ApplicationName, it returns the correct name, so .NET should be passing the correct app name.

We're just a little baffled. If anyone could shed some light on what could be the issue, we would appreciate it.

Thanks! :)


Problems building 32-bit .NETapplication that uses 64-bit COM server

  
I have a .NET application that uses a 3rd party 32bit DLL, so I need to build it using the x86 platform instead of 'Any CPU'. I also have a 64bit out-of-proc COM server that I reference the EXE directly in the project.  The project builds fine for 'Any CPU' but can't run on 64bit Windows because of the 32-bit dll.  This is expected.  But when I specify 'x86' the build fails and I get: TlbImp : error TI0000: A single valid machine type compatible with the input type library must be specified. C:\Windows\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.targets(1558,9): warning MSB3283: Cannot find wrapper assembly for type library "Engine_ATLServiceLib". Basically this tells me that it failed to build the Interop Dll for the COM server object.  First off I am puzzled that I get this message when a platform is specified, I would've expected this when I build for 'Any CPU'.  That aside, I am thinking the TlbImp needs a '/Win32' or something, but I can't see how to do this in the IDE based on the platform.  Furthermore I am wondering if the marshalling in said Interop dll will be correct when the 32bit managed code talks with the 64bit COM object. Does anybody know what to do here?

Having problems installing/setting up SQL Server 2008 Express/R2 for ASP.NET user management on deve

  
I'm a bit new to installing and configuring, well, just about anything regarding databases, so please bear with me. I'm currently building a couple of ASP.NET MVC 2 sites.  I'm following along with the MVCMusicStore tutorial, and am trying to set up user management using ASP.NET's configuration tool.  The problem is that ASP.NET can't 'see' the database. I have SQL Server 2008 installed on my laptop.  It's the version which is available on the Web Platform Installer (I believe it's Express).  When I try running the aspnet_sqlreg.exe program to set up my user management database, it can't tell that I'm running any version of SQL Server at all.  I get an exception about 'named pipes', and some other things I don't understand at the moment. Obviously, this is all a bit over my head.  Is there an idiot proof guide or tutorial available that describes, step-by-step, how to: 1. Install SQL Server 2008 on a development PC 2. How to configure it to be used by Visual Studio 2010 Professional 3. How to properly upload/modify the db on the production server with what's on the development PC Essentially, all the things that the ASP.NET tutorials gloss over.  Any suggestions, links to documentation, or other nudges in the right direction would be immensely appreciated.

problems with using SQLEXPRESS database on a server

  
I made an application that reads a KML file every few minutes and puts the data in a SQLEXPRESS database. It works perfectly on my laptop, but when I move everything to the server where it has to run, the application doesn't find the database anymore. I tried lots of connectionstrings already, but none works. I have to admit that my knowledge of connectionstrings is not that big, so I think the answer will be very simple. In my program I point to the app.config file who looks like this atm (remember, I changed the connectionstring a couple of times already, and I have no idea anymore where I started): <?xml version="1.0" encoding="utf-8" ?> <configuration> <connectionStrings> <add name="ships" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Inetpub\ftproot\eu006202\www.ortelius.icso.be\AIS\ships.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> </connectionStrings> </configuration> I pasted the error I get on http://www.webbouwers.be/error.png Any idea what I need to do to get it work? Thank you in advance, L.

I am getting some problems to install the sql server ....Plz help me,....

  
System Configuration Check - WMI Service Requirement (Success)  Messages  * WMI Service Requirement    * Check Passed   - MSXML Requirement (Success)  Messages  * MSXML Requirement    * Check Passed   - Operating System Minimum Level Requirement (Success)  Messages  * Operating System Minimum Level Requirement    * Check Passed   - Operating System Service Pack Level Requirement. (Success)  Messages  * Operating System Service Pack Level Requirement.    * Check Passed   - SQL Server Edition Operating System Compatibility (Success)  Messages  * SQL Server Edition Operating System Compatibility    * Check Passed   - Minimum Hardware Requirement (Success)  Messages  * Minimum Hardware Requirement    * Check Passed   - IIS Feature Requirement (Success)  Messages  * IIS Feature Requirement    * Check Passed   - Pending Reboot Requirement (Success)  Messages  * Pending Reboot Requirement    * Check Passed   - Performance Monitor Counter Requirement (Success)  Messages  * Performance Monitor Counter Requirement    * Check Passed   - Default Installation Path Permission Requirement (Success)  Messages  * Default Installation Path Permission Requirement &n

SQL Reporting Server connection problems?

  
I tried setting up SQL Server Reporting Services (per TFS Guide) and having issues connecting to the server. When i try to go to : http://MyyServer/Reports I get following error:   User 'MyServer\Admin' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. When i try to go to: Http://MyServer/ReportServer i get the folowing error: The permissions granted to user 'MyServer\Admin' are insufficient for performing this operation. (rsAccessDenied)  I get a login dialog when i try to connect and i always use the machine admin/SQL Server sysadmin account I have of course searched on this problem and found a variety of blogs but none of them have resolved my problem. For example i tried to run IE in admin privileges and i still get the same error. I've try to uninstall/reinstall (even deleted sql server directories to make sure there was no cruft left over) and it didn't help. I don't know exactly how the http connections to reporting server happen but i tried to go into IIS expecting some reporting services virtual folders or something like that and i don't see anything. 

Problems with linked server to Analysis Services (SQL 2008)

  
I have problem with creating linked server from SQL database to Analsis services. BOth services are running on same machine. Operating system is Windows 2008. I create linked server (I use windows authentication and I am administrator on AS):  EXEC sp_addlinkedserver @server= 'OLAP_PRETOKI', @srvproduct = '', @provider='MSOLAP', @datasrc='localhost', @catalog='DWDatabase'  But when I try to test connection I get error (in the event log) and in the error log/dump I get this: 2010-09-03 13:48:28.41 Server Error: 17310, Severity: 20, State: 1. 2010-09-03 13:48:28.41 Server A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 2010-09-03 13:48:32.53 spid58 Open of fault log C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\log\exception.log failed. 2010-09-03 13:48:32.65 spid58 Using 'dbghelp.dll' version '4.0.5' 2010-09-03 13:48:32.66 spid58 SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2010-09-03 13:48:32.66 spid58 * ******************************************************************************* 2010-09-03 13:48:32.66 spid58 * 2010-09-03 13:48:32.66 spid58 * BEGIN STACK DUMP: 2010-09-03 13:4

Problems with linked server to Analysis Services (SQL 2008)

  
I have problem with creating linked server from SQL database to Analsis services. BOth services are running on same machine. Operating system is Windows 2008. I create linked server (I use windows authentication and I am administrator on AS):  EXEC sp_addlinkedserver @server= 'OLAP_PRETOKI', @srvproduct = '', @provider='MSOLAP', @datasrc='localhost', @catalog='DWDatabase'  But when I try to test connection I get error (in the event log) and in the error log/dump I get this: 2010-09-03 13:48:28.41 Server Error: 17310, Severity: 20, State: 1. 2010-09-03 13:48:28.41 Server A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 2010-09-03 13:48:32.53 spid58 Open of fault log C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\log\exception.log failed. 2010-09-03 13:48:32.65 spid58 Using 'dbghelp.dll' version '4.0.5' 2010-09-03 13:48:32.66 spid58 SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2010-09-03 13:48:32.66 spid58 * ******************************************************************************* 2010-09-03 13:48:32.66 spid58 * 2010-09-03 13:48:32.66 spid58 * BEGIN STACK DUMP: 2010-09-03 13:4

Problems with SSRS 2008 Install when configuring a back-end database on a SQL Server 2008 R2 environ

  
We are tyring to configure SQL Server Reporting Services (SSRS 2008) not the R2 version with a SQL Server 2008 R2 version of database. We are facing error when the configuration manager within SSRS tries to execute its scripts against the database. Do you think that SSRS 2008 may have trouble using a SQL Server 2008 R2 version as the back-end? Also, what kind of permissions does the ID installing SSRS needs to have on the SQL Server database ?  Not much is available in the documenation or online.

Migrating to Production server

  
Hi All, We have a dev server in which we have two databases which we are maintaning for 3yrs.The tables in these databases have data for 3yrs like in millions. now we are planning to migrate it over  to production server.the dev  server will be with us but the whole databases and jobs and everything from dev server should be migrated to the new production server. can anyone guide me the step by step process how to migrate the dev server to production server. I need to prepare a document for the production people to get this done. Thanks in advance.

Problems with url rewriting when using the ASP.NET development server

  
I've inherited a website which has been developed for IIS server. The hyperlinks in this website have a href attribute with the human readable form that appears in the url in the browser's searchbar. In Application_BeginRequest(), there is a method which will convert this into the acutal location of the page within the website's file structure.This works fine when running the website on IIS. However, when I am using the ASP.NET development server, the links do not work and I get a page not found error.I have noticed that Application_BeginRequest() is never called for the links when run using the ASP.NET development server. I have read that the ASP.NET development server will not serve pages that are outside of the application scope (http://msdn.microsoft.com/en-us/library/58wxa9w5%28VS.80%29.aspx), as the human-readable urls would appear to be when first processed by the server.Bear in mind that the urls in the aspx files are in human readable form, so I can't just use ResolveUrl(), because they don't correspond to files in the internal file structure until they have been re-written.I want to get the website running on the ASP.NET development server so that I can test it locally on my machine, which I can't really do if I can't get the url re-writing to work. Is there a way around this problem?

SQL Server 2005 Installation problems

  
I have SQL Server 2005 Developer Edition 9.00 1399.06 running on Windows XP.  I have upgraded to a Windows 7 64-bit computer, and have attempted to install SQL Server on this machine.  The install procedure failed, probably because I was installing from a copy of the install disks on a USB drive rather than the original CDs.  (I am carrying out the upgrade in a different country to my office and I did not want to risk losing the original install CDs). The install failed, and I realised that I had to install from CDs.  I then uninstalled all the SQL Server programs.  However, the uninstall procedure told me the program was already uninstalled.  However, when I try to reinstall from CDs, I am told that SQL Server Database Services, Analysis Servics, Notification Services and Integration Services are already installed. Therefore I am at an impasse.  I cannot uninstall the programs and I cannot reinstall the programs.  I have tried a registry cleaner (CCleaner) to get rid of registry settings and removed all SQL Server folders, but to no avail. How do I progress without having to reformat my entire computer?  I cannot believe that an installation procedure can be so limited - why isn't a reinstall option offered even if the computer records the programs to be present? I look forward to some suggestions on how to fix this. &n

Problems installing SQL Server 2005 Integration Services for Server 2008 R2

  
I am trying to install Microsoft Forefont and i have got a tick on every requirement bar 1. I can't install SWL Server 2005 Integration Services Component. I am running windows Server 2008 R2. I have tried numerous steps such as going into to control panel and adding component but the Integration services is not appearing on the options. Is it actually possible to install 2005 integration services on server 2008 and if so how? Thanks

problems in sql server 2005 installation

  
Hello everybody   Ok the problem is that i have sql 2000 in a computer with windows 2000 professional sp4. i'm trying to install the sql server 2005 in other instance. When the installation begins i don't have any problem, but when it ends, y try to enter to the manage studio and is not in the start menu. Sql 2000 is ok but i can't work in 2005 i reinstall both versions but the problem persist. I delete all the files in the instalation but when i install it again the problem apperas again. how can i install both versions?

SQL 2008 R2 problems on a Windows 2008 R2 Enterprise server

  
We are receiving the following error message when installing SQL 2008 R2 on a Windows 2008 R2 Enterprise server. "Unhandled exception has occurred in your application. if you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. It specialist

Windows 7, SQL Server 2008 Express & VWD 2008 Express Setup Problems

  
Hi I have Windows 7 Home Premium, and Visual Web Developer Express 2008 (which came with SP1) installed. SQL Server 2008 Express never worked - Windows 7 won't allow the Management Studio to be installed and VWD was asking for SQL Server 2005.  Looking on the web, I found advice to try the 32 bit version of SQL Server instead.  This would work with VWD, apparently.  I referred to these instructions (http://download.microsoft.com/download/1/6/3/163A851B-D956-42E9-B426-F5C0EBE6B654/ReleaseNotes.htm) and used the latest links and instructions, but I could not install SQL Server at all - apparently something to do with WOW64... This has been going on for a WHILE and I'm going nuts.  I am reluctant to uninstall VWD and start again, because I had to manually fix a few things, and now it's working...  PLEASE can someone tell me of a working configuration, I have read SO MUCH advice on this, and none works, including those release notes (unless I missed something) :(

Real Server noob having mail problems.

  
Hi Everyone, I have coded my application to send mail and it works fine some of the time depending on the to or from address specified in the particular message but at other times I am getting a relay error. "The server will not relay mail for foreign domains". I HAVE authenticated myself to the mail server using a valid username and password in the code. Basically here is the setup. Our site is hosted overseas in the states with one company, our nameservers are also in the states but with our company not the hosting company. Our mail server is local (that is here in New Zealand). I'm pretty sure that the code is right because I've read dozens of posts on here which point to coding errors and it seems to be right. Do I need MX records or anything like that in some place? What do I do? Thanks  
Categories: 
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