Call Vb.Net Developed Dll In SQL Server 2005 With Configuration Level 80 Then Gets Error Invalid Class String

Jul 14, 2006

Hi,
I want to call a dll from Stored procedure developed in SQL Server 2005 at configuration level 80. but when I execute the stored procedure I get the following error.

Error Source: ODSOLE Extended Procedure
Description: Invalid class string

Code of stored procedure and vb.net class is given below:

VB.Net
Imports System
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server
Imports Microsoft.VisualBasic
Imports System.Diagnostics

Public Class PositivePay

Public Shared Sub LogToTextFile(ByVal LogName As String, ByVal newMessage As String)
' impersonate the calling user
Dim newContext As System.Security.Principal.WindowsImpersonationContext
newContext = SqlContext.WindowsIdentity.Impersonate()
Try
Dim w As StreamWriter = File.AppendText(LogName)
LogIt(newMessage, w)
w.Close()
Catch Ex As Exception

Finally
newContext.Undo()
End Try
End Sub
End Class
===============================================================

STORED PROCEDURE
Create PROCEDURE [dbo].[PPGenerateFile]
AS

BEGIN
Declare @retVal INT
Declare @comHandler INT
declare @errorSource nvarchar(500)
declare @errorDescription nvarchar(500)
declare @retString nvarchar(100)

-- Intialize the COM component
EXEC @retVal = sp_OACreate 'PositivePay.class', @comHandler OUTPUT
IF(@retVal <> 0)
BEGIN
--Trap errors if any
EXEC sp_OAGetErrorInfo @comHandler,@errorSource OUTPUT, @errorDescription OUTPUT
SELECT [error source] = @errorsource, [Description] = @errordescription
Return
END

-- Call a method into the component
EXEC @retVal = sp_OAMethod @comHandler,'LogToTextFile',@retString OUTPUT, @LogName = 'D: ext.txt',@newMessage='Hello'
IF (@retVal <>0 )
BEGIN
EXEC sp_OAGetErrorInfo @comHandler,@errorSource OUTPUT, @errorDescription OUTPUT
SELECT [error source] = @errorsource, [Description] = @errordescription
Return
END
select @retString

END

View 6 Replies


ADVERTISEMENT

DTS Error- Invalid Class String

Aug 21, 2000

I'm running a DTS package from VB, it works great on my development machine. When I distribute the app to a clean client, I get a DTS error:

DTSStep_DTSDataPumpTask_1
Invalid Clss string
-2147221005
sqldts.hlp 700

I'm obviously connecting and executing the package correct, but I can't track down this error. The installation includes dtspkg.dll, dtspkg.rll, dtspump.dll, dtspump.rll, which are all registered. The username and password are hard code set in the package object before I execute it, so security should be the same.

Any suggestions on how to solve or track down this problem?

View 2 Replies View Related

Error : Invalid Class String

Aug 17, 2007

When trying to migrate a DTS package to SSIS Package ,
it gives error :

Erro : Invalid Class String

Please suggest .
Thanks in advance !!

View 3 Replies View Related

Ms Design Tools Invalid Class String - Error

Feb 27, 2008

ms design tools invalid class string - error


i use windows XP WITH SP-2 , SQL SERVER 2000 WITH SERVICE PACK 4, VISUAL STUDIO 6 WITH SP5, .NET 2.0,
VS2005.

I AM CURRENTLY GETTING THE ERROR WHEN I USE ENTERPRISE MANAGER IN SQL SERVER 2000.
WHEN I SELECT A PARTICULAR DATABASE AND A TABLE, AND WHEN I SELECT THE DATABASE DIAGRAM AND TRY TO CREATE A NEW DATABASE DIAGRAM, I GET THE ABOVE ERROR

View 5 Replies View Related

[MS Visual Database Tools] - Invalid Class String. Error

Aug 1, 2005

We recently upgraded our SQL Server 2000 to SP4 and are now getting the following error whenever we try to open up Site Diagrams.

An unexpected error happened during this operation. [MS Visual Database Tools] - Invalid class string.

This is very frustrating since I can't easily edit my database relationships or see my ER diagram.

Any ideas how to fix this?

Thanks

View 3 Replies View Related

Invalid Class String

Jun 8, 2007

Hi,
I'm working on both VWDEE and VBEE and, in each, when I try to add a database diagram I get the following message (after the 'Do you want to create required objects' prompt) 'Invalid Class String'.
Any ideas?

View 2 Replies View Related

Invalid Class String In Enterprise Manager

Oct 11, 2006

Hi, Sorry to be cross-posting, but I'm not getting much response to this...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=807314&SiteID=1

...which I don't even think is in the right forum anyway. can anyone help?

Basically, I get a error box saying "Invalid class string" in Enterprise Manager whenever I try to run a query.

View 5 Replies View Related

Invalid Class String, Management Express

Apr 4, 2008

I'm having a problem creating a Database diagram in SQL Server Management Express.

After Asking me to install the tools needed to create the diagram (and I say yes), when i try to create the diagram it throws up an error message:

"Invalid class string"

(MS Visual Database tools)

-----------------------------
Program Location:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

---------

Microsoft SQL Server Management Studio Express 9.00.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001



I have tried uninstalling/reinstalling various components, and then all visual studio express components. Going back to a restore point and re-installing everything. No joy, I keep getting the same error message. I am using Vista HP, SP1.

Any Ideas?

View 4 Replies View Related

Invalid Procedure Call... Error With SQL Server 7

Feb 5, 1999

I'm having trouble with the following code. I get a "Invalid procedure call or argument" error in response to OpenResultset. The same command works in MSQuery and when ADO is used. Does anyone have any insight?

We're using VB5.0 SP2 and SQL Server 7 Beta 3.

Option Explicit

Sub Main()
Dim objC As RDO.rdoConnection
Dim objColsRS As RDO.rdoResultset
Dim objQ As rdoQuery

Set objC = New RDO.rdoConnection
With objC
.Connect = "Driver={SQL Server};Server=KENBNT;UID=SYSADM;PWD=SYSADM;DATABA SE=QT;"
.EstablishConnection
Set objQ = objC.CreateQuery("", "select name from syscolumns")
Set objColsRS = objQ.OpenResultset
End With
Set objColsRS = Nothing
Set objQ = Nothing
Set objC = Nothing
End Sub

View 2 Replies View Related

A Transport-level Error Has Occurred When Receiving Results From The Server.(provider:TCP Provider,error:0-The Handle Is Invalid

Jan 24, 2007

Hi,



I am using SQL Server 2005,



while trying to retrieve data from the database; I am getting the following
error:



A transport-level error has occurred when receiving results
from the server. (Provider: TCP Provider, error: 0 - The handle is invalid.)



But I am getting this error randomly.







Can some one help me out?
Waiting for your response



Sudhakar

View 7 Replies View Related

Cdosysmail Error: SendUsing Configuration Value Is Invalid

Feb 27, 2007


RE: SQL Server 2000 €“ Enterprise Edition €“ SP4

I have an application that is utilizing cdosysmail to send email from SPs and DTS packages. It was working fine until the end of January but now they are no longer receiving the emails. Of course the logical question is what has changed. But, I am new here and cannot answer that.

Cdosysmail is working fine on other servers and I cannot find any differences between them and this server.

I have manually called sp_send_cdosysmail from query analyzer but am receiving the following error:

-----------
-2147220960

(1 row(s) affected)

Source: CDO.Message.1
Description: The "SendUsing" configuration value is invalid.


I searched the cdosysmail proc and the only command that related to the "SendUsing" property is the same on all my servers with the value of 2:

EXEC @hr = sp_OASetProperty @iMsg, Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendusing").Value','2'


Does anyone have any experience with this error?

Thanks for your help.

View 1 Replies View Related

Sqlhelper Class Failed To Convert Sql Parameter To A String Error

Oct 17, 2007

I'm getting this error and I'm not really sure what is wrong.  I'm using the sqlhelper class which was writen by microsoft, so I figure the code is right.
 Here is code of me passing in the strings.  Yes I tried puttinga .ToString() on the end of the sqlparameters.
public class LoginSelectData : DataAccessBase{private EndUser _enduser;public LoginSelectData(){    StoredProcedureName = StoredProcedure.Name.VERIFYUSER.ToString();}public DataSet Get(){DataSet ds;LoginSelectDataParameters _loginselectedataParameters = new LoginSelectDataParameters(this.Enduser);DataBaseHelper dbhelper = new DataBaseHelper(StoredProcedureName);ds = dbhelper.Run(base.ConnectionString, _loginselectedataParameters.Parameters);return ds;
}public EndUser Enduser{get { return _enduser; }set { _enduser = value; }}
}
public class LoginSelectDataParameters{private EndUser _enduser;private SqlParameter[] _parameters;public LoginSelectDataParameters(EndUser userinfo){this.Enduser = userinfo;
Build();
}
 private void Build(){
SqlParameter[] parameters = {new SqlParameter("@username",this.Enduser.Username),new SqlParameter("@password",this.Enduser.Password)
};
Parameters = parameters;}public SqlParameter[] Parameters{get { return _parameters; set { _parameters = value; }
}public EndUser Enduser{get { return _enduser; }set { _enduser = value; }}
}

View 4 Replies View Related

Invalid Object Name Error In Database Setup Step Of Configuration Manager

Dec 1, 2005

Hi--

View 11 Replies View Related

Database Developed By SQL Server 2005 Express Edition Can Not Be Deployed In IIS?

Feb 17, 2007

I developed a site using Visual Web Developer 2005 and the database used is SQL Server 2005 Express edition.Everything works fine.  However, when I move the site to my IIS server, it says that my database is read-only.Is it because my SQL Server is an express edition? 

View 5 Replies View Related

Reporting Services Configuration And Database Setup Error Invalid Object Name 'sysdatabases'

Sep 14, 2007



Yesterday, literally I was banging my head to the wall, kept getting this error:

A Connection could not be established with the information provided. Hit OK to change your connection settings.
Invalid object name 'sysdatabases'.

I uninstall and re-install back the reporting services couple times and I kept getting the same error.
I have 2 instances of SQL Server on the same Server:


SQL Server 2000

SQL Server 2005
The 2 instances work side by side, I was wondering if this causing the error.

Can anyone help out with this problem?

Thanks - John

View 9 Replies View Related

Problem Deploying Site Developed With Sql Ex. To Server Running Sql Server 2005.

Apr 10, 2006

Can someone show me, or direct me, to a source,  that shows me how, and what to change,  when deploying a website from a development server running Sql Ex to a production server running Sql server 2005.  I can’t get the sites to run under Sql server 2005.
 
They work in Sql Ex. what must I change?  The connection string, to what format?  and what else?  I attached the dB to Sql 2005 and browsed the content in the Sql manager.  But can’t get the aspx pages to work on the server.
 
Help please

View 6 Replies View Related

Package Developed On SQL Server 2005 SP1 Not Opening In SQL Server 2005 SP2

Oct 19, 2007



Recently I have upgraded my system to SQL Server 2005 SP2 version 9.00.3054; I have developed my packages on SQL Server 2005 SP1 version 9.00.2047. I am unable to open all these packages on SQL Serever SP2 version 9.00.3054 it is giving me error.



Error: Error loading Package.dtsx cannot create an instance of the XML Document Object Model. MSXML may not be registered.



Can any body help me in this?





Thanks in advance

View 4 Replies View Related

ASP.Net Application Developed Using SQL Server 2000 Can't Use SQL Server 2005

Jun 2, 2008

Hi,If an application written in ASP.Net that uses SQL Server 2000 can have certain features that will not work on SQL Server 2005?There is an application written in ASP.Net with SQL Server 2000 which I need to convert to SQL Server 2005 but the original developer says it uses certain SQL Server 2000 specific features and won't work directly on SQL Server 2005 without modifying code. Are there any such features? Thanks 

View 4 Replies View Related

How To Call A C#.net Class From Stored Procedure

Apr 19, 2006

Hi,

I would like to know how can I call a c#.net class from a stored procedure.

I have a class file which will generate a pdf file from sql reporting services and mail that file. Now I want to call this class from a stored procedure. Is it possible, if so please send me the sample code.

Thanks in advance

Regards

Babu

View 4 Replies View Related

DTS = Error String: Invalid OLEVERB Structure

May 13, 2008

Hi all

Error string: Invalid OLEVERB structure

Error source: Microsoft Data Transformation Services (DTS) Package

Help file: sqldts80.hlp

Help context: 1100

Error Detail Records:

Error: -2147221504 (80040000); Provider Error: 0 (0)

Error string: Invalid OLEVERB structure

Error source: Microsoft Data Transformation Services (DTS) Package

Help file: sqldts80.hlp

Help context: 1100

Error: -2147221504 (80040000); Provider Error: 0 (0)

Error string: Invalid OLEVERB structure

Error source: Microsoft Data Transformation Services (DTS) Package

Help file: sqldts80.hlp

Help context: 5700

Error: -2147467259 (80004005); Provider Error: 0 (0)

Error string: [SQL-DMO]CreateFile error on '<xxxxxxxxx.yyyyyyyyy>'.

Error source: Microsoft SQL-DMO

Help file: SQLDMO80.hlp

Help context: 1131

DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1

DTSRun: Package execution complete.


Any body experianced same problem.

your help is Appreciated.

View 3 Replies View Related

10080 Sql Server 2005 Configuration Caused Error?

Jan 30, 2007

Hi.I have an ancient preCambrian app that uses the db library to interface withsql server databases.It is written in c++.When testing it I noticed on one machine with sql server 2005 installed itruns fine, but on another it has some problems, notably.. it gets as a resultof a select statement with an order by clause the error:only fully keyset ddriven cursors can have 'order by', 'group by', or 'having'phrases.Error code 10080Can someone suggest a 'configuration' parameter that might be causing theotherwise identical systems to have this problem on one machine and not theother?ThanksJeffthanksJeffJeff Kish

View 1 Replies View Related

A Transport-level Error Has Occurred When Receiving Results From The Server. - After Installing New Instance Of SQL Server 2005 W/NO App Changes

Sep 27, 2006

We've devoted a resource to this today, but I have to believe it's something easy that we're overlooking.  The scneario is that we have a production Web application that until last weekend had a SQL 2000 back end.  This weekend we installed a new instance of SQL 2005 and everything works (we tested in a sandbox environment, but someone must not have load tested enough) and never saw these exceptions.   So, after the upgrade we now receive 100's of thexe SQL excptions per day:A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)Does anyone know what we've overlooked that's causing this issue?Thanks for any help! 

View 2 Replies View Related

Pre-requisiste Install Error 87 Invalid Parameter From SQL 2005 Dev Ed On Server 2008 RC0

Oct 2, 2007

The subject pretty much sums the problem up. I am trying to get a database installed on Server 2008 RC0. The public information says SQL 2005 SP2 should work, but I cannot get the base SQL 2005 installed in order to apply the service pack. When I run the installation, I immediately get an error when trying to install the pre-requisites. Specifically, the .NET 2.0 Framework errors with code 87, "invalid parameter".

I have found a couple references to this error code, but nothing to do with Server 2008 and RC0. I have tried using a directory with no spaces, and tried the EXE vs ISO installation, but they everything fails. I don't know if there is a way to bypass the .NET 2.0 Framework install - since it's already on the machine anyway.

Thanks in advance for any help!

View 8 Replies View Related

Transferring MS Access Tables To SQL Server 2005: PRODUCT LEVEL TOO LOW Error

Jun 27, 2007

Hi,



I am using MS Access 2003 SP2 to maintain some data tables. I use SSIS to transfer them to SQL Server 2005, Enterprise Edition.



When I run the SSIS package from within Visual Studio 2005, the package runs without error.



When I try to run the same SSIS package by double-clicking on it in my File System (which invokes the Execute Package Utility, Version: 1.0) none of the tables get copied. Instead all I receive is a message for each table,



Error: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Data Conversion 1" (49).



The only data conversion I perform is double-byte characters to single-byte characters.



Bob Bojanic, MSFT, made a few suggestions about this in another thread -- but I have created this new thread to help focus on this specific issue. In particular, he asked if we have installed the complete SSIS support for SQL Server 2005, Enterprise Edition, and my network support and database support staff assure me that such complete SSIS support was installed.



Are others having this problem?



Dan



(I just took a look at some of the transformations in the Data Conversion task, and many of them are using an Output Alias identical to the Input Column name. Might that be causing the problem? I will try changing the Output Alias for some tables and see if they then transfer correctly. The "identical name" Output Alias values were created by the Migration Wizard for a DTS 2000 package.)

View 10 Replies View Related

FTP Using DTS. Error Invalid Format For String Source Names

Mar 31, 2004

Hi,
I am trying to do a simple ftp using DTS. I am using a Dynamic properties task as the file name is a bit complicated eg - f2368fd1.ext.040330.2
where 040330 is according to the date and the .2 is the second file for the day.
When i run the task, it fails giving me the error "Invalid format for string source names"

I then tried to use a simple file name such as TD.txt as a constant in the Dynamic properties task but still it fails. Any ideas ??

Thanks in Advance

View 2 Replies View Related

Error Msg 6522, Level 16, State 1 Receives When Call The Assembly From Store Procedure To Create A Text File And To Write Text

Jun 21, 2006

Hi,
I want to create a text file and write to text it by calling its assembly from Stored Procedure. Full Detail is given below

I write a code in class to create a text file and write text in it.
1) I creat a class in Visual Basic.Net 2005, whose code is given below:
Imports System
Imports System.IO
Imports Microsoft.VisualBasic
Imports System.Diagnostics
Public Class WLog
Public Shared Sub LogToTextFile(ByVal LogName As String, ByVal newMessage As String)
Dim w As StreamWriter = File.AppendText(LogName)
LogIt(newMessage, w)
w.Close()
End Sub
Public Shared Sub LogIt(ByVal logMessage As String, ByVal wr As StreamWriter)
wr.Write(ControlChars.CrLf & "Log Entry:")
wr.WriteLine("(0) {1}", DateTime.Now.ToLongTimeString(), DateTime.Now.ToLongDateString())
wr.WriteLine(" :")
wr.WriteLine(" :{0}", logMessage)
wr.WriteLine("---------------------------")
wr.Flush()
End Sub
Public Shared Sub LotToEventLog(ByVal errorMessage As String)
Dim log As System.Diagnostics.EventLog = New System.Diagnostics.EventLog
log.Source = "My Application"
log.WriteEntry(errorMessage)
End Sub
End Class

2) Make & register its assembly, in SQL Server 2005.
3)Create Stored Procedure as given below:

CREATE PROCEDURE dbo.SP_LogTextFile
(
@LogName nvarchar(255), @NewMessage nvarchar(255)
)
AS EXTERNAL NAME
[asmLog].[WriteLog.WLog].[LogToTextFile]

4) When i execute this stored procedure as
Execute SP_LogTextFile 'C:Test.txt','Message1'

5) Then i got the following error
Msg 6522, Level 16, State 1, Procedure SP_LogTextFile, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'SP_LogTextFile':
System.UnauthorizedAccessException: Access to the path 'C:Test.txt' is denied.
System.UnauthorizedAccessException:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, ileOptions options)
at System.IO.StreamWriter.CreateFile(String path, Boolean append)
at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize)
at System.IO.StreamWriter..ctor(String path, Boolean append)
at System.IO.File.AppendText(String path)
at WriteLog.WLog.LogToTextFile(String LogName, String newMessage)

View 13 Replies View Related

Invalid Column Name 'rowguid'. Error When Generating Snapshot For Merge Replication SQL Server 2005

May 15, 2007

Hi there,



I have setup merge replication which successfully synchronizes with a group of desktop users using SQL Compact Edition.



However now I have setup Article Filters and when I attempt to regenerate the snapshot I get the following error:



Invalid column name 'rowguid'.

Failed to generate merge replication stored procedures for article 'AssignedCriteria'.



When I look at publication properties at the Articles page.. All my tables have the rowguid uniqueidentifier successfully added to tables and selected as a compulsory published column, apart from the table above "AssignedCriteria".. Even when I attempt to select this column in the article properties page and press ok, when I come back it is deselected again. ( The Rowguid column is however physically added to the table)



I have scripted the publication SQL and then totally reinstalled from scratch, including the database but for some reason it doesn't like this table. I remove the article filters, but still this "rowguid" is never "selected" in article properties.



We are using Uniqueidentifiers in other columns as well for historical reasons, but this doesn't appear to be a problem in other tables..



DDL For this problematic table is as follows



CREATE TABLE [dbo].[AssignedCriteria](

[AssignedCriteria] [uniqueidentifier] NOT NULL,

[CriteriaName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[TargetScore] [numeric](5, 0) NULL,

[HRPlan] [uniqueidentifier] NULL,

[ActualScore] [numeric](18, 0) NULL,

[Criteria] [uniqueidentifier] NULL,

[Employee] [uniqueidentifier] NULL,

[IsActive] [bit] NULL,

[addDate] [datetime] NULL,

[totalscore] [numeric](5, 0) NULL,

[isCalc] [bit] NULL,

[Weight] [decimal](18, 2) NULL,

[ProfileDetail] [uniqueidentifier] NULL,

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [MSmerge_df_rowguid_7FF25DF903B6415FBFF24AC954BC88E4] DEFAULT (newsequentialid()),

CONSTRAINT [PK_AssignedCriteria] PRIMARY KEY CLUSTERED

(

[AssignedCriteria] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



Thanks.



View 5 Replies View Related

Error During First Configuration After Installing Reporting Services (SQL Server 2005 Express)

Jan 27, 2008

Hi,

I have problem during first configuration of Reporting Services from MS SQL 2005 Server Express with Advanced Services SP2. The error occurs when configuring virtual directory (Reporting Services Configuration Manager -> Report Server Virtual Directory). When I try to create new virtual directory I can see following messages:

Number of errors: 0
Create Virtual Directory

The virtual directory was created and assigned.
Changing Secure Connection Level


After last message Windows reports that SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close (and I can send report to Microsoft).

IIS shows that virtual directory under default web site was created.

Evenet viewer (application log) shows .NET Framework 2.0 error:
EventType clr20r3, P1 rsconfigtool.exe, P2 9.0.3042.0, P3 45cd6ee2, P4 rsconfigtool, P5 9.0.242.0, P6 45cd6ee2, P7 15a, P8 5, P9 system.nullreferenceexception, P10 NIL


My environment:
MS SQL Reporting Services Version 9.00.3042.00
Windows XP Proffessional SP2
IIS 5.1
all components are fresh new installations. The only additional configuration I've made was adding IWAM_<hostname> as WebServiceAccount, all other configuration is default.

Any help would be appreciated.

Best regards
Slawomir Nasiadka


View 2 Replies View Related

Aspose License .Lic File Error Invalid Character In A Base-64 String

Jul 12, 2007



Hi,

I am using ASPOSE License(3rd party licensing tool).

Getting Error when using encrypted License file (*.lic) in my Application .

Error is .



"Invalid character in a Base-64 string "



What does it means ?????



But Demo License file *.lic is working fine.



Please provide solutions.



Reply is highly appreciated.



Rishi



Error is
Invalid character in a Base-64 string.

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.FormatException: Invalid character in a Base-64 string.

Source Error:





Line 59:
Line 60: //license = new Licensing("Ghezt4vbwif7r9cf7ra2ttbKzv76+v7GAA==", licenceFile);
Line 61: license = new Licensing("Ghezt4vbwif7r9cf7ra2ttbKzv76+v==", licenceFile);
Line 62:
Line 63:
Source File: c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseApp_CodeDemo.cs Line: 61

Stack Trace:





[FormatException: Invalid character in a Base-64 string.]
System.Convert.FromBase64String(String s) +0
Aspose.License.Licensing.M0(String key, String encryptedString) +627
Aspose.License.Licensing.A0() +753
Aspose.License.Licensing..ctor(String key, String licenseFile) +72
Demo.Initialize() in c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseApp_CodeDemo.cs:61
Demo..ctor(String licenseFolder, Page page) in c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseApp_CodeDemo.cs:37
_Default.Page_Load(Object sender, EventArgs e) in c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseDefault.aspx.cs:18
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +31
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +68
System.Web.UI.Control.OnLoad(EventArgs e) +88
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3035


View 1 Replies View Related

SQL 2005 Express Setup Issue (The SQL Server System Configuration Checker Cannot Be Executed Due To WMI Configuration )

Sep 22, 2007

I am getting following error when trying to install SQL express 2005 on XPSP2.


TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SIGMA-805539A79 Error:2147944122 (0x800706ba).

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342


I tied re-installing WMI using http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx link but could not get it working.


Do i need IIS installed? Its not installed on this box...

please suggest something... i am stuck...

Thanks,

View 3 Replies View Related

Error Invalid Use Of Side-effecting Or Time-dependent Operator In 'EXECUTE STRING' Within A Function

May 8, 2008



Hi all, mister
I want create a function but I get this error: Error Invalid use of side-effecting or time-dependent operator in 'EXECUTE STRING' within a function

I think in a function, cannot use temp tables, or calling exec or store procedures.

Which is the best solution for my issue ? develop store procedure ??

thanks.

CREATE FUNCTION fnObtenerTablaMaestra ()

RETURNS @T Table ( Descripcion VARCHAR(20) NOT NULL, CIF VARCHAR(8) NULL )

AS

BEGIN

DECLARE @cmd nvarchar(max)

DECLARE @sql nvarchar(max)

DECLARE @nexoUNION NVARCHAR(max)

DECLARE @params nvarchar(max)

DECLARE @NombreTabla VARCHAR(MAX)

DECLARE @Descripcion VARCHAR(MAX)

DECLARE @CIF VARCHAR(MAX)

-- Cannot access temporary tables from within a function.

-- IF EXISTS (SELECT TABLE_NAME FROM tempdb.INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '#tmpTable%')

-- DROP TABLE #tmpTable

-- CREATE TABLE #tmpTable ( Descripcion VARCHAR(20) NOT NULL, CIF VARCHAR(8) NULL )



SET @nexoUNION = NULL



DECLARE c1 CURSOR for

SELECT [CD_NOMBRE_TABLA], [DS_CAMPO_DESCRIPCION], [DS_CAMPO_CIF] FROM [TABLA_MAESTRA]



OPEN c1

FETCH c1 INTO @NombreTabla, @Descripcion, @CIF

--FETCH NEXT FROM c1 INTO @NombreTabla, @Descripcion, @CIF

WHILE @@FETCH_STATUS >= 0

--WHILE @@FETCH_STATUS = 0

BEGIN

SELECT @sql =

'INSERT INTO #tmpTable

N'''+ @NombreTabla + '''

N'''+ @Descripcion + '''

N'''+ @CIF + ''''



SELECT @sql =

'SELECT ' + @Descripcion + ', '+ @CIF + ' FROM ' + @NombreTabla

IF @nexoUNION IS NULL

BEGIN

SET @nexoUNION = 'UNION'

END

ELSE

SET @sql = @nexoUNION + ' ' + @sql



-- EXECUTE (@sql)

--Exec(@sql)

FETCH c1 INTO @NombreTabla, @Descripcion, @CIF

--FETCH NEXT FROM c1 INTO @NombreTabla, @Descripcion, @CIF



END

CLOSE c1

DEALLOCATE c1

--SET @sql = 'SELECT Descripcion, CIF FROM #tmpTable'

-- Error Invalid use of side-effecting or time-dependent operator in 'EXECUTE STRING' within a function

EXECUTE(@sql)

RETURN

END

GO

View 1 Replies View Related

Developed In 2005, Need To Go Back To 2000

May 19, 2007

I've developed a web application and to be honest I've been a bit dumb and not checked with my hosts. I assumed they used SQL Server 2005. But no, they only use 2000.

I'm sure I'll come across more problems but the first I'm having is I've used the ROW_NUMBER() function in a few stored procedures, but in 2000 I'm getting this error message

'ROW_NUMBER' is not a recognized function name.

Here is the stored procedure for reference

SELECT RowNum
FROM
(
SELECT id, category, ROW_NUMBER() OVER(ORDER BY id) as RowNum FROM custrecords
)
as CustRecord

View 7 Replies View Related

Connect User Developed Interface Using WVD To DB SQLEE 2005

Oct 13, 2006

Dear Friends

I am a bigginer. I need to save input from textBox (User interface that I have made using VWD) to a database in SQLSEE 2005 using C#. please help me. I now how to connect to DB using Visual Items like gride view and form view. but i want to conect to DB using my developed UI lke in below. any help greatly appreciated

Name input area

address input area



Thanks

Amila

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved