Windows CE Platform To SQL Server
Jun 14, 2007
I am writing applications for barcode readers that send and receive information via wi-fi to a 2003 Server running the full MS SQL Server 2005. The readers are both XP and CE .NET 5.00 based.
The information is time critical so I need to scan a barcode then send that information to the SQL Server and then in turn run a query based upon it which then displays on the reader. I have no problem with the XP devices as I can link via ODBC to the SQL Server. These work perfectly.
I can also run a program on a XP desktop using Remote Desktop on the CE device which again works fine.
The CE .NET 5.00 readers are a problem as I cannot use OBDC or OLE DB owing to the platform.
Is there any method available where I can query the SQL Server directly without using some kind of third party product like ViaDB from Odyssey Software? I cannot use replication owing to the time constaints.
Any suggestions or gentle prods would be appreciated.
Norman
View 3 Replies
ADVERTISEMENT
Mar 11, 2000
I am using windows 98 and I want te use SQL server 7.0. I have installed the non-enterprise edition....But it won't work....
The service manager in istalled succesfully and all the other utilities to.
But it still wont work. Is somebody out there who can help me on this.
Tnx
View 2 Replies
View Related
May 3, 2007
hello... my SQL database is being not able to be accessed by application when i run through VS2005 . I created the database in XP sys now brought to a NT systeem..what shd i do ..??? pls help
View 1 Replies
View Related
Apr 12, 2007
I've got XEON x64 server and after SQL Server 2005 installation found that the platform in property says AMD64 and not INTEL64 as expected.
I was assured by our service provider that AMD64 platform is the correct one as it was compiled for INTEL x64.
Does anybody have an answer to it?
View 1 Replies
View Related
Jan 2, 2007
Hi, All:
We have to migrate several 64Bit SQL Servers to 32Bit platform. Due to the 64Bit source systems are all production system, the downtime is too limited. So we can only get the DB files via Detach way. Among the source systems, both SQL2000 and SQL2005 exist.
My question are:
Is it possible to migrate the DB from 64Bit to 32Bit via Detach/Attach?
If ok, how to do that?
Any info will be highly appreciated! Thanks!
Best Regards,
Kevin
View 1 Replies
View Related
Nov 13, 2007
Hi ,
We want to install 2 applications that run on SQL server 2005 but the requirement of database installation are different Collation setting ( One require Dictionary order, case-insensitive, for use with 1252 Character Set and other require Dictionary order, case-sensitive, for use with the 437 (US English) Character set).
So the question here could I install both two applications successfully on same platform ? and if yes how?
Thanks and regards,
Quinh
View 5 Replies
View Related
Apr 28, 2008
Hello!
Since 2 weeks now I'm trying to figure out how to get SQL CE 3.5 into the CE 6.0 R2 image (I'm building my own image with platform builder 6.0, latest patches - until march 2008 - installed).
There is no Catalog item in my "Catalog item view" not even an older version of SQL!
In Platform builder 5.0 there were Items in the Catalog and - as expected - by selecting them I got the server into the image.
I also tried to add "SYSGEN_SQLMOBILE = 1" to the project environment variables, which resulted in having build errors instead of getting a working image.
There are also some postings around in the internet telling how to add the required dll's manually.
(Hey, Microsoft, do we live in stone age or in the 21st century?)
Btw. installing the cab files is possible for me, but of course not for our customers.
Are there any sugesstions how to get a catalog item?
best regards,
Martin.
View 2 Replies
View Related
Sep 10, 2007
Hi-
I am doing some technology research for a new app and was wondering about the desktop operating system support for SQL Server compact edition. This app has a PC component and a mobile component, and both need to be data enabled, with syncronization between the PC and the mobile device.
So it seems like SSCE would be a good fit. Just run the SSCE client on both the PC and the device. But in the system requirements for SSCE it only gives XP as a valid desktop OS...
Is that correct? Obviously, desktop platform support for a production app will need to be broader than just XP.
Will SSCE desktop run on Win98,Win2000,XP Home, and Vista?
View 5 Replies
View Related
Jun 26, 2006
Is this possible to connect do the Database Engine (on sql server 2005 on XP platorm - file *.mdf (not mobile *.sdf)) from win CE 5.0?
I tried to do this :
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS;Initial Catalog=dbMachines;Integrated Security=False;Password=Panel;User ID=Panel";
SqlCeConnectionCE = new SqlConnection(ConnectionStringSQLServerCE);
SqlCeConnectionCE.Open();
but I catch error:
catch (PlatformNotSupportedException ex)
€žPlatformNotSupportedException€?
I noticed that I see server because when I use:
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS";
zwraca błąd typu
catch (SqlException ex)
€œLogin failed for user ''. The user is not associated with a trusted SQL Server connection.€?
I used
using System.Data.SqlClient;
from Compact Framework 2.0 under Visual Studio 2005 Device Application Windows CE 5.0
can anyone help me?
View 1 Replies
View Related
Jun 19, 2007
Our server is 64 bits OS. After SQL instalation we try to load the Reports web site and the server return the following error, can anyone help us?:
Attempted to load a 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if trying to load for reflection purposes.Server
Error in '/Reports' Application.
Attempted to load a 64-bit assembly on a 32-bit platform. Use
ReflectionOnlyLoad() instead if trying to load for reflection purposes.
Description: An unhandled exception occurred during the execution of the current
web request. Please review the stack trace for more information about the error
and where it originated in the code.
Exception Details: System.BadImageFormatException: Attempted to load a 64-bit
assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if trying to
load for reflection purposes.
Source Error:
An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[BadImageFormatException: Attempted to load a 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if trying to load for reflection purposes.]
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141
System.Reflection.Assembly.Load(String assemblyString) +25
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32
[ConfigurationErrorsException: Attempted to load a 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if trying to load for reflection purposes.]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596
System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +3479065
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +46
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177
System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180
System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +3446645
System.Web.Compilation.BuildManager.CompileGlobalAsax() +51
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +462
[HttpException (0x80004005): Attempted to load a 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if trying to load for reflection purposes.]
System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +456
[HttpException (0x80004005): Attempted to load a 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if trying to load for reflection purposes.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426871
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.42
View 1 Replies
View Related
May 18, 2007
As painful as it is proving out to be, I am trying to create a single package that is vendor neutral between SQL Server and Oracle.
At first, I thought that as long as I was going OLEDB in and out, and I ensured that my SQL syntax was generic enough, I'd be OK.
Well, not exactly. I am finding there is more to this. Specifically, metadata gets generated differently based on the source/targets.
For example, on an OLE DB Source task, datatypes will vary (i.e. NUMBER in Oracle vs Int in SQL). The job here is to pick the common denominator for the SSIS specific type. Time consuming, but doable, I think.
Another issue is on an OLE DB Desitnation. If you choose Table for Data Access Mode, this value gets written to the dtsx XML file. So, even when both RDBMS have the same schema (which is an obvious prereq) if choosing SQL Server "dbo.DimTable" will get written to the file and for Oracle "SCHEMA.DIMTABLE" will get written.
So, I am am wondering, what is the best way to address this?
My inital thought was using a dtsConfig file (which I am already using extensively) and set the target table names accordingly. This approach would have the added benefit of allowing for post-deployment configuration changes should a table name change, for example.
This section of the dtsx file shows the values of interest:
Code Snippet
<component id="138" name="OLE_DST_DimTable" componentClassID="{E2568105-9550-4F71-A638-B7FE42E66922}" description="OLE DB Destination" localeId="-1" usesDispositions="true" validateExternalMetadata="True" version="4" pipelineVersion="0" contactInfo="OLE DB Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4">
<properties>
<property'>http://www.microsoft.com/sql/support;4">http://www.microsoft.com/sql/support;4">
<properties>
<property id="139" name="CommandTimeout" dataType="System.Int32" state="default" isArray="false" description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property>
<property id="140" name="OpenRowset" dataType="System.String" state="default" isArray="false" description="Specifies the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">"ORASCHEMA"."DIMTABLE"</property>
<!-- More Properies -->
</component>
Ideally, I'd like configuration time control over the name attribute of the component element (highlighted) so that I can set the value of the property element with the OpenRowset attribute type (also highlighted). This way, presumambly as long as datatypes were generic enough, the mapping would just work.
But, in walking through the dtsConfig tree, I don't see these elements or attributes exposed.
I would sincerely appreciate any suggestions on how to accomplish this.
Rick
View 6 Replies
View Related
Dec 12, 2007
Is it Possible adding Windows (activi directry users) from SQL Server which is running Windows authotication.?
View 4 Replies
View Related
Mar 26, 2008
Hallo there,
I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.
My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.
I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress
But nothing happens!
Please i am very desperate, any information will be gratefully accepted.
This is my installation Information
Code Snippet
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001
Thank you in advance,
Patonios
View 3 Replies
View Related
Apr 17, 2008
Does any one come across any difficulty in the following migration?
OS: Wondows Server 2K
DB: SQL Server 2K Standard Edition
Migrating to
OS: Wondows Server 2K3
DB: SQL Server 2K Standard Edition
Thank you,
Gish
View 4 Replies
View Related
Aug 25, 2007
Hi,
I'm developing an application that will access a database, and then send the data to a server either in batch or as each item is updated over GPRS. The database will have a large table, with 20,000 records. Each record is about 150 characters. The data access needs to be as fast as possible. I'm not sure which platform/hardware to use to achieve maximum speed. I have experience with c#, sql server ce. Worked mostly on Windows Mobile 2003, but thinking of moving to WM 5 or 6. My question is what is the best combination of hardware, OS, development environment, and software to use?
thanks
awni
View 1 Replies
View Related
Mar 12, 2004
I need some feedback to bolster my position with a client who is planning a platform migration. They are currently running SQL 7.0 SP3 on Windows NT4 and want to upgrade to Windows 2003. First off, SQL 7.0 isn't going to run on Windows 2003, so their first response is "let's buy the licenses and run Win2000 and SQL7 until we're ready to migrate to SQL2000". Ok... licensing cost controls aside, they're investing significant $$ in acquiring the hardware. What's my most compelling argument for moving them to a Win2003/SQL2000 platform now. (Other than the wait for Yukon is likely to be significant ;-) )
Any feedback would be appreciated.
View 5 Replies
View Related
Jul 20, 2005
Hi,I'm planning to purchase Sql Server2000 St. Edt. and install it onwindows 2000 server machine. I would like to know please if it isadvisable to work on the same machine that host both servers or shouldI work on a separate one???MTIA,Grawsha
View 1 Replies
View Related
Apr 3, 2008
I'd like to integrate SQL CE 3.5 into a platform builder image(using PB 5 targeting CE 5), but I don't see it in the catalog. Is it currently possible to Sysgen an image with 3.5? Can I somehow deploy the files from the .cab files? Sorry if this has been answered before, I searched around a bit but didn't find anything.
View 6 Replies
View Related
May 8, 2006
When I try to run the x86 version of SP1 on my development desktop (for tools only), I get an 'Incorrect Platform' error:
Setup cannot update x86 products on this computer
To proceed, run the Service Pack Setup program for the x86 platform.
The filename I downloaded is SQLServer2005SP1-KB913090-x86-ENU.exe
and it successfully installed on my Wk2003 server (dual PIII). My desktop is a single P4 2.8Ghz running WinXP Pro.
brian smith
View 15 Replies
View Related
Jan 7, 2002
Hello:
Our company needs to (restore/migrate) our Alpha Nt4sp4 sql 6.5sp5a databases to an Intel hardware platform. For the time being the new intel server will be runing Nt4sp4 sql 6.5 sp5a. I understand that if we were to upgrade to sql 7 we would be able to restore the databases without any problems. However upgrading to sql 7 is not an option right now. I have tried to restore a backup from the alpha to an intel based machine, and it fails because the processor types are different.
I have already search technet, but found nothing, except upgrade to sql 7.
I am hoping someone out there could point me in the right direction.
Thank inadvance for your help, I appreciate it very much.
Cindy
View 1 Replies
View Related
Jul 5, 2001
How can i connect to the MS SQL server ruuning on Windows NT from a SOLARIS machine.?
Is there any client software available for this?
View 1 Replies
View Related
Oct 19, 2000
please please help?
For the last couple of days i've been trying to transfer a SQL6.5 database from an Alpha platform to an Intel one.
At one point i loaded SQL7 on the Intel platform and tried to perform an upgrade (using the wizard), across the network - but it just did not want to play.
Using Veritas Backup Exec, with SQL6.5 on both machines, i've tried doing a backup of the database on the Alpha platform and then restore to the Intel Platform, but this fails stating that the processors are incompatible
Am i trying something that is impossible?
If anyone could point me in the right direction i'd be truely grateful.
Sharpy
View 1 Replies
View Related
May 3, 2004
Does anyone know why the Extended Stored Procedure API (formerly Open Data Services) headers and libraries (e.g. srv.h, srvdbtyp.h, opends60.lib) are not in the new Platform SDK?
Older versions of the Platform SDK had these tools included, but I installed the new Platform SDK and they're not included. Is there another SDK that I need to download and install now?
View 2 Replies
View Related
Jan 31, 2007
I have to move our dedicated Sql 2000 transactional distributor to a new and faster machine. Great! Can someone give me or point me to a cookbook of the best way to do this? This has to be done quickly so I would like to script it and have it ready ahead of time. I am not a replication guru so I am a bit nervous . . . I have looked at the scripts output by EM, but I am sure there are some assumptions . .
Thanks
View 1 Replies
View Related
Aug 1, 2007
Hi
I have been successfully executing a series of IS packages from C# using the following syntax
Microsoft.SqlServer.Dts.Runtime.Package package;
package = app.LoadPackage(ISPackagePath + @"myPackage.dtsx", null);
package.ImportConfigurationFile(ISPackagePath + @"MyConfiguration.dtsConfig");
result = package.Execute();
package.Dispose();
My client has just moved their SQL boxes to a 64bit platform and this process no longer runs.
Now im also running some packages in a SQL Agent job on the SQL box and im aware of the issue of an SSIS job step defaulting to using the 64bit version of DTExec.exe. Ive updated those job steps to be operating system (cmdExec) type steps calling the 32bit version of DTExec.exe, and everything is fine there.
Is there anyway to force the Microsoft.SqlServer.Dts.Runtime.Package object in my C# code to use the 32bit version of DTEexec.exe? This code is running on the same 64bit SQL server box as the SQL agent job. Or will Microsoft.SqlServer.Dts.Runtime.Package object always default to using the 64 bit version if it is executed on a 64bit box ?
I would just call sp_start_job from C# and implement the IS packages in another job but unfortunatly my code cannot be given correct permissions to see the SQL agent jobs.
Any ideas?
Thanks
View 3 Replies
View Related
Apr 23, 2007
I need to connect to Express edition of sql server installed on my machine, from perl (solaris platform). How should the connection string containing server, port, database etc look like ??
View 5 Replies
View Related
Sep 14, 2007
Dear all,
How do i call an application, which is reside in another unix platform in my flow of execution.
I'll need to call this application after my data extraction is successfully run.
Thanks for the helps in advance.
Thanks & Best Regards,
PassionOrienter
View 3 Replies
View Related
Dec 4, 2007
While SQL Server installed into our clustered environment with no significant problems Service Pack 2 will not install with the Error "Unable to install Windows Installer MSP file" during the update to the Database Services.
Subsequently, Integration Services, Native Client and Backwards Compatibilty also fail to upgrade due to suspended installs.
Searching for this returns a number of articles none of which match what we are seeing, including:-
http://support.microsoft.com/kb/918357 indicates this is a problem with the Setup Support Files.
This is not the case and the Setup Support files are updated. Also the permissions are correct on the folder and files mentioned,
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=448685&SiteID=1 also point to a problem when installing the Setup Support Files. Our install gets past this but fails on the database engine then sets up a chain of suspended installs.
Other finds indicate there may be another msi running, again this is not the case and the server has been failed over and rebooted a number of times.
At the moment we are sitting at RTM having rebuilt the machine completely but would like to move forward onto SP2. Has anyone come across this and provide any further information or resolution?
We have successfully deployed SP2 onto a number of other servers cover both clustered and non clustered, 32 bit and X64 installations with no problems and now wondering if the problem is Itanium edition specific.
extract from the install log from the failed install. The logs mentioned in this log do not exist post install, in fact the Hotfix folder is not there.
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 IA64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 IA64 ENTERPRISE
Integration Services ENU RTM 9.00.1399.00 IA64 ENTERPRISE
SQL Server Native Client ENU 9.00.1399.06 IA64
Client Components ENU RTM 9.00.1399.06 IA64 ENTERPRISE
MSXML 6.0 Parser ENU 6.00.3883.8 IA64
SQLXML4 ENU 9.00.1399.06 IA64
Backward Compatibility ENU 8.05.1054 IA64
Microsoft SQL Server VSS Writer ENU 9.00.1399.06 IA64
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 1601
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 1601
Error Description : MSP Error: 1704 An installation for Microsoft SQL Server 2005 (64-bit) is currently suspended. You must undo the changes made by that installation to continue. Do you want to undo those changes?
View 1 Replies
View Related
Jul 23, 2005
I have a query of the kind brains of this group.Is it possible to access a microsoft sqlserver database (for select, insert,update, delete, and for miscellaneous administrative actions such as tableand index creation and deletion) remotely from a compiled C program (and/or,from Perl) running on a NON microsoft platform, such as Sun's Solaris and/orLinux?What toolset(s) could be used (on the UNIX/Linux end) for such a purpose?Would it require a corresponding special toolset to be installed on theWindows server end as well? (I'd prefer not to have to do that ifpossible.)If you are not now rolling on the floor laughing at the "heresy" of such anotion, thanks in advance.DanJoin Bytes! (replace 'glowing' with 'lucent')
View 1 Replies
View Related
Jul 20, 2005
Hi all,We're looking at a vendor who uses the InterSystems Cache DatabasePlatform, but our IT department has zero experience with this system.This software package will have a pivotal and mission critical roll inour organization, so I'd like some comments on what others think ofthis database platform.Mainly I'm curious how easy/difficult it is to query a Cache Database,and does it use standard SQL calls like Oracle and MS SQL? What aboutODBC connections into the database from Crystal, MS Access, and OLAPtools? Any other caviets (backup, maintenance, etc)?Thanks in advance for any suggestions or comments Cache.Sam
View 4 Replies
View Related
Jul 20, 2015
We have build configuration setup for each environment that we automatically deploy to (DEV, UA, PROD 1, PROD 2, etc.) Â We've recently come across a scenario where one environment will now be running a different version of SQL Server than the others.
Is it possible to tie the Target Platform version to a configuration. Such that one configuration could target 2012 while another targets 2014?
View 2 Replies
View Related
Nov 16, 2007
How is cross platform recognition triggered in the process?
View 2 Replies
View Related
Aug 3, 2006
Hi,
I have following problem:
My production problem enviornment is:
Windows Server 2003 Standard x64 edition with Service Pack 1
SQL Server 2005 with .Net Framework 2.0 for 64bit machines.
I have a .Net application that uses assemlies that use COM references, so I have my application compiled with target platform x86 so that it can use COM Interop and can run in WOW64. All of my assemblies are compiled for x86 target platform.
We are using the same set of assemblies on 32bit machines and SQL server 2005 with 2.0 framework for 32 bit machines.
Now, I have one of my assemblies target platform x86, being used in SQL server 2005 on 64 bit machines using CLR. The assembly gets installed fine, but when I call the function I get following error on 64 bit machines only. 32 bit machines do not have any problem:
Msg 10314, Level 16, State 11, Line 1
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65548. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:
System.IO.FileLoadException: Could not load file or assembly 'echalk.common, Version=7.0.0.0, Culture=neutral, PublicKeyToken=77f22df29f1a5e39' or one of its dependencies. The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)
System.IO.FileLoadException:
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
We are using the same exact steps but I get the above error in 64bit machines. I know if I had the asseblies compiled with AnyCPU, it works on both sql servers but then my application fails in 64 bit machines. If I compiled all my assemblies with x86 platform then application works but sql server functions stop working on 64 bit machines. Is there a work arount that I could use so that I don't have to create 2 sets of assemblies for application and sql server seperate.
Any help would be appreciated. Also thanks in advance.
View 4 Replies
View Related
