I am publishing a SQL view in excell using the external data/new database query option and accessing SQL server via ODBC datasource defined.
The query I use aggregates data between 2 diferent dates. I am able to pass the initial date and the end date to SQL, but the results are not aggregated becase I am forced to put in the view the GroupBy clause for the field DATE.
Is there any way of passing parameters to SQL (via Excell) and retrienve the aggregated data based on this parameters?
I have couple of Web pages linking to my RDLs using report viewer Web controls. I have no problem running and viewing them in VS2005 debug mode and report manager until I published them to local folder and set the local folder as an application on my IIS7. When running the published version of the Web pages, all my calendar image buttons (which happen to be part of the report parameter fields) turned to red 'X':
When clicking the View Report button, the animated progress icon not appearing at all. Before the occurance of this problem, I did face the problem whereby the 'NT AUTHORITYNETWORK SERVICE' does not have enough permission to view the report. After referring to some threads, I finally be able to get rid of this error by assigning Browser role to 'NT AUTHORITYNETWORK SERVICE' from the report manager. I wonder could this solution be related to the problem that I'm facing now. Any help would be appreciated.
If Conn.State = 1 Then Conn.Close Conn.Open SisSession.SisConeccion strSheetName = "insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=" & CDB.FileName & "; HDR=YES', 'SELECT * FROM [Bitacora]') " & AdoData.Source & ""
Conn.Execute strSheetName
MsgBox "Datos Exportados en " & Chr(13) & CDB.FileName, vbOKOnly + vbInformation Exit Sub Error: If Err.Number = 0 Then Exit Sub ProcessError Err, Me.Name & " - Exportar", , , True End Sub
*******************************************
Whe in configure the app for a network server it gives an error.
OLE/DB provider returned message: Microsoft Jet culd not find the object 'Bitacora'. Make sure the object exists and the route is ok.
This i assume is because the cange of the server from local to remote.
hello All, Am not sure if this is the right forum to post this. But here goes
I have a phone book, which users could enter numbers via a web interface and a SP.
However i was wondering how to generate a bulk insert script, that would
Import from an uploaded excell workbook to MS SQL How could this be done
NOTE: Am doing an upload via an ASP page, then hoping that either the ASP page, via a SP or an SQL command Statement do a bulk copy for the user who uploaded it to my SQL table
I need to import data in several hunderd excell spreadsheets to a sql 2000 table. What function should I use? Do I need to create a table in sql with the same columns as the excell file and then run a query? Iam pretty new to sql, so please be gentle
Hello, i'd like to know if it's possible to export to excel from SQL Server Management Studio Express (maybe with the toolkit?). Or if there is freeware that can export the dataset of a custom query (or a view) to an excel or CSV file?
Can I pass a parameter to a view? Can something like this even be done?
CREATE view co_interlinks1 AS SELECT [TDirectorships].[IDDir], [TDirectors].[DirLName] + ', ' + [TDirectors].[DirFName] AS DirectorName, [TDirectorships].[Ticker], [TCompanies].[CompanyName] FROM TDirectorships INNER JOIN TCompanies ON [TCompanies].[Ticker]=[TDirectorships].[Ticker] INNER JOIN TDirectors ON [TDirectorships].[IDDir]=[TDirectors].[IDDir] WHERE [TDirectorships].[IDDir] in (SELECT [TDirectorships].[IDDir] FROM TDirectorships WHERE Ticker=@Ticker)--This line requires a variable value corresponding to Ticker for the chosen company and [TDirectorships].[Ticker] <> =@Ticker --This line requires a variable value corresponding to Ticker for the chosen company
Trying to create a view with parameters. I want to use view inside the SP. But I'm getting an error. Why?
-- 1st -- drop table funkete create table funkete (funketeid int, funketeFname varchar(20)) insert funkete select 1, 'funkete' union all select 5, 'amanda' union all select 6, 'funkete' go
-- 2nd -- drop proc a create proc a (@funketeid int) as select @funketeid, funketefname from funkete go
-- 3rd exec a @funketeid = 4 go
-- 4th create view vw_funkete4 as declare @funketeid int select @funketeid, funketefname from funkete go
i have data on a spreadsheet and i need to read it to a table in SQL server ? how can i do that ? some one refere to me a method for that but i need to see what other think is the best option and the most effecienet way let us say!!
Hi, I am using sql server 2005 entreprise edition. I am just wondering when I have a report with parameters and the report uses stored procedure to retrieve the result set for use in the report, if two people from different places are trying to view the report at the same time, and each of them use different set of parameters.
Will they be able to view their report correctly??
The only way the job success is if I select the option add rows wich is copying all rows even the ones that are already there, I tried to drop amd recreate the table option but i just dosn't run that way, help please..
We have many reports with cascading multivalue parameters. The reports and the parameters work as expected within the BI development and when deployed to the RS server. The issue we are having is that when we go to the Report Manager webpage for one of these reports and create a New Subscription the report parameters in the subscription field fail to populate. The first one or two parameters may properly populate but the 3rd, 4th, and 5th fail to populate. As a result we can not select the parameters to submit the subscription.
We have two example reports where one report uses only sql (text) and the other report uses only stored procedures. Both reports have 2 or more cascading parameters.
Any known issues with cascading multivalue parameters in the Report Manager subscription view?
I have a stored procedure that takes a date range and returns all the sales in that date range. I'm trying to create the report model for ad-hoc reporting. When I go to create the dataset view, it only lets me select tables or views.... how do I get around this?
web site made in web dev db all ok locally got server at local ip....... need to upload script files to server... got microsoft publishing wizard all working and database all scripted out. server consul looks like horrible unix outfit.....virtuozzo question is now what? ip says use enterprise manager to publish to server......is that the old version of management studio express, which i have
Hi Guys, I have been trying to use SQL Server 7.0's Web page Publishing tools with Microsoft Frontpage without sucess. I can created the web pages using SQL that it works fine. I have the page set to change automatically when the data is changed and this works while the page is accessed from the SQL Server, however when I upload the page to a frontpage Web, the automatic update does not work. Any ideas what I'm doing wrong?
I am experimenting with the Web Publishing feature in MSSQL 70. Does anyone have any pros and cons when utilizing this feature within MSSQL 70?
I also would like to ask if anyone knows of a different way to access the Web Page designed other than placing it in an accessible file either in a repository or a central site and have people click on the *.htm document thus pulling up the related page on the W3.
Has anyone been able to go from the MSSQL 70 directly to a browser instead of opening the created *.htm file?
We are experiencing intermitant problems on out SQL 7 system. Its running FTP publishing, MS SMTP service and the www publishing service. We reset the services using net stop <service> each morning. When I use the command 'net stop www publishing service' I get the message - The service could not be controlled in its present state. This would indicate that the service has hung. The problems seem to happen over night and is cured by a reboot.
When managing publication for a particular database, not all the tables are listed as articles to add to the publication. Is this a permissions problem? Any way I can check out why they aren't available or, better yet, make them available for the publication?
Hi! How is it possible to set up a repl. scenario, where a subscriber of a DB is also the publisher of this DB for other subscribers. i mean 3 level repliction. MAINPUB SUB1 SUB2 SUB3 notebookSUB1...................notebooksubN
SUB1..3 are subscribing to MAINSUB and publishing to a number of notebooks!
I developped a project using Visual Studio 2005 Standard Edition on a XP pro x64 Machine using a developpemet data area on a SQL 2005 Express Edition.
Everything is ok, even the user and profile management. But when I try to publish my application on IIS (we're talking about a little Intranet), I get my problems. I think is important to say that the server is a Windows Server 2003 and data (database reproduced as a backup of the developpement one) are under an SQL 2005 Standard. The strange thing is that by publishing the "site" VS create a DB under SQL Std named with the path of local ASPNETDB.MDF.
I can reach everything, all data are ok, but when I pass the login page going to main menu on my web-application, I get this error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I think the problem is SQL STD and the fact that it's not "able" to manage MDF files.
I even tried to re-map the SQL DB (named simply as ASPNETDB on the SQL std) by adjusting the web.config file on connection type and user and password to reach the DB ASPNETDB but it does't work anyway.
I am using ASP.NET 2.0 C#, SQL Server 2000Connection string is: "Data Source=USMAN;Initial Catalog=CMS;Integrated Security=True" And by searching forums and goodle, I have also set sql server 2000's secutiry as mixed modeInfact When I compile and run my projcet from visual studio it is fine, every thing works ok Then I publish my site to a folder on desktop, when publishing completed I right clicked the folder and in web sharing option I added alias = CMS Now when I open: http://localhost/CMS/Home.aspx, then it works fine infact all the pages that dont have SQL Server 2000 connectivity work fine, but as soon as I open some page that has connectivity with the database, it gives me error like: Login failed for user'USMAN/ASPNET' I wonder why this error only comes after publishing, there is nothing probemaltic when running it from Visual Studio, plz tell me what to do
HI, I am working on a project in which a user can upload his database to the server...then he is able to view all the schema or execute any kind of query. Then he goes to some other machine and login and wants to download the database. For example Alex have uploaded the database consisting of 1000 records to mysite. Then He goes to texas to find some oil wells. He is on another machine ... I download the database .... inseert new records and upload it back. Its an example basically I want to know how to include the users' uploaded into my sqlserver and when required publish with data on his machine... Thanks.
I've been working with the Database Publishing Wizard and have found what I initially thought was a bug but have decided is a rather nasty "feature". Or am I missing something? I have membership implemented in a live database. I took a backup and loaded it into a local database. I created a new table locally that is foreign-keyed off aspnet_roles, and added some data. Using the Publishing Wizard for a partial deployment, I followed the steps which seem perfectly clear to script out ONLY the new table and its data. The screens provide a nice GUI for selecting specific database objects, and I carefully chose the one new table. From good habits I looked at the script before deploying it. It drops and recreates aspnet_roles and aspnet_applications as well (and inserts the data from the development tables). Presumably this is because of the foreign key relationships. But there's no need to do so. What if I or another developer had added in some roles to the live table in the meantime? This script would blow them away. Am I missing an option with the Wizard that would script out only what is specified? I've tidied up the script (i.e. removed the undesirable sections) - but this seems to be a naughty wizard. Any thoughts?
We are trying to script out database schema and data with the Database Publishing Wizard and are having problems with output script trying to create views and stored procedures before the tables they depend on. I've seen discussion of this on their codeplex site and back in April 2007 they said that the CTP they just released fixed the problem - but we are still seeing it. Does anyone know a solution for this (beyond the obvious copy and pasting into the right order)? What we are trying to do is move the SQL and some basic reference data into source control and a CI process.
I received this publishing error a while back and can't think of a reason I would be receiving this error.
SQL error occurred. See entry specific information. Error : 21010, 01000, [Microsoft][ODBC SQL Server Driver][SQL Server]Removed 0 replicated transactions consisting of 0 statements in 6 seconds (0 rows/sec).
The error came just before another error:
SQL error occurred. See entry specific information. Information : 1205, 40001, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
I'm wondering what would cause these errors, if someone could point me in the right direction that would be great.
I have created reports in SQL Server reporting services(SSRS)and when i publish the report in the Localhost server it can be viewed in browser only in the INTRANET network but my intention is to generate the INTERNET URL of the report such that report published can be viewed in INTERNET outside this network..
I have developed a database application using c# and SQL Express 2005.
I have coded a connection string that works fine on the development machine but upon publishing to another machine I am getting the following error message:
Cannot open database "name of database" requested by the login. The login failed. Login Failed for user "machine nameuser name".
The remote machine has SQL server express installed.
Now on the development machine the machine name and user names are different to that on the remote machine. I am using Windows Auth. The application successfully runs on the remote machine. It even updates the same database (as mentioned in the issue above) on a different form which all connection strings etc were created automatically by c#. I'm pretty new to all this and don't know where to go from here. Any help would be greatly appritiated.
Anyone know how I can direct different reports in the same project to different folder on the SSRS site? I can get everyone to publish to one folder, but want to know if its possible on a report/report basis to different folders
