CLR Assembly in MS SQL 2008

35 pts.
Tags:
CLR
SQL
SQL Server 2008
VB.NET
I have a problem with COM-objects which i create in CLR-assembly in VB.NET via CreateObject. When I compile this assembly as console project and run loging under any account on server, it works ok. But when i run this file from MS SQL, it can not create object. What may be reason for this?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    It could be any number of things. Whats the error message you are getting?
    66,360 pointsBadges:
    report
  • dalex
    It just dont create Object without any messages. When i later trying to use object, I get standart .Net error - NullObjectReference.
    35 pointsBadges:
    report
  • Denny Cherry
    How are you trying to run the object? You can't run a CLR object directly from T/SQL. You have to import the assembly, then create SQL CLR procedures or functions to call the sub or function from the assembly.
    66,360 pointsBadges:
    report
  • dalex
    I tried in 2 methos: 1-creating assembly and 2-executable via xm_cmdshell Both of methods give me same error.
    35 pointsBadges:
    report
  • Denny Cherry
    And what would that error message be that it gives you?
    66,360 pointsBadges:
    report
  • dalex
    Activex object is not created. Guess it is related with NT service limitation
    35 pointsBadges:
    report
  • Denny Cherry
    Sounds like the account that the CLR assembly is running under doesn't have the needed rights to create the ActiveX object. Why increasing the accounts rights.
    66,360 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following