My clients hosting company does not allow any direct interaction with SQL Server ie no Enterprise Manager/ Query Analyser access!
Are there any free web pages that i can download and then host on the clients server that allow me to create tables and stored procedures simply without writing a script for everything?
Thanks
Rich
Hi,
I am using SQL SeRVER 2005,i wanna know the jobs that are running in that server.
Is there any option to see in control panel?
Thanks,
Does anyone know how I can password protect XP Professional Control Panel?ThanksRonnie
View 1 Replies View RelatedHi all,
I tried to remove AdventureWorksDB in the "Add or Remove Programs" of Contol Panel and I got the following errors: (1) AdventureWorksDB Error 1326: Error getting file security: CProgram FilesMicrosoft SQL ServerMSSQL1MSSQLGetLastError: 5. |OK| and (2) Add or Remove Programs Fatal Error during installation (after I clicked the |OK| button). Please help and tell me how I can solve this problem.
Thanks in advance,
Scott Chang
Hi,
I need to assign the value for a field in a report based on Expand/Collapse state of another field.
Eg. If Collapsed, the value should be "AA" else if Expanded "BB".
Is there any way to get the value of InitialToggleState for any field in SSRS.
Thanks in advance.
Sathya
Hi,
I would like to know how to call a report from a report viewer control in a web application. The reporting services is forms authenticated. I've done this authentication using the sample solution given by microsoft (adding custom security extension). Now am able to view the reports from Report manager and Report server URL. But i dont know how to authenticate the user from my web application and pass the credentials to the report server to view the report in report viewer control. Can somebody help in this? its bit urgent. Thanks in advance
What are the options to create a table of contents based on the report items in a List Control? Document Mapping works for online viewing. A table of content would make the report easier to read when it's printed.
Any help is much appreciated. Thanks.
Hi my friend designed an SQL database for me on my server, I dont know how he did it but there appears to be no admin panel only an SQL agent. I have no experience with this and am sinking quickly.
I need to change the number of characters permitted in a certain field.
I have to present this tomorrow morning so any help would be greatly appreciated.
My friend flew to Italy last night and I cant contact him hence the question."
Countydown writes "Hi my friend designed an SQL database for me on my server, I dont know how he did it but there appears to be no admin panel only an SQL agent. I have no experience with this and am sinking quickly.
I need to change the number of characters permitted in a certain field.
I have to present this tomorrow morning so any help would be greatly appreciated.
My friend flew to Italy last night and I cant contact him hence the question."
From database explorer isn't possible obtain the result of a store procedure in a grid panel ?
View 1 Replies View RelatedOur client is asking to display the 'parameter panel in right side of the report' insted of top.
how can I do this?
I have a gridview that is tied to a SQLDataSource control which is inside an update panel.
What I'm trying to accomplish is when the page is loaded the gridview is filled from the SQLDataSource. I have some textboxes also on the page so that the user can add new items to the gridview. The update panel trigger is tied to my code behind page through a button click which added the new data to the DB with an INSERT statement. Since the gridview was inside the update panel I thought when I placed the new data into the DB and the update panel caused the portion of the page that holds the gridview to refresh that the gridview would show the newly added data but it is not.
I am missing something but I do not know what. I tried adding a gridview1.databind() and SQLDataSource1.DataBind() but niether caused the update of the gridview as I had hoped.
Thanks for any of your help.
Ty
Hi,
I've a slight problem with configuring my Report Server. I have set up everything apart from the initialisation and and the Windows Service Identity, however when I select the panel for the latter I am presented with a message box displaying the following:
" Reporting Services Configuration Manager:
There was an error while switching panels. The most likely cause is an error retreiving WMI properties. The exception details are:
InvalidArgument=Value of '1' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex "
I have tried re-installing the entire SQL server setup and this made no difference, I followed this by removing then reinstalling just the Report Service. Still nothing.
Any ideas as to what it is doing and how I should go about fixing it?
Sim
Hi All,
I am placing a Matrix inside the table control for grouping requirements,but when we export the report to the Excel, the contents inside the table cell are ignored. Is there any way to get the full report exported, as per the Requirement.Please help me with this issue.
With Thanks
M.Mahendra
does any one have and example of how to embedd a flash swf file onto a report.??? Is it possable? any examples would be helpful.
View 1 Replies View RelatedUPDATE #2: When it said "Do you want to install Microsoft SQL Server" I said "yes" and that caused it to work. I exited and re-ran and now the print runs w/o the "install SQL Server" (If the prompt had said "Do you want to install the print dialog" we wouldn't be having this discussion...)
UPDATE: After posting this i discovered that the same thing occurs when attempting to print the report direct from IE6: First a dialog pops up "Do you want to install this software?" Name: Microsoft SQL Server. When I click "Don't Install" I get the dialog "unable to load client print control." Since this happens direct from IE6 I suspect it's browser settings. I'll resume tomorrow and post a followup.
My WinForm C# app integrates Reporting Services by calling them from WebBrowser controls. The problem is attempts to print cause a dialog: "unable to load client print control."
I've read prior posts that say "enable Active-X in your browser" - I don't know how to do that from a WebBrowser control.
Any ideas how to support Reporting Services "Print" from within a WebBrowser control?
RELATED THREADS
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=332145&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=264478&SiteID=1
I have a project that is using an exsisting SQL DB that stores uploaded files and images into the DB.
I am trying to figure out how to take the file from the fileupload control and place it into the DB field.
Almost all the examples I've seen deal specifically with images but I will not know what the file type is. It could be an image, a word doc, and excel file, a text file ect.
I thought to use a INSERT statement but I wonder if that will work.
I know that fileupload.postedfile.saveas saves the file to a directory you name but that does not help me. I thought I could just use the fileupload.contents property in the Parameter add statement but that must not be an option as I cannot find and example of that usage besides that would just be too easy I guess.
Any help or code would be accepted with great gratituide. I realize that this is not the best way for performance but it is what it is and I cannot scrap the old DB I just have to make it work.
Thanks,
Ty
The following error happens in my ASP.NET page from time to time. It will disappear after I restart the SQL Server. I guess I messed up in the garbage collection, but I really don't know what to do except using "conn=nothing" statement, can anyone help me with this?
Thanks!
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. 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.Runtime.InteropServices.COMException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.Source Error:
Line 39: Public Sub New()
Line 40: conn = New ADODB.Connection
Line 41: conn.Open("Provider=SQLOLEDB.1;Persist Security Info=xxxxx;User ID=xxxxx;Initial Catalog=xxxx;Data Source=xxx")
Line 42: rs = New ADODB.Recordset
Line 43: my_UserID = 0
I have built a page with the login control using the default sql server express database that is integrated into the application. I have got it working on my development machine and want to post it on the web with a web hosting company. I did not know if they had to have sql server express installed on that machine for my database to work properly or will it work with sql server 2005 installed. Most web hosting companies that I have called say they only support sql server 2005 and not sql server express. I was unsure if the login would work or not. Please help with this issue. I am new at ASP.net and really enjoy it. However, I want to ensure that my site will work on the web as it does on my machine.
View 4 Replies View RelatedHello,
I have a FileUpload control on my webform. I would like a user to be able to upload a file to the server. Is there any way to store this file in SQL Server 2005?
Thanks
ASPSQL66
Dear all,I am couping a dropdownlist and a sqldatasource control to display a column from a database of SQL/Server on browser. However, when I tried to configure the sqldatasource to let it get data from SQL/Server, it always report an error. It normally happens at the first step of creating new connection. After I specified the correct sql/server instance name, using SQL server authentication, and select a database name. Even the connection test can sucessfully passed. However, when I click the "OK" button, an error message saying "object reference not set to an instance of an object" popped out and I could not add new connections. The strange thing is that after I reintall the visual studio 2005 service pack 1. It will function properly for a while. After sometime, it will fail again. Anybody has suggestions? Thanks a lot!
View 1 Replies View RelatedHi guys'n'girls...
I currently work for a company where we develop several large ASP.NET applications which are VERY data centric. But lately we have run into a problem on our developer DB...
On the project I am working on we currenctly have approx. 10 developers working concurrently on the database. That means that we often run into errors caused by two developers working on the same stored procedure, function or trigger so the developer who adds his changes last, overwrites the modifications done by the other developer. The obvious answer is source control for the db, but as far as I can tell this is only available for stored procedures and not for functions or triggers... And even the stored procedure solution isn't very safe because it only works if every developer is editing the procedures through VS.
So what do we do? There must be some solution to this problem... And I'm pretty convinced that we are not the first company to face this problem. Are we doing it the wrong way or do you know another solution?
Thanks in advance!
Hi, everybody
I am trying to run job that will
look for errors in error log files and save it to text file
In order to get up to last minute infromation I am using errorlog
1. at what point errorlog ranamed to errorlog1?
2. Can configurate size of errorlog file ?
3. Can I configurate time when errorlog ranamed to errorlog1
when i run in Sql Query analyser
print '------------ level 16 from last Sql errorlog file ----------------'
print 'These messages indicate errors that can be corrected by the user '
USE master
EXEC xp_cmdshell 'findstr /i /n /c:"level 16" InnvisionGMSSQL7LOGerrorlog.*'
go
I getting output
------------ level 16 from last Sql errorlog file ----------------
These messages indicate errors that can be corrected by the user
(0 row(s) affected)
when my job saves this command to file
I getting output
------------ level 16 from last Sql errorlog file ---------------- [SQLSTATE 01000]
These messages indicate errors that can be corrected by the user [SQLSTATE 01000]
How replace [SQLSTATE 01000] on user friendly message
Thanks
In the past month and a half I have had the SQL Server error log on one of my SQL Server 6.0 servers eat up ALL the free disk space on the partition containing SQL Server and the databases/devices.
This means that the error log gets to be about 3 GB in size!
When I try to run a `tail` against the error log to determine what errors might be filling up the log, I get `garbage` like it`s not really a text file. This has indicated to me that the error log is somehow becoming corrupt.
Anybody have similar experiences or suggestions?
Thanks!
Today many applications (SAP, SIEBEL, MANUGISTICS, PEOPLESOFT, and soon) does not have a client direct access to connect to the database.They use an Application Server that has only one connection to thedatabase and the users get connected to this application server.THE QUESTION: How to control SQL Server User License in this new model,automatically?You cannot enable SQL Server Audit because users are not connecteddirectly to the database.You cannot use Identity Management applications because they do notwork on NOT Enterprise Business software.How to do that if you have hundred of applications and database?Regards,Marcio
View 9 Replies View RelatedHi, I've a ListBox Web Server Control where I select a list of citiesnow I would like to create a stored procedure with the selected values... please note that I use metods like these for execute my Stored procedure public DataSet Getgfdfgh(SqlConnection connection, String IDAttivitaTipo, DateTime DataInizio, DateTime DataFine) { ConnectionState currState = connection.State; if (((connection.State & ConnectionState.Open) != ConnectionState.Open)) connection.Open(); try { SqlParameter[] parameters = new SqlParameter[3]; parameters[0] = new SqlParameter("@IDAttivitaTipo", IDAttivitaTipo); parameters[1] = new SqlParameter("@DataInizio", DataInizio); parameters[2] = new SqlParameter("@DataFine", DataFine); SqlCommand cmd = CreateStoreProcedureCommand("Getfhdfh", connection, parameters); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds); return ds; } finally { if ((currState == ConnectionState.Closed)) connection.Close(); } } How Can I manage a list of values ??Thanks for help me!!
View 1 Replies View RelatedWe are using the webviewer control.
We get the following error when we try to export to EXCEL.
InternetExploer cannot download ...n=OnlyHtmlInline&Format=EXCEL from app.webcobra.com.
Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.
This error comes up almost immediatly after it starts trying to download the file. It is a large dataset but it isn't "overly large". There are basically 44 records.
The other wierd thing is that it works fine on our BETA servers but not on our Production servers. We figure this is a setting somewhere that we have missed.
And now I found out that if it just leave it sitting there it eventually asks me if I want to open the file and it opened fine.
So what was the above error all about????
Does anyone have any ideas that I can look into?
Thanks!
Hi,
I was wondering if anybody could advise on source code control for SQL Server express, for the table schema and stored procedures?
I currently use Sourcesafe V6 to work with visual studio 6 and 2003 (although it isn't integrated in 2003), and wondered if that can be used?
Any suggestions would be greatly appreciated, as I see this as a disaster waiting to happen!
Thanks in advance.
Mark
I have null values in some of the fields & when I use EDIT to make changes these changes are not recorded + I receive no error.
View 1 Replies View RelatedCan anyone help me with this scenario!!!!
I have a sybase database and a sqlserver 2000 database.
I want to insert data into sybase database table thru sql-server 2000 using distributed queries
When i execute the following the transaction
Create procedure myCurrentDataBaseProcedure
as
begin
begin tran
insert into mytable values(1)
if @@error <>0
begin
rollback transaction
return
end
insert into sybasedatabaseserver.databasename.dbo.tablename values(1)
if @@error <>0
begin
rollback transaction
return
end
commit transaction
end
The procedure is created in sql server database
trying to execute this procedure..shows error
The first part of the procedure is executed.
But the error is here
insert into sybasedatabaseserver.databasename.dbo.tablename values(1)
The data is succesfully inserted in the local database
I am unable to insert data into the remote database
Can anyone suggest me wht shd i do in this scenario
Are there any drivers to be loaded to commit this transactions
Pl.Help
I attached a SQL database called Cars, using the following code:
Code Block
IF NOT EXISTS(
SELECT *
FROM sys.databases
WHERE name = N'Cars'
)
CREATE DATABASE Cars
ON PRIMARY (FILENAME = 'C:DataServer FilesCars.mdf')
FOR ATTACH
GO
I then detached the database using:
Code Block
EXEC sp_detach_db @dbname = 'Cars'
,@skipchecks = 'true'
,@KeepFulltextIndexFile = 'true'
GO
I then copied the .mdf and .ldf to another folder, using Windows Explorer.
I then attached the database using the new folder name in my code.:
Code Block
IF NOT EXISTS(
SELECT *
FROM sys.databases
WHERE name = N'Cars'
)
CREATE DATABASE Cars
ON PRIMARY (FILENAME = 'C:DataNew FolderCars.mdf')
FOR ATTACH
GO
Now when I go to update my table, I see that I am hitting the .mdf in the new folder.
And, when I do my table updates, I see that I am hitting the .ldf in the old folder.
Two questions:
1. What did I do wrong, that updates are hitting the new .mdf, but the old .ldf?
2. How do I control what .ldf SQL Express uses?
I see references to 'SQL Server Agent' in the help pages, but do not see 'SQL Server Agent' within the application.
I see the reference to the old folder path, within the 'Database Properties Files page', but no possibity to edit the value.
If the net is domain control.
Can we use reporting server as usual?
Or need some special setting about it for protect it working well?
Thanks
Suppose I check "SQL Server 2005 Express Edition" as one of the prerequisites for a custom app in a Windows Setup project.
From reading whatever docs I could get my hands on, it's still not clear to me how to control the installation of SQL Server Express with respect to things like instance name, service account, etc, etc.
In other words, this is stuff that's normally the domain of template.ini. However, there's no clear indication of where I should put template.ini so that the install of "prerequisite" SQL Server Express will see it and configure accordingly...
Thanks in advance to anyone who can help solve this...
Josh