Compile a CLR as an EXE

[=?Utf-8?B?RGFuIFNoZXBoZXJk?=]

I am trying to compile a CLR function as an EXE. When I try to use the VBC
/target:exe command I get an error indicating that there is no sub-form. All
I have in the project is a SQL script that has an embedded cursor. The
cursor runs through some SQL tables and exports data in a format I want. I
want an executable so the end user can launch it without having access to
sql, etc.

Is this possible?

[Patrice]

If you mean a SQL Server CLR function it means, by definnition it runs
*inside* the SQL Server engine.

You could use ADO.NET to access a SQL Server on the network (wihtout SQL
Serer installed on the user machine).

Of course if the user doesn"t have "access to SQL" not even through a
network, he won't be able to run some code that takes data from SQL Server
(at least directly)...

You may want to elaborate a bit as what you are trying to do seems weird...

--
Patrice

"Dan Shepherd" <Da*********@discussions.microsoft.coma écrit dans le
message de groupe de discussion :
99**********************************@microsoft.com...

I am trying to compile a CLR function as an EXE. When I try to use the
VBC
/target:exe command I get an error indicating that there is no sub-form.
All
I have in the project is a SQL script that has an embedded cursor. The
cursor runs through some SQL tables and exports data in a format I want.
I
want an executable so the end user can launch it without having access to
sql, etc.

Is this possible?

[=?Utf-8?B?RGFuIFNoZXBoZXJk?=]

I created the CLR in VB but I am not a VB expert. I would prefer to just
keep the whole thing in SQL using triggers, etc... but I cannot. All I want
to do is call the CLR and have it execute. Could I also do this by compiling
the CLR as a .dll and referencing it in another app? The other app would
need to open, run, and close without user intervention.

"Patrice" wrote:

If you mean a SQL Server CLR function it means, by definnition it runs
*inside* the SQL Server engine.

You could use ADO.NET to access a SQL Server on the network (wihtout SQL
Serer installed on the user machine).

Of course if the user doesn"t have "access to SQL" not even through a
network, he won't be able to run some code that takes data from SQL Server
(at least directly)...

You may want to elaborate a bit as what you are trying to do seems weird...

--
Patrice

"Dan Shepherd" <Da*********@discussions.microsoft.coma crit dans le
message de groupe de discussion :
99**********************************@microsoft.com...

I am trying to compile a CLR function as an EXE. When I try to use the
VBC
/target:exe command I get an error indicating that there is no sub-form.
All
I have in the project is a SQL script that has an embedded cursor. The
cursor runs through some SQL tables and exports data in a format I want.
I
want an executable so the end user can launch it without having access to
sql, etc.

Is this possible?

[Kevin Provance]

Where is McWilly? Oh, I know...answering this question IN THE WRONG
GROUP!!!!

VB 6 Lives!!
"Dan Shepherd" <Da*********@discussions.microsoft.comwrote in message
news:99**********************************@microsof t.com...
|I am trying to compile a CLR function as an EXE. When I try to use the VBC
| /target:exe command I get an error indicating that there is no sub-form.
All
| I have in the project is a SQL script that has an embedded cursor. The
| cursor runs through some SQL tables and exports data in a format I want.
I
| want an executable so the end user can launch it without having access to
| sql, etc.
|
| Is this possible?

[Patrice]

Still unclear. If this is a SQL Server CLR Function you just call it from
within SQL Server as this is some code that runs server side inside SQL
Server the same way as if it was a native SQL Server function...

Try :
http://msdn.microsoft.com/en-us/library/ms189876.aspx

So your other app would just send some SQL Statement to the server that
would in turn call your CLR function...

--
Patrice
"Dan Shepherd" <Da*********@discussions.microsoft.coma écrit dans le
message de groupe de discussion :
1A**********************************@microsoft.com...

I created the CLR in VB but I am not a VB expert. I would prefer to just
keep the whole thing in SQL using triggers, etc... but I cannot. All I
want
to do is call the CLR and have it execute. Could I also do this by
compiling
the CLR as a .dll and referencing it in another app? The other app would
need to open, run, and close without user intervention.

"Patrice" wrote:

>If you mean a SQL Server CLR function it means, by definnition it runs
*inside* the SQL Server engine.

You could use ADO.NET to access a SQL Server on the network (wihtout SQL
Serer installed on the user machine).

Of course if the user doesn"t have "access to SQL" not even through a
network, he won't be able to run some code that takes data from SQL
Server
(at least directly)...

You may want to elaborate a bit as what you are trying to do seems
weird...

--
Patrice

"Dan Shepherd" <Da*********@discussions.microsoft.coma crit dans le
message de groupe de discussion :
99**********************************@microsoft.com...

I am trying to compile a CLR function as an EXE. When I try to use the
VBC
/target:exe command I get an error indicating that there is no
sub-form.
All
I have in the project is a SQL script that has an embedded cursor. The
cursor runs through some SQL tables and exports data in a format I
want.
I
want an executable so the end user can launch it without having access
to
sql, etc.

Is this possible?