I'm getting the attached error message when i try to refresh the schema of my sqldatasource. select statement and connectionstring are valid.
Using VS2005 and SQL 2008... started doing theis when we upgraded to 2008.
Very strange, and not much help googling... any thoughts?
HELP! I'm having a similar issue, but with much longer execution times. It's quite ridiculous actually. Basically my packages (about 20 of them in all) create tables from views within the same DB. As the year progresses and our tables grow, the individual packages naturally take a bit longer...
Here's some working code I stole and converted to vb.net. It seems to work for setting some permissions for child objects, usewrs, groups, etc... but I haven't been able to set permissions on "this object only"... All of the ones I create fall into the advanced, more granular permissions of...
Hai2u! Wasn;t sure wether to post this here of in the Windows 2000 server thread, but here goes:
I have an ASP.NET (VB.NET) web app that does various things related to file share administration... blah blah blah.
One of the things this tool does is creates AD groups, and adds groups and...
I need to add a Computer (ResID) to an existing sms collection via a vb.net web app using the system.management class and I haven't been able to figure it out.
Anyone done this?
I can't seem to create a new VB.NET Web App on localhost. It hangs every time, with no error message. I've reinstalled IIS & .NET Framework and still it wont work. My browser will also hang any time I try to load an aspx. Any ideas?
I can't seem to create a new VB.NET Web App on localhost. It hangs every time, with no error message. I've reinstalled IIS & .NET Framework and still it wont work. My browser will also hang any time I try to load an aspx. Any ideas?
Hello!
I'm getting a syntax error when I try to put a CSE statement inside my FROM clause... is this possible?
Basically I want the query to use a different table depending on the @service parameter that the user inputs.
select column1, column2, ...
from
(CASE
WHEN @service = 'AV' THEN...
yes! it works now, EXCEPT...
When I run it the first time it's fine. then when I modify the parameters (choose different service or location from the dropdown box) and run it again I get an error.
...Probably a Reporting Services issue.
I have a query that accepts two parameters, location and service. I need the query to select from a different table depending on the service the user selects (a drop down box in SQL Reporting Services). I've tried to use a case statement in the from clause to no avail, and I can't seem to get...
I'm writing an app that runs a batch of installation packages (vbscripts). Some of these packages require reboot, others do not. the user selects the apps they want from a list and clicks install. My app creates a list of installation paths in a file on the root of the c drive.
example...
I have an exe and I want it to return variables back to wherever it was called from.
How do i do this?
in other words, I run dnsloc.exe and it uses my IP address to determine my dns suffix and then returns the dns suffix.
yes yes, but I'm trying to avoid any kind of middleman. Ideally they would return in the same way as the exit code... which I tried to use but it won't pass out a string.
i want the script to ba able to be called from anywhere... another script, an application, the command line, etc
and I'm trying to avoid writing to a file.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.