Newbie Q: Contacting Server To Create Web Project Runs Forever

Aug 25, 2005

hi, I'm using vstudio 2002, trying to create an C# asp web project, when I select these for a new project it says contacting server to create web project and never quits even after 1.5 hours. I saw in a similar post elsewhere they said the solution is to disable the firewalls - and I did that - and I have norton only, so that is not the issue. IIS is installed as well as SQL server, I can see it running. I have tested successfully a sql connection not long ago using access. Any thoughts? Thanks.

View 3 Replies


ADVERTISEMENT

Simple Select Query Runs Forever

Dec 14, 2007



Hi all,

I know this sounds rather dumb but my select statement is running forever!
I am trying to execute the statement through my C# code.

If I try to run the query through sql server management studio, sometimes it runs fine, but sometimes it keeps running and never returns a value.

I am doing something like this:

###########################################################################################
String query = "SELECT studentID from StudentTable WHERE studentDeptID = '100' AND deptName = 'CS'";

SqlCommand command = new SqlCommand(query, connection);
Object myObject = command.ExecuteScalar();

############################################################################################

StudentTable contains roughly 1000 rows.


Somebody please help me out of this. Thanks in advance.

Surya

View 11 Replies View Related

Query Based On Two Temp Tables Runs Forever

Oct 28, 1998

View 1 Replies View Related

Help A Newbie And Live Forever... Maybe

Feb 22, 2006

Hi, sorry if this has been asked before but I'm pretty strapped for time...

I have two tables: [photos] and [photoFolders]

[photoFolders] contains information about photo albums on the site im creating. The information in [photos] lists information about all photos along with which [photoFolder] they belong. When the user logs in, I want to present a list of all 'folders' in their name along with the TOP image with the corresponding folderId...

[photos]
photoId
photoName
folderId
photoDescription
cUserId

[photoFolders]
folderId
folderName
eventDate
cUserId

Any help would be GREATLY appreciated

We're all going to hell... I guess I'll see you there!

View 15 Replies View Related

Create SQL Server Project In VB.NET 2.0 (Database Project)

Mar 13, 2008

Hi all  How can create trigger in sql server project in VB.NET 2.0 ?thanks in advance   

View 1 Replies View Related

Query Analyzer Runs The Query Instantly But ADO Can Take Forever???

Aug 29, 2001

THis is so annoying. I have 3 ADO executes in my program. THe first one creates a view, the second one performs an outer join on that view and returns a result set, the third execute drops the aforementioned view. THe program that is using this is installed on about 200 computers scattered across Germany and Italy, all querying the same MSsql server 7.0. THe queries run quite quick when few users are actively using the program (after hours for example). however in the heat of the day performance goes up and down dramatically with identical queries taking from 1 to 20 seconds to return their result set. Now I initially thought 'bandwidth issue out of our server'. However I noticed that if I take those three queries and run them from the sql server enterprise manager( running on the same computer as the aforementioned program) then the queries run instantly and the data is in my result pane in less than 2 seconds ALWAYS....even when the program is dogging it with 20 second delays before the result set returns. I know it is hanging on the return of the result set as I put a stop after before each ADO execute in order to check which one was eating up my time. Why is there this dichotomy between running the queries from my enterprise manager versus running them from an ADO object. Both are using TCP/IP (no named pipes involved). I havent monkied with the attributes of the ADO result set so they are all set to default.
I have used the sql server profiler to trace these queries and they always run in less than 33 milliseconds. THe duration is also never more than 33 milliseconds. THis stinks of a network resource issue but what always leads me somewhere else is how consistent the performance of the enterprise manager is when it runs the exact same three queries.

Here is my slightly edited connection string
Public Const connection_string = "Provider=SQLOLEDB;Server=000.000.000.000;" & _
"User ID=johndoe;Password=janedoe;Network=dbmssocn;" & _
"database=fidojoe"

Here are the 3 ADO executes:
conn.Execute (sqlstr_create_view)
Set resultset1 = conn.Execute(sqlstr_get_providers_by_DMISID)
conn.Execute (sqlstr_drop_view)

View 3 Replies View Related

Can't Create A Setup Project For Project Referencing Microsoft.SqlServer.ManagedDTS

Feb 3, 2007

I have a very small project written in VB.Net 2005 using the SQL Server 2005 SSiS DTSx package.

I took a SQL Server 2000 dts package and using the SQL Server 3005 legacy tools migrated it so I could still use the package withing SQL 2005 until I can build one using BI/SSIS.

Anyway,I added the reference Microsoft.SqlServer.ManagedDTS so I could then use the Microsoft.SqlServer.Dts.Runtime so I can execute the commands:

Dim oApp As New Application
Dim oPkg As New Package
oPkg = oApp.LoadPackage(g_DTSx_Directory & "AOC copy Generic1 CSV to AOC_verify_file_1.dtsx", Nothing)
Dim oResults As DTSExecResult
oResults = oPkg.Execute

Ok. That works fine. Executes without a hitch. So now I try and create a setup project for this and I use the setup wizard.

During the creation of the setup project I get a message that states:
The following files may have dependencies that cannot be determined automatically. Please confirm that all dependencies have been added to the project.
C:windowssystem32msxml6.dll

OK. The dll is part of the reference I mentioned above and I have no idea what other dependencies it may have.

How do I find this out?

Has anyone else created a project like this and experenced the same?

I am on a clean build running WinXP Pro with SP2 - VS2005 with SP1 and the SQL Server 2005 tools.

View 1 Replies View Related

SQL 2012 :: Create And Map Server Environment For Project Deployment

Oct 27, 2015

I know how to "Create and map a Server Environment" using management studio [URL] ......

Is it possible to create the environment in DTS (2012) and have that environment created on the target server?

View 2 Replies View Related

How To Create CLR Table Trigger In Server Database Project

Jul 7, 2015

It used to be so simple in SQL 2008.

With SSDT and VS2012, it seems impossible. 

I created the project and I added a trigger

public
partialclassTrigger
{
    [Microsoft.SqlServer.Server.
SqlTrigger(Name =
"myPM10000", Target
= "[dbo].[PM10000]",
Event = "FOR UPDATE, INSERT")]
publicstaticvoidmyPM10000()
etc.

When I try to build the project it fails:

Error 1 SQL71561: Trigger: [dbo].[myPM10000] has an unresolved reference to object [dbo].[PM10000]. D:ProjectsVS2013myproject_CLRobjDebugmyproject_CLR.generated.sql 8 32 myproject_CLR

I have tried with and without adding a database reference.  With the reference all I accomplish is lost time waiting for that monster link to the database to generate. There has to be a way to make this happen, right?  I don't want to have to rewrite this in Transact SQL.

View 8 Replies View Related

Cannot Create New Project In SQL Server Management Studio Express 2005

Apr 23, 2008

I installed SQL Server Express 2005 and was able to install the sample databases. I have been working through the on-line tutorial. In Lesson 4 of the tutorial it instructs you to select File, New, Project. However, when I select File, New there is no Project choice listed. Have I failed to install something correctly?

Thanks for any assistance.

View 7 Replies View Related

Can I Create A Job That Runs Other Jobs, Or.....

Aug 15, 2000

I have jobs (DTS packages) for several different tasks that I would like to run sequentially, rather than trying to estimate how long each will take and schedule them individually.

Any suggestions?

Thanks,
Cara

View 2 Replies View Related

Create New Scheduled Job Which Runs A Dts Package

Nov 28, 2007

Hello Experts,

I found some similar threads and guides but they didn€™t help me with my special problem.

I converted a dts package (built in SQL 2000) to SQL 2005. Right now it€™s a legacy package.
(I tried the Tool Microsoft SQL Server 2000 DTS Designer Components to open the package. It€™s going well)

I would like to build a scheduled job which runs this dts package.
In SQL 2000 you can right click on the package and create the job.
SQL created string like this:
Dtsrun ASDFHJKSF56A4DFSLAKDHFJKS65646ASDFHSF (very long sting, it€™s the ID of the dts package)

How can I make something like this in SQL 2005?
Where I can get the ID of a dts package from?

Best Regards,
Alex

p.s.
- I red the thread from Jamie Thomason and will directly mark as answer after I get a answer
- of cource I will delete my thread too if I overlooked a thread with the same issue

View 5 Replies View Related

PSI: How To Update Custom Field Value For A Perticular Project Using PSI(Project Server 2007)

May 6, 2007

Hi,



I want to update value of a custom field for a perticular project in Project Server 2007 using PSI.



I have created 5 enterprise custom fields(A,B,C,D,E) through PWA/Server Settings.



I want to search all Projects on Server. If any project is having value for custom field A then I want to update rest of the custom fields(B,C,D,E) for that perticular project.



I dont know how to do it please help.





Thanks in Advance



Madhukar

View 5 Replies View Related

Cannot Create A Connection To Data Source 'xxxxx' When User Runs Report

Dec 6, 2007

We have a new installation of sql server 2005 reporting services.
we can deploy reports without a problem users can connect to report server
but when they try to run reports they get this error msg.

An error has occurred during report processing.
Cannot create a connection to data source 'xxxxx'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors

in reporting services the datasource credentials are saved on the server

View 3 Replies View Related

How To Enable CLR Integration In SQL Server Express And Create SQLCLR Project In VB 2005 Express?

Aug 31, 2007

Hi all,

In my SQL Server Express (that is installed in my Windows XP Pro PC), SQL Server 2005 Network Configuration has Protocols for SQLEXPRESS. I tried to do "Enabling CLR Integration" in my SQL Server Express: (1) If I clicked on "Surface Area Configuration for Services and Connections", I got an error "An exception occurred in SMO while trying to manage a service, (Microsoft.SqlServer.Smo) Additional information: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The operation could not be completed. (WinMgmt). (2) If I clicked on "Surface Area Configuration for Features, I got a different error "Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required computer has the required Windows Management Instrumentation components and then try again. (SQLSAC) Additional Information: An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo). Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The operation could not be completed. (WinMgmt). Please help and tell me how I should do to get "Enabling CLR Integration" in my SQL Server Express done and how I can create SQLCLR Project in VB 2005 Express.

Thanks in advance,
Scott Chang

View 6 Replies View Related

Unable To Use Project Professional To Establish Connection To Project Server

Jul 23, 2007

I fail to use project professional 2003 to access to the project server 2003 using MSDE 2000 in local area network, following message was shown,



Connection failed:


SQLState: '01000' SQL Server Error 1326 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.



I have seen these pages with similiar cases but can't help.

http://support.microsoft.com/kb/818047/

http://support.microsoft.com/kb/837653/en-us



Can anyone help me?? Thanks a lot!

View 1 Replies View Related

Download And Create A Report Project From A Report Server

Jan 9, 2007

Before I start coding ...

Is there any existing software/trick/hack to create a Report Project from the DataSources and Folders/Reports on a Report Server, i.e. the inverse of Deployment?

Would there be anybody interested in such a thing, and, if not, why not?

View 1 Replies View Related

A Procedure Runs Slow As A Job But Runs Fast Executed In A Query Window

Apr 23, 2008

Performance issue.


I have a very complex Stored Procedure called by a Job that is Scheduled to run every night.
It's execution takes sometimes 1 or 2 hours and sometimes 7 hours or more.

So, if it is running for more than 4 hours I stop the Job and I run the procedure from a Query Window and it never takes more than 2 hours.

Can anyone help me identify the problem ? I want to run from the Job and not to worry about it.

Some more information:
- It is SQL 2000 Enterprise with SP4 in a Cluster (It happens the same way in any node).
- The SQL Server and SQL Agent services run using a Domain Account that have full Administrative access.
- When I connect to a Query Window I also use a Windows Account.

- There is no locks or process bloking or being blocked while the job is running.
- Using the Task Manager the processor activity is ok, no more than 30 % in any processor.

View 15 Replies View Related

How Do I Create An SSIS Project?

Oct 27, 2006

How do I create an SSIS Project in BIDS?

I installed BIDS, but I don't see any SSIS projects to create.

When I click File - > New Project
I see the following options under "Business Intelligence Projects" section.

1. Report Server Project Wizard
2. Report Server Project

No where do I see anything about SSIS or integration services projects. Am I missing something? Did I not download something?

I have
Windows XP SP2
Visual Studio .Net 2005
SQL Server 2005 Express
SQL Server Management Studio Express
Installed Business Intelligence Development Studio

My company has a SQL 2005 server that I connect to in which I want to run SSIS projects off of.

I'm sure I'm just missing something small. Can someone point me to the right direction?

Thanks,

View 11 Replies View Related

Team Project In TFS - SSIS Project Sets Itself As The Startup Project

May 29, 2008



For some reason in a Team Foundation Team Project that has multiple project types (SSRS, SSIS, WebSite, C# Business DLL...), the SSIS project makes itself the startup project to the team project. If I explicitly set another project as the startup project to the team project and then select an SSIS package in the SSIS project in the team project, the SSIS project becomes the startup project automatically.

I am using Visual Studio 2005 SP1.

View 3 Replies View Related

Help For Newbie: How To Create An Autonumber

Feb 11, 2005

Hi guys/gals. An intro, I've just pick up some database basic skills and currently doing a simple project.

I really need advise on how do I create a field that can generate autonumbering for eg. scenario

There are 3 types of service_id like CTXXXX, GPXXXX, and STXXXX (where XXXX are running numbers). What I need is to have the XXXX auto generate and running. Also if I were to delete an old record for example CT0033, the latest number eg. CT1111 will not be changed to cover up for the missing CT0033.

I apologize if the description is a bit improper, but I'm new to this. Really appreciate anyone that can help. Thanks!! :o

View 3 Replies View Related

Can I Create The Variable With Scope --Project

Mar 19, 2008

can i create the variable with scope --Project

View 5 Replies View Related

Where Can I Get A C# CLI Assembly Template To Create A New Project With?

Dec 29, 2006

Does anyone know where I can download a C# CLI Assembly template?

In VS 2005 there are no defaults to create a C# SQL Assembly like the sample HelloWorld. Rather than modifying the Hello World, I'd like to get an original template for creating a new project just like the templates to create a new Windows project.

Thanks,

Chris

View 1 Replies View Related

Can I Create The Variable With Scope --Project

Mar 19, 2008



Hi All,

Could u plz tell me how to create a variable with scope project but not package(normally)

View 4 Replies View Related

How To Create Subfolders In A Reports Project

Feb 8, 2008

I seem to be missing something rather obvious... I cannot find a way to create subfolder in my reports project in Visual Studio (2005).

Can someone help me out here?

View 11 Replies View Related

Create Project In MS Access 2000

Jun 9, 2006

Hallo

I am getting the €œoverflow€? message (MS SQL Server Database Wizard) on attempt of creating a project in MS Access using SQL Server 2005 Express Edition. I am actually able to open an existing DB.

I was wandering why is this happening and what can I do to create such a project

Thank you

View 4 Replies View Related

Create Project/stored Procedure For SQLCRL

Jun 7, 2006

I installed SQLServer 2005 Standard Edition and tried to created astored procedure in VB. From START/PROGRAMS/MICROSOFT VISUAL STUDIO2005, I created a blank solution. What type of project shall I createfor creating a stored procedure in VB ?I tried to install SQL Server again in case I left back some parts, butI got a message that all parts were installed.

View 2 Replies View Related

Unable To Create Integration Services Project

Nov 7, 2006

Hi,

I've installed with success Visual Studio 2005 team edition for software developers and SQL SQL Server standard edition, but when I've created a new IS project and click on "No Data flow tasks have beed added to this package. click here to add a new DataFlow task"

I receive the following message :

Registration information about the Data Flow task could not be retrieved.
Confirm that this task is installed properly on the computer.

Could not enumerate the registered tasks. (Microsoft.DataTransformationServices.Design)

Does someone experience this before ? is there any work around ?

Thank you for your help

View 4 Replies View Related

No Template To Create A Dtsx Project In BIDS

Jun 29, 2007

i have sql server 2005 dev and bids installed. i want to create a dtsx package, but when i go to File>new>project the template to create an interogation services package is not there. the template for Olap projects is missing also. it used to be present before i upgraded my system to Vista. Could this be a vista issue or do i just need to install a patch or something simple like that?

View 8 Replies View Related

How Do I Create A Integration Services Project Programatically???

Oct 25, 2006

hi everyone,

My vb .net app creates programatically a package. I mean, you can provide name, description, number of OLEDB/ADO connections, variables and so on, where it's stored, from a WinForm.

Up to the moment, process only creates boxes separately wihtout links.

My concern is after this successful cycle I only can open that DTSX and see its components but executing button is disabled (only possible with DTEXECUI.exe) from BIDS.

Only when I create a project (DTSPROJ) and then I put that same .DTSX inside I am be able to execute it.

Well, up to here all of this is very good. Things were created this way for some reason.

My question now is how do I from my application in order to create dtsproj and dtsproj.user (I don't know how many files are needed) and be able to create a package and its "father project". My idea is that the user can choose if create a standalone DTSX or a full project.

Let me know if you need further details.

TIA,

View 3 Replies View Related

Error When Trying To Create A Business Intelligence Project

Jan 15, 2008

Hello,

I'm re-posting my inquiry back in this forum, it was moved to the Reporting Services forum and I firmly believe that this is an installation or file issue related to SQL Server 2005 Express. I have researched issues and errors in this forum regarding the installation of Business Intelligence Studio and the related services and am aware that there are were/are a lot of issues.

My problem is that I have installed the necessary components to run Reporting Services, but when I try and run the Business Intelligence Studio and try to create a project in Visual Studio, I get the following error:

"Object Reference Not Set To an Instance of An Object"

Unfortunately I have no idea what this means. I have tried searching the forums, online searches and I have not found anything. As per some of the responses in this forum, I have checked the web.config files in the ReportServer and ReportManager folders - both check out okay. I then copied all of the necessary folders over from my C: drive to my D: drive (where Visual Studio 2005 and SQL Server 2005 Express are both installed on my machine).

Unfortunately, I have no idea what to do next or how to resolve this issue.

Can someone help?

Thanks!!


View 1 Replies View Related

Newbie How To Create Temp Table And Populate

May 8, 2006

Sorry guys I know this is easy but I've been looking for about an hour for a straight forward explanation.
I want to store a user's wish list while they browse the site, then they can send me an enquiry populated with their choices.
Basically, a shopping cart!
I thought of using session variables and string manipulations but I am more comfortable with DB queries.
a simple 4 column table would cover everything.
SQL server and VBScript
Thanks
M

View 4 Replies View Related

SQL Server Job Running Forever

Dec 9, 2004

I have a job that is running for 2 days straight and the status reads: Performing Completion action.

I have tried to disable/Stop the job, but can't.

I have also tried to start the job which it won't because it is still running.

Is there a table that I can manual delete the schedule # or something along those lines to start all over again.

Thanks

Oh the normal time for the job to run is only 7 seconds.

Lystra

View 2 Replies View Related







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