Viewing MSSQL RS Reports From Web App ?
Mar 16, 2010
We are trying to view reports with MS SQL 2008 reporting services for a custom web application.We have MS SQL 2008 Express full install. We've tested the application from our IDE and it works. Once published to the web server we get the following error:
404 - File or directory not found.The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.I syuspect this may have something to to with IIS 7.0 setting, since it works in the IDE but not on the server, but I have been unable to figure out what the issue is.Here is our code.[code].....
View 3 Replies
ADVERTISEMENT
Aug 26, 2011
I am creating reports in Crystal Reports that is integrated within Visual Studio 2008, and I noticed that some of the features are disabled. One is the ability to link tables with a Right Outer Join or Full Outer Join. I also cannot "Show SQL Query" in Crystal Reports. Is this something I can enable or do I have to purchase or upgrade?
View 1 Replies
Dec 9, 2010
Basically, I am looking for a method on how to preview reports from a datagrid or it can be from the access database which populates the data to the datagrid (then displays this in the datagridview) in vb.net vs 2010.I believe there are two methods using the ReportViewer or using Crystal Reports, but so far, I have no idea how to get them to work. The first idea would be favourable - using the data from a datagridview (which may of already been sorted, filter etc) and be able to produce a report on that.
View 1 Replies
Apr 28, 2011
i am developing an application in vb.net having crystal reportsi have stored all my reports in a folder called report in my applicationbut initally when i executed i got a error msg like the report doesnot exixts in debug folderso i copied all the reports from report folder to debug folder & its workingany changes that i mke in report folder needs to be copied into the debug folder alsois it possible that the reports be executed from reports folder only & not from debug folder as everytime i need to make changes in the debug folderhow can i chnage the path to reports folder
View 1 Replies
Dec 1, 2011
How can we create a report in vb.net without using any crystal reports
View 11 Replies
Jun 21, 2010
I am working on VB.NET(Visual studio 2008)..I completed developing my application and i need to deploy the application. I tried it and faced problems in some areas like adding crystal reports to the setup and deployment. I created a setup file to my application and everything is fine except crystal reports...its showing the error like; An error occurred in crystalDecisions.Reports, crystalEngine threw exception.
View 2 Replies
Jun 7, 2011
I am using Visual Studio 10 Languague VB
It is web based and conects to remote SQL Server If i run a query on database connecting using Sql Server management studio this query give correct results which is to find minimum value in a column called TIME1.
The query on database is SELECT MIN(TIME1) AS Fastest
FROM Athletes
WHERE (ATHLETE = 'Joe Bloggs') AND (Session = '600m')
This works great showing correct result under Alias column name Fastest
My problrm is i want to get this result from code behind page
here is Query in code behind page
SqlDataSource1.SelectCommand = "SELECT MIN(TIME1) from Athletes WHERE (Session ='600m') AND (ATHLETE = 'Joe Bloggs')"
I need to extract min value of TIME1 and pass it to a variable
View 1 Replies
Dec 15, 2011
i have problem with connecting Vb.Net with MSSQL database i have a shared host for windows server and i have to insert each ip trying to connect with the MSSQL database through my program and its impossible to insert each ip to the Whitelist so while i was thinking for a solution an idea came to me that i can change the ip address of any user for the program to a unique ip such as ( 174.162.45.23 ) and i whitelist this ip i do this or a solution for this problem because i cant continue my project with this problem
View 10 Replies
Apr 6, 2012
Dim connetionString As String
Dim cnn As OleDbConnection
connetionString = "Provider=SQLOLEDB; Data Source=****; Initial Catalog=****; User ID=***; Password='****';"
cnn = New OleDbConnection(connetionString)
Try
cnn.Open()
[Code]...
I have been working with this for awhile, and I can't get it to work, I have all the correct names where the connection string is, but I just can't get it to work. It is telling me the server does not exist, but I am using a hosted solution that I know is up.
View 8 Replies
Jun 13, 2009
Am using vb.net 2005. when vb starts i try to connect to mssql server uut i cant. unlike mssql7 desktop edition there is a consol in the start menu where one can configure mssql, creat database, tables etc.
View 5 Replies
Mar 5, 2009
Code:
Imports System.Data.SqlClient
Dim SQLStr, ConnString As String
[code].....
View 3 Replies
May 4, 2012
After I upgreaded from MSSQL 12 RC0 to 12 day & month began switching in my database
I have a few columns in my datebase of datetime: they start as YYYY-DD-MM.[code]...
View 4 Replies
Dec 10, 2009
I wish to save an image in a mssql database.My function is: Public Sub CalcNomogram(ByVal uid As String, ByVal mNavn As String, ByVal mId As Integer, ByVal ruhed As Single, _ByVal valgteDim As String, ByVal img1 As Image)
[Code]...
View 3 Replies
Feb 10, 2012
[Code]...
If its saved succsessufully to display message that is saved. I want just little program to edit 1 table,
View 3 Replies
Jun 27, 2012
I need to write a String Array to a field in a MSSQL Database, however, I'm not sure how to do the connection from javascript to the backend VB.NET to send the data to the DB. Do I need to create a web service and use ajax/json?
View 1 Replies
Jan 13, 2011
I'm trying to view dbf on datagrid but fail. My script is like this:
Imports System.Data.OleDb
[Code]...
View 5 Replies
Jan 12, 2010
I'm watching tutorials about creating Web Site and about controls.I think I added SQL Database to the project (it's not empty) properly. Suppose it has two columns: FirstName, LastName.I have TextBox1, TextBox2 and Button1 on the web site form.I enter any integer number (5, 10, 15 or whatever) into TextBox1. I want to press Button1 and get a value of 5th person (10th, 15th or whatever) from SQL Database into TextBox2.Who can help me with that? Should I read about ADO.NET and use something from there?Later I want to use VB for work with that strings.
View 2 Replies
Jun 21, 2010
people plix help me with ASP code for login. am using MSSQL i want users who have registered using their emailadress and passwords to be able to login.
View 1 Replies
May 30, 2012
I have designed a project that connects to MsSql Server 2008. The local machine that I use to create the software is able to connect to the database but when I try connect from another machine remotely, It doesn't find the server.This is the connection string I'm using Dim Connection As New SqlConnection("Server=MyServer-PC;Database=MyDatabase;Integrated Security=True")
View 3 Replies
May 31, 2012
I created a project in vb.net and I'm able to connect to an Mssql server remotely using the host machine name. However, I can't connect using the IP Address. This is my connection String.
Server=HostIpAddress;Database=Mydatabase;uid='UserID';password='MyPassword'
View 1 Replies
Feb 17, 2009
i am trying to create an vb.net program to transfer or copy tables from my access database to an MSSQL DB.I got it working to copy from MSSQL to access but not the other way around.
View 7 Replies
Oct 2, 2011
how to backup my database in local drive when i press a backup button in my vb2010 application...
View 6 Replies
Dec 15, 2011
I need to save pictures in my database, my database is MSSQL as of now, my code for getting the picture is this:
Private Sub browsepic_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles browsepic.Click
With dialogpic 'Open File Dialog sa toolbox
.InitialDirectory = "C:UsersCAMILLEPictures"
[code]....
how to save the picture and how to retrieve it?
View 12 Replies
Jun 22, 2011
I have one textbox basically the user is going to enter in a 9 digit number or letters. From there I want to have a buttonclick event that validates this against 2 columns in a MSSQL Database. First to check if the number exists, next to check if it is active or inactive.
There are about 27000 rows of numbers so my main question is what is the best approach to handling something like this.
Should I create a view and validate in the click event. Should I create a stored procedure in sql that takes an input parameter and call it in the click event.
I was also reading about storing the information in a dataset however with that many records i am assuming that is going to be a slow process.
View 1 Replies
Jan 14, 2011
is anybody know how to make check MSSQL server status with port using VB.net? i'm newbie about this..
View 4 Replies
Oct 23, 2009
I have 2 problems, this may sound odd but is there an easy way to store and read vba/vbs inside a database (MSSQL)? Second problem, how to create vba/vbs so i can use it to interact with my own software?
View 7 Replies
Aug 1, 2010
I am aware about the COPY ALWAYS or DO NOT COPY features for files and database files.But my problem is the following:This is the
Public Sub New()
' This call is required by the designer.
InitializeComponent()
Dim mhkos As Integer = 1
Dim ypsos As Integer = 1
[code].....
where the MDF file is located I am getting an error...as the MSSQL server does not allow even to copy the file to an other location.
View 5 Replies
Dec 5, 2009
I am creating basic slideshow form to finish off an app I am writing. I have been at it all day finishing off the main app and am getting very tired now!!
Anyway, I have a form (which is called by another form) with just a Picturebox and a Timer on it. I use the following code to read in all the images in a folder:
[code]...
As this just points to the array of images and not a single image and there is no way of telling it to move to the next image each time.
View 3 Replies
Dec 1, 2011
I have a program to add and remove sites from the HOST file. So, sorta like a site blocker. I kinda wish I had a chicken in a police outfit giving the stop! hand sign and name it cock blocker :P anyways... To read what sites/ip's are blocked I'm just reading the HOST file in a read only textbox. I was wanting to know if I can read everything but the crud at the top of the file(Describing how to edit the HOST file manually). How could I do that? Here is my code I'm using to read the HOST file:
Dim ReadItem As String = String.Empty
IO.File.Exists("c:windowssystem32driversetchosts")
ReadItem = IO.File.ReadAllText("c:windowssystem32driversetchosts")
[Code].....
View 3 Replies
Nov 4, 2009
Is it possible to view video in a Picturebox? if you do know then reply..G peter.
View 3 Replies
