Monday, March 19, 2012
cannot write to column in updatable RecordSet
[Microsoft][SQLServer 2000 Driver for JDBC]Can not update, the specified column is not writable.
when I attempt to call updateString() on a RecordSet column. I have set the Statement object on which I execute the query to obtain the RecordSet to be scrollable and updatable.
My goal is to replace the ID value contained in a particular column of each row with a longer text string that includes the ID value. If I can't alter the column values via the RecordSet, can I write SQL as part of the query to generate the text string?
Thank you.
RajCan You write a little example: what You have and what You want...
And your table's structure... if it is possible. and sqlsrv version.|||Hi. We run SQL Server 2000. I call the code that creates the Statement, executes the ResultSet, and outputs the results in separate methods, so here I include a summary of the code.
Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_I NSENSITIVE, ResultSet.CONCUR_UPDATABLE);
...
rs = statement.executeQuery(queryString);
...
WriteEditSCRLinks(rs);
Here's the definition of WriteEditSCRLinks().
//Replaces each SCR ID with a hyperlink that opens the edit SCR page on the ID.
//Method needs to input an updatable, scrollable RecordSet.
void WriteEditSCRLinks(ResultSet rs) throws SQLException
{
String FieldName = "SCRID";
while (rs.next())
{
String IDValue = rs.getString(FieldName);
String UpdateString = "<A HREF=\"" + SiteConfigHelper.getEditSoftwareChangeRequestURL() + "?" + FieldName + "=" + IDValue + "\">" + IDValue + "</A>";
rs.updateString(FieldName, UpdateString);
}
//Need to move the cursor to the position before the first row
//so as not to break GraphingHelper methods.
rs.beforeFirst();
}
Since someone told me that the JDBC object model does not intend for me to alter the ResultSet if I shall not alter the database, I have to solve this problem in a different way anyway. However, I would appreciate knowing whether the concept of updating the ResultSet differs from the concept of writing to a column.
Thank you.
Raj
Friday, February 24, 2012
Cannot show the editor for this task. Specified cast is not valid
This error is pretty persistent. I re-installed VS 2005 and SQL Server 2005 but did not help. Every time I try to open a Script Task editor it gives me the same error regardless of the project or package. DO I NEED TO REBUILD MY SYSTEM ?
===================================
Cannot show the editor for this task. (Microsoft Visual Studio)
===================================
Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)
Program Location:
at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()
at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskMainWnd.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)
-
Any help is appreciated.
Gulden
.......
have you tried re-installing ssis?|||I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.
|||Last couple of days I have been re-installing VS 2005 and SQL Server 2005 from scratch. This is related to a system or temp file which was created by SSIS which does not go away when these apps uninstalled.
Would anybody know if I should go ahead and rebuild my system or are there any specific files or registry items involved that I should search for?
|||
When editing scripts, VB for applications flashes for a split second and goes away. When I am running the packages on the Debug mode, I get "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for inconvenience" right away. And does not iterate through any script after that. I wonder if I have too many script tasks in the package (about 90)
Something has seriously been corrupted concerning the Script editing that no installation can fix. It is so unexplainable to me.
Any advice ?
|||Mistery solved!
Apparently they pushed a Macromedia package to hundreds of people's computers in my workplace re-registering at least 20 dlls including vbscript.dll.
|||I am still experiencing this problem and none of the suggestions seem to work. Any help would be appreciated.|||Did you get this problem resolved?I have the same problem on a production package that I need to run once a week. Any help is appreciated.
Pade|||
I face the same error. It was working fine - until suddenly i started getting this message "Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)"
and it doesn't go away neither the script editor opens.
Anyone who has solved this issue ?
Thanks
Sunday, February 19, 2012
Cannot show the editor for this task. Specified cast is not valid
This error is pretty persistent. I re-installed VS 2005 and SQL Server 2005 but did not help. Every time I try to open a Script Task editor it gives me the same error regardless of the project or package. DO I NEED TO REBUILD MY SYSTEM ?
===================================
Cannot show the editor for this task. (Microsoft Visual Studio)
===================================
Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)
Program Location:
at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()
at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskMainWnd.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)
-
Any help is appreciated.
Gulden
.......
have you tried re-installing ssis?|||I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.
|||Last couple of days I have been re-installing VS 2005 and SQL Server 2005 from scratch. This is related to a system or temp file which was created by SSIS which does not go away when these apps uninstalled.
Would anybody know if I should go ahead and rebuild my system or are there any specific files or registry items involved that I should search for?
|||
When editing scripts, VB for applications flashes for a split second and goes away. When I am running the packages on the Debug mode, I get "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for inconvenience" right away. And does not iterate through any script after that. I wonder if I have too many script tasks in the package (about 90)
Something has seriously been corrupted concerning the Script editing that no installation can fix. It is so unexplainable to me.
Any advice ?
|||Mistery solved!
Apparently they pushed a Macromedia package to hundreds of people's computers in my workplace re-registering at least 20 dlls including vbscript.dll.
|||I am still experiencing this problem and none of the suggestions seem to work. Any help would be appreciated.|||Did you get this problem resolved?I have the same problem on a production package that I need to run once a week. Any help is appreciated.
Pade|||
I face the same error. It was working fine - until suddenly i started getting this message "Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)"
and it doesn't go away neither the script editor opens.
Anyone who has solved this issue ?
Thanks
Cannot show the editor for this task. Specified cast is not valid
This error is pretty persistent. I re-installed VS 2005 and SQL Server 2005 but did not help. Every time I try to open a Script Task editor it gives me the same error regardless of the project or package. DO I NEED TO REBUILD MY SYSTEM ?
===================================
Cannot show the editor for this task. (Microsoft Visual Studio)
===================================
Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)
Program Location:
at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()
at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskMainWnd.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)
-
Any help is appreciated.
Gulden
.......
have you tried re-installing ssis?|||I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.
|||Last couple of days I have been re-installing VS 2005 and SQL Server 2005 from scratch. This is related to a system or temp file which was created by SSIS which does not go away when these apps uninstalled.
Would anybody know if I should go ahead and rebuild my system or are there any specific files or registry items involved that I should search for?
|||
When editing scripts, VB for applications flashes for a split second and goes away. When I am running the packages on the Debug mode, I get "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for inconvenience" right away. And does not iterate through any script after that. I wonder if I have too many script tasks in the package (about 90)
Something has seriously been corrupted concerning the Script editing that no installation can fix. It is so unexplainable to me.
Any advice ?
|||Mistery solved!
Apparently they pushed a Macromedia package to hundreds of people's computers in my workplace re-registering at least 20 dlls including vbscript.dll.
|||I am still experiencing this problem and none of the suggestions seem to work. Any help would be appreciated.|||Did you get this problem resolved?I have the same problem on a production package that I need to run once a week. Any help is appreciated.
Pade
|||
I face the same error. It was working fine - until suddenly i started getting this message "Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)"
and it doesn't go away neither the script editor opens.
Anyone who has solved this issue ?
Thanks
Cannot show the editor for this task. Specified cast is not valid
This error is pretty persistent. I re-installed VS 2005 and SQL Server 2005 but did not help. Every time I try to open a Script Task editor it gives me the same error regardless of the project or package. DO I NEED TO REBUILD MY SYSTEM ?
===================================
Cannot show the editor for this task. (Microsoft Visual Studio)
===================================
Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)
Program Location:
at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()
at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskMainWnd.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)
-
Any help is appreciated.
Gulden
.......
have you tried re-installing ssis?|||I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.
|||Last couple of days I have been re-installing VS 2005 and SQL Server 2005 from scratch. This is related to a system or temp file which was created by SSIS which does not go away when these apps uninstalled.
Would anybody know if I should go ahead and rebuild my system or are there any specific files or registry items involved that I should search for?
|||
When editing scripts, VB for applications flashes for a split second and goes away. When I am running the packages on the Debug mode, I get "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for inconvenience" right away. And does not iterate through any script after that. I wonder if I have too many script tasks in the package (about 90)
Something has seriously been corrupted concerning the Script editing that no installation can fix. It is so unexplainable to me.
Any advice ?
|||Mistery solved!
Apparently they pushed a Macromedia package to hundreds of people's computers in my workplace re-registering at least 20 dlls including vbscript.dll.
|||I am still experiencing this problem and none of the suggestions seem to work. Any help would be appreciated.|||Did you get this problem resolved?I have the same problem on a production package that I need to run once a week. Any help is appreciated.
Pade|||
I face the same error. It was working fine - until suddenly i started getting this message "Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)"
and it doesn't go away neither the script editor opens.
Anyone who has solved this issue ?
Thanks
Tuesday, February 14, 2012
cannot save trace output to a local file?
This is SQL 2000 on a win2k3 box.
In Trace Properties, when I checked 'Save to file' and clicked the folder
icon and specified a local file name, I got the following message:
For SQL server to write to a file, file path should have the following
format \\servername\sharename\filename
But I'm trying to write to a local file on the database server. How do I
have to use that format? Also in the Save As window, there is no way to
specify the path name like that given in the above message.
Thanks for any help,
Bing
bing wrote:
> Hi,
> This is SQL 2000 on a win2k3 box.
> In Trace Properties, when I checked 'Save to file' and clicked the
> folder icon and specified a local file name, I got the following
> message:
> For SQL server to write to a file, file path should have the following
> format \\servername\sharename\filename
> But I'm trying to write to a local file on the database server. How
> do I have to use that format? Also in the Save As window, there is
> no way to specify the path name like that given in the above message.
> Thanks for any help,
>
> Bing
You don't. You can specify any local drive with a drive letter.
David Gugick
Quest Software
www.imceda.com
www.quest.com
cannot save trace output to a local file?
This is SQL 2000 on a win2k3 box.
In Trace Properties, when I checked 'Save to file' and clicked the folder
icon and specified a local file name, I got the following message:
For SQL server to write to a file, file path should have the following
format \\servername\sharename\filename
But I'm trying to write to a local file on the database server. How do I
have to use that format? Also in the Save As window, there is no way to
specify the path name like that given in the above message.
Thanks for any help,
Bingbing wrote:
> Hi,
> This is SQL 2000 on a win2k3 box.
> In Trace Properties, when I checked 'Save to file' and clicked the
> folder icon and specified a local file name, I got the following
> message:
> For SQL server to write to a file, file path should have the following
> format \\servername\sharename\filename
> But I'm trying to write to a local file on the database server. How
> do I have to use that format? Also in the Save As window, there is
> no way to specify the path name like that given in the above message.
> Thanks for any help,
>
> Bing
You don't. You can specify any local drive with a drive letter.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
cannot save trace output to a local file?
This is SQL 2000 on a win2k3 box.
In Trace Properties, when I checked 'Save to file' and clicked the folder
icon and specified a local file name, I got the following message:
For SQL server to write to a file, file path should have the following
format \\servername\sharename\filename
But I'm trying to write to a local file on the database server. How do I
have to use that format? Also in the Save As window, there is no way to
specify the path name like that given in the above message.
Thanks for any help,
Bingbing wrote:
> Hi,
> This is SQL 2000 on a win2k3 box.
> In Trace Properties, when I checked 'Save to file' and clicked the
> folder icon and specified a local file name, I got the following
> message:
> For SQL server to write to a file, file path should have the following
> format \\servername\sharename\filename
> But I'm trying to write to a local file on the database server. How
> do I have to use that format? Also in the Save As window, there is
> no way to specify the path name like that given in the above message.
> Thanks for any help,
>
> Bing
You don't. You can specify any local drive with a drive letter.
David Gugick
Quest Software
www.imceda.com
www.quest.com