Accessing Java within SQL Server

have a Java Class that I want to be able to access from within a SQL Server Stored procedure. I know we can access C# and other .NET Framework code, but how can you access a Java Class?

How would you access a Java class from "normal" .NET code?

Niels

Access standard .NET Framework classes

Hello,
My reports access the class File, a builtin class in the .NET Framework,
to check whether a file exists on a network drive somewhere. I use the File.Exists
method if that's ny help.
What I saw initally was that File.Exists returned false in every instance,
even if the file I was checked existed. I raised the trust level in the ReportServer
by editing the rssrvpolicy.config and setting the FirstMatchCodeGroup to
FullTrust. This made the code work when I access the report server locally
using Remote Desktop, however if I access the ReportServer remotely using
the machine name in the browser the call the File.Exists fails even with
the modifications to rssrvpolicy.config in place.
Does anyone have any idea as to what makes it work locally but not remotely?
--
Med venlig hilsen,
Søren Lund
www.publicvoid.dkI should mention that this is Reporting Services for SQL Server 2000 SP2
running on a Windows Server 2003 machine.

access SQL2005 MOBILE database in a VS2003 mobile app

It is possible to access a Sql Server 2005 Mobile database in a VS2003 application (compact framework) ?

Thanks

Robson

Not via managed provider, no. You might be able to P/Invoke, but that’s not an easy task.

|||

Ilya, can you tell me more details about this possibility ?

I do not understand how...

My problem is that we are now creating the database with SQL Server 2005 Mobile in the desktop pc, due to the size of the data... but we have too much softwares running on pocket pc's that have been created with visual studio 2003 (compact framework 1.2).

Thanks

Robson

|||

I’m not quite sure about your scenario. Are you trying to make existing applications which are designed to use SQL CE 2.0 to work with SQL Mobile without recompilation? If so, that is not possible.

If you have access to the source code of VS 2003 applications created with NETCF V1 (there’s no NETCF 1.1 or 1.2), you can import these projects into VS 2005, upgrade projects to NETC V2 and recompile. That would switch applications to NETCF V2/SQL Mobile.