What Wrong With My Connection Code?
Apr 19, 2005
Below is my connection code..
Public Class clsConnect
Public Shared Function getConnection () AS SQLConnection
Dim strConn As String = "Data Source=PPS_SERVER;" & _
"Initial Catalog=eCommunity;User ID=sa;Password=pps"
Dim DBConn As SqlConnection
DBConn = New SqlConnection(strConn)
DBConn.Open()
Return DBConn
End Function
However when i run the web this error was appeared. what possibility of this problem?
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.Data.SqlClient.SqlException: SQL Server does not exist or access denied.Source Error:
Line 12: DBConn = New SqlConnection(strConn)
Line 13:
Line 14: DBConn.Open()
Line 15:
Line 16: return DBConn
View 2 Replies
ADVERTISEMENT
Aug 30, 2006
I am using MVWD 2005 Express and Sql Server 2005 Express. I am using SqlDataSource control and GridView control to disply a ata table, and let user to input data into the database through dropdownlist and TextBox. When I run the application I always get exception:"Conversion failed when converting character string to smalldatetime data type." I could not find anything wrong. Could anybody out there help me find out what's wrong with my code. Much appreciate it.Here is the code:<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False"DataSourceID="SqlDataSource2" DataKeyNames="DocumentID"><Columns><asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" /><asp:BoundField DataField="DocumentName" HeaderText="DocumentName" ReadOnly="True"SortExpression="DocumentName" /><asp:BoundField DataField="DateInput" HeaderText="Date" SortExpression="DateInput" /><asp:BoundField DataField="Comments" HeaderText="Comments" SortExpression="Comments" /><asp:BoundField DataField="DocumentCategory" HeaderText="Category" SortExpression="DocumentCategory" /><asp:CheckBoxField DataField="TopDoc" HeaderText="TopDoc" SortExpression="TopDoc" /></Columns><EmptyDataTemplate>There is no data to be displayed!</EmptyDataTemplate></asp:GridView><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConflictDetection="CompareAllValues"ConnectionString="<%$ ConnectionStrings:ClubSiteDB %>" DeleteCommand="DELETE FROM [Documents] WHERE [DocumentID] = @original_DocumentID AND [DocumentName] = @original_DocumentName AND [DateInput] = @original_DateInput AND [Comments] = @original_Comments AND [DocumentCategory] = @original_DocumentCategory AND [TopDoc] = @original_TopDoc"InsertCommand="INSERT INTO [Documents] ([DocumentName], [DateInput], [Comments], [DocumentCategory], [TopDoc]) VALUES (@DocumentName, @DateInput, @Comments, @DocumentCategory, @TopDoc)"OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Documents]"UpdateCommand="UPDATE [Documents] SET [DocumentName] = @DocumentName, [DateInput] = @DateInput, [Comments] = @Comments, [DocumentCategory] = @DocumentCategory, [TopDoc] = @TopDoc WHERE [DocumentID] = @original_DocumentID AND [DocumentName] = @original_DocumentName AND [DateInput] = @original_DateInput AND [Comments] = @original_Comments AND [DocumentCategory] = @original_DocumentCategory AND [TopDoc] = @original_TopDoc"><DeleteParameters><asp:Parameter Name="original_DocumentID" Type="Int32" /><asp:Parameter Name="original_DocumentName" Type="String" /><asp:Parameter Name="original_DateInput" Type="DateTime" /><asp:Parameter Name="original_Comments" Type="String" /><asp:Parameter Name="original_DocumentCategory" Type="Int32" /><asp:Parameter Name="original_TopDoc" Type="Boolean" /></DeleteParameters><UpdateParameters><asp:Parameter Name="DocumentName" Type="String" /><asp:Parameter Name="DateInput" Type="DateTime" /><asp:Parameter Name="Comments" Type="String" /><asp:Parameter Name="DocumentCategory" Type="Int32" /><asp:Parameter Name="TopDoc" Type="Boolean" /><asp:Parameter Name="original_DocumentID" Type="Int32" /><asp:Parameter Name="original_DocumentName" Type="String" /><asp:Parameter Name="original_DateInput" Type="DateTime" /><asp:Parameter Name="original_Comments" Type="String" /><asp:Parameter Name="original_DocumentCategory" Type="Int32" /><asp:Parameter Name="original_TopDoc" Type="Boolean" /></UpdateParameters><InsertParameters><asp:ControlParameter Name="Comments" Type="String" ControlID="TextBox2" /><asp:ControlParameter Name="DocumentCategory" Type="Int32" ControlID="DropDownList1" PropertyName="SelectedValue" /><asp:ControlParameter Name="TopDoc" Type="Boolean" ControlID="RadioButton1" PropertyName="Checked" /></InsertParameters></asp:SqlDataSource>Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.ClickDim savePath As String = "C: empuploads"Dim fileName As String = FileUpload1.FileName Dim dt As DateTime = DateTime.Now SqlDataSource2.InsertParameters.Add("DocumentName", fileName) SqlDataSource2.InsertParameters.Add("DateInput", dt)SqlDataSource2.Insert()If (FileUpload1.HasFile) ThensavePath += FileUpload1.FileName FileUpload1.SaveAs(savePath) Label1.Text = "Your file was uploaded successfully."DisplayFileContents(FileUpload1.PostedFile)ElseLabel1.Text = "You did not specify a file to upload."End IfEnd Sub
View 4 Replies
View Related
Mar 9, 2007
Hi im new and new to coding when i run the following code it gives me the following error can someone please help me and tell me where i am going wrong; "Invalid attempt to read when no data is present. " using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class dclogin : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void BTNlogin_Click(object sender, EventArgs e)
{
String strSql;
SqlConnection conn = new SqlConnection("server=cssql; database=movie_stream; Trusted_Connection = true");
strSql = "SELECT MS_Customer.email_address,MS_Customer.Password FROM MS_Customer WHERE email_address = " + "'" + Txtemail.Text + "'";
SqlCommand dbCommand4 = new SqlCommand();
dbCommand4.CommandText = strSql;
dbCommand4.Connection = conn;
conn.Open();
SqlDataReader myDataReader = dbCommand4.ExecuteReader();
myDataReader.Read();
if (Txtpassword.Text == Convert.ToString(myDataReader["Password"]))
{
Response.Redirect("customer.aspx");
}
else
{
lblMessage.Text = "Please check your Email address and password and try again";
}
//newlabel.Text = Convert.ToString(myDataReader["Password"]);
conn.Close();
} // end chkpwd
} // end class
View 8 Replies
View Related
Feb 4, 2005
SqlConnection CncDwBugNet = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand Sql = new SqlCommand();
Sql.Connection = CncDwBugNet;
Sql.CommandText = "INSERT INTO filtro(descricao, cod_projeto, cod_usuarioowner, cod_usuarioview) VALUES (@Descricao, @CodProjeto, @CodUsuarioOwner, @CodUsuarioView)";
Sql.Parameters.Add("@Descricao", SqlDbType.VarChar).Value = LocalFilter.Nome;
if (LocalFilter.Project != 0)
Sql.Parameters.Add("@CodProjeto", SqlDbType.Int).Value = LocalFilter.Project;
else
Sql.Parameters.Add("@CodProjeto", SqlDbType.Int).Value = null;
Sql.Parameters.Add("@CodUsuarioOwner", SqlDbType.Int).Value = (int)HttpContext.Current.Session["User"];
if (LocalFilter.User != 0)
Sql.Parameters.Add("@CodUsuarioView", SqlDbType.Int).Value = LocalFilter.User;
else
Sql.Parameters.Add("@CodUsuarioView", SqlDbType.Int).Value = null;
-----
this error appears when i run executenonquery method...
"Prepared statement '(@Descricao varchar(2),@CodProjeto int,@CodUsuarioOwner int,@Cod' expects parameter @CodProjeto, which was not supplied."
View 2 Replies
View Related
Feb 4, 2005
SqlConnection CncDwBugNet = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand Sql = new SqlCommand();
Sql.Connection = CncDwBugNet;
Sql.CommandText = "INSERT INTO filtro(descricao, cod_projeto, cod_usuarioowner, cod_usuarioview) VALUES (@Descricao, @CodProjeto, @CodUsuarioOwner, @CodUsuarioView)";
Sql.Parameters.Add("@Descricao", SqlDbType.VarChar).Value = LocalFilter.Nome;
if (LocalFilter.Project != 0)
Sql.Parameters.Add("@CodProjeto", SqlDbType.Int).Value = LocalFilter.Project;
else
Sql.Parameters.Add("@CodProjeto", SqlDbType.Int).Value = null;
Sql.Parameters.Add("@CodUsuarioOwner", SqlDbType.Int).Value = (int)HttpContext.Current.Session["User"];
if (LocalFilter.User != 0)
Sql.Parameters.Add("@CodUsuarioView", SqlDbType.Int).Value = LocalFilter.User;
else
Sql.Parameters.Add("@CodUsuarioView", SqlDbType.Int).Value = null;
-----
this error appears when i run executenonquery method...
"Prepared statement '(@Descricao varchar(2),@CodProjeto int,@CodUsuarioOwner int,@Cod' expects parameter @CodProjeto, which was not supplied."
View 1 Replies
View Related
Apr 25, 2006
I want to print out the table name and record count whenever a table has record(s), but the statement:
Print 'TableName: '+@TableName +' Row Count: '+CAST(@RCTR AS varchar)
never gets executed.
Any help is appreciated.
******************************************
SET NOCOUNT ON
DECLARE @TableName nvarchar(256), @SQL nvarchar(4000), @RCTR int
SET @TableName = ''
SET @RCTR = 0
WHILE @TableName IS NOT NULL
BEGIN
SET @TableName =
(
SELECT MIN(QUOTENAME(TABLE_NAME))
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
ANDQUOTENAME(TABLE_NAME) > @TableName
ANDOBJECTPROPERTY(
OBJECT_ID(QUOTENAME(TABLE_NAME)
), 'IsMSShipped') = 0
)
SET @SQL = ( 'select count(*) from ' + @TableName )
EXEC (@SQL)
SET @RCTR = @@ROWCOUNT
IF @RCTR > 0
Print 'TableName: ' + @TableName + ' Row Count: ' + CAST(@RCTR AS varchar)
END
*********************************
View 4 Replies
View Related
Mar 30, 2006
SELECT * FROM BOOK_CUSTOMER WHERE STATE='FL' OR STATE='NJ' AND REFERRED=NULL;
Im sorry for posting this, but the results just arent working out. Im trying to display user information if the customer lives in florida or new jersey and they cant have a referring user. I tried the above combination and managed to only list the people from fl and got one user who was referred. I also tried:
SELECT * FROM BOOK_CUSTOMER WHERE REFERRED=NULL AND STATE='FL' OR STATE='NJ';
And I only get people from nj and also get one referred user. Can anyone point out what im doing wrong?
View 5 Replies
View Related
Apr 25, 2006
I want to print out the table name and record count whenever a table has record(s), but the statement:
Print 'TableName: '+@TableName +' Row Count: '+CAST(@RCTR AS varchar)
never gets executed.
Any help is appreciated.
******************************************
SET NOCOUNT ON
DECLARE @TableName nvarchar(256), @SQL nvarchar(4000), @RCTR int
SET @TableName = ''
SET @RCTR = 0
WHILE @TableName IS NOT NULL
BEGIN
SET @TableName =
(
SELECT MIN(QUOTENAME(TABLE_NAME))
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
ANDQUOTENAME(TABLE_NAME) > @TableName
ANDOBJECTPROPERTY(
OBJECT_ID(QUOTENAME(TABLE_NAME)
), 'IsMSShipped') = 0
)
SET @SQL = ( 'select count(*) from ' + @TableName )
EXEC (@SQL)
SET @RCTR = @@ROWCOUNT
IF @RCTR > 0
Print 'TableName: ' + @TableName + ' Row Count: ' + CAST(@RCTR AS varchar)
END
*********************************
View 2 Replies
View Related
Jun 28, 2006
Here is part of the code:
CREATE table Fornecedor (
codintCONSTRAINT RI_79 PRIMARY KEY,
NCint,
nomeVARCHAR(100),
telefoneint,
moradaVARCHAR(100),
CONSTRAINT RI_78 CHECK(cod>0),
CONSTRAINT RI_80 CHECK(telefone>0),
CONSTRAINT RI_81 CHECK(telefone is not null),
CONSTRAINT RI_83 CHECK(morada is not null),
CONSTRAINT RI_85 CHECK(nome is not null),
CONSTRAINT RI_86 UNIQUE(nome),
CONSTRAINT RI_87 CHECK(NC>0),
CONSTRAINT RI_88 CHECK(NC is not null),
CONSTRAINT RI_89 UNIQUE(NC)
);
CREATE table Encomenda (
codintCONSTRAINT Fornecedor_não_existe_I FOREIGN KEY REFERENCES Fornecedor(cod),
número_ordemint,
lojaintCONSTRAINT Loja_não_existe_IV FOREIGN KEY REFERENCES Loja(loja),
data_pedidoCHAR(8),
data_previstaCHAR(8),
data_entregaCHAR(8),
CONSTRAINT RI_117_72 PRIMARY KEY(cod,número_ordem),
CONSTRAINT RI_71 CHECK(número_ordem>0),
CONSTRAINT RI_74 CHECK(data_pedido is not null),
CONSTRAINT RI_76 CHECK(data_prevista is not null),
CONSTRAINT RI_118 CHECK(loja is not null)
);
CREATE table Encomenda_Disco (
codintCONSTRAINT Encomenda_não_existe_I FOREIGN KEY REFERENCES Encomenda(cod),
número_ordemintCONSTRAINT Encomenda_não_existe_II FOREIGN KEY REFERENCES Encomenda(número_ordem),
refintCONSTRAINT Disco_não_existe_VIII FOREIGN KEY REFERENCES Disco(ref),
quantidadeint,
CONSTRAINT RI_121_122_123 PRIMARY KEY(cod,número_ordem,ref),
CONSTRAINT RI_90 CHECK(quantidade>0),
CONSTRAINT RI_91 CHECK(quantidade is not null)
);
Returns me this error when I try to create Encomenda_Disco:
There are no primary or candidate keys in the referenced table 'Encomenda' that match the referencing column list in the foreign key 'Encomenda_não_existe_I'.
I have checked this code for more than an hour, and I'm starting to get prety anoyed with this. Can someone be kind enough to point me the error? :)
View 3 Replies
View Related
Feb 5, 2007
CREATE PROCEDURE VerifyIfInvoiceExists
(@Invoice VARCHAR(50))
AS
DECLARE @DoesExist BIT
IF EXISTS (SELECT NULL FROM IPN_received
WHERE Invoice = @Invoice)
SELECT @DoesExist = 1
ELSE SELECT @DoesExist = 0
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I am getting an exception error. Any clue ?
View 3 Replies
View Related
Mar 30, 2007
select au_lname, au_fname,au_id
from authors
where 100 =all
(select royaltyper
from titleauthor
where titleauthor.au_id = authors.au_id)
This query uses database pubs. Why this code returns some au_id which is not in table titleauthor?
for example 527-72-3246 is not in titleauthor.
how to find the names of all authors who earn 100 percent royalty on all his/her books?
Thanks
=================================================
au_lnameau_fnameau_id
Blotchet-HallsReginald648-92-1872
CarsonCheryl238-95-7766
del CastilloInnes712-45-1867
GreeneMorningstar527-72-3246
LocksleyCharlene486-29-1786
McBaddenHeather893-72-1158
PanteleySylvia807-91-6654
SmithMeander341-22-1782
StraightDean274-80-9391
StringerDirk724-08-9931
WhiteJohnson172-32-1176
View 8 Replies
View Related
Jul 17, 2007
tickets = case when mrc.averageticket=null or mrc.averageticket=0, null, mccv.mccvamount/mrc.averageticket
end
Thanks
View 3 Replies
View Related
Jul 23, 2005
Hi AllI keep getting back VINET and not Lilas...can someone point me in theright direction?Thanks a lotDECLARE @idoc intDECLARE @doc varchar(1000)SET @doc ='<ROOT><CustomerID>VINET </CustomerID><CustomerID>Lilas</CustomerID></ROOT>'--Create an internal representation of the XML document.EXEC sp_xml_preparedocument @idoc OUTPUT, @doc-- Execute a SELECT statement that uses the OPENXML rowset provider.SELECT *FROM OPENXML (@idoc, '/ROOT',2)WITH (CustomerID varchar(100) )
View 5 Replies
View Related
Jul 13, 2007
Hi
whats wrong here?
it gives this error
c:documents and settings910287my documentsvisual studio projects
eport project1FCAT READING LEVELS.rdl The color expression for the textbox €˜textbox8€™ contains an error: [BC30201] Expression expected.
=IIF
(Fields!SCORE_Previous.Value < Fields!SCORE_Current.Value ,€™red€™,
(Fields!SCORE_Previous.Value > Fields!SCORE_Current.Value , €˜green€™,€™yellow€™))
View 2 Replies
View Related
Sep 12, 2007
I keep getting the error "Invalid attempt to read when no data is present" when trying to query a table in my SQL DB. I have checked and rechecked and the table name and column names within it are spelled correctly. There are only three records in the database, they all have data in them, and the code in Country.Text precisely matches the data in the Country field in one of the records.
It's worth mentioning that when I use Visual Studio 2005's little direct SQL query tool to build and run the following SQL statement that it works properly:
SELECT Country, WordForStateFROM data_CountriesWHERE (Country = N'Jordan')
I am perplexed. Any ideas anybody...here is the code...?
Dim SelectSQL_Countries As String
SelectSQL_Countries = "SELECT * FROM data_Countries "
SelectSQL_Countries &= "WHERE Country='" & Country.Text & "'"Dim con_Countries As New SqlConnection(ConfigurationManager.ConnectionStrings("MySiteMainDB").ConnectionString)
Dim cmd_Countries As New SqlCommand(SelectSQL_Countries, con_Countries)Dim reader_Countries As SqlDataReader
Try
con_Countries.Open()
reader_Countries = cmd_Countries.ExecuteReader()StateID.Text = reader_Countries("WordForState")
reader_Countries.Close()Catch err As Exception
lblResults.Text = err.Message
Finally
con_Countries.Close()
End Try
View 3 Replies
View Related
Jun 25, 2004
I cant get this to work for some reason i am clueless, here is my code:
And here is the error:
//////////////////////////////////////////////////////////
ADODB.Recordset error '800a0e79'
Operation is not allowed when the object is open.
/home/details.asp, line 106
/////////////////////////////////////////////////////////
Begin Code:
/////////////////////////////////////////////////////////
<%
Color = "#05D1B8"
rma_id = Request.QueryString("rma_id")
SQL = "SELECT * FROM TBL_RMA WHERE RMA_ID='"&rma_id&"'"
rs.open SQL, Conn
If Not rs.BOF Then
%>
<table>
<tr>
<td bgcolor="<%=Color%>">RMA ID</td>
<td bgcolor="<%=Color%>">DATE GENERATED</td>
</tr>
<tr>
<td><%=rs("RMA_ID")%></td>
<td><%=rs("RMA_DATE_GENERATED")%></td>
</tr>
</table>
</br>
<table>
<tr>
<td bgcolor="<%=Color%>">RMA STATUS</td>
</tr>
<tr>
<td><%=rs("RMA_STATUS_ID")%></td>
</tr>
</table>
<br>
<table>
<tr>
<td bgcolor="<%=Color%>">PART NUMBER</td>
<td bgcolor="<%=Color%>">DESCRIPTION</td>
<td bgcolor="<%=Color%>">SERIAL NUMBER</td>
</tr>
<tr>
<td><%=rs("RMA_PRODUCT_ID")%></td>
<td><%=rs("RMA_PRODUCT_ID_DESCRIPTION")%></td>
<td><%=rs("RMA_SERIAL_NUMBER")%></td>
</tr>
</table>
<br>
<table>
<tr>
<td bgcolor="<%=Color%>">RECEIVED DATE</td>
<td bgcolor="<%=Color%>">PRIORITY</td>
<td bgcolor="<%=Color%>">TRANSACTION</td>
</tr>
<tr>
<td><%=rs("RMA_PRODUCT_ARRIVAL_DATE")%></td>
<td><%=rs("RMA_PRIORITY_ID")%></td>
<td><%=rs("RMA_TRANSACTION_TYPE_ID")%></td>
</tr>
</table>
<table>
<tr>
<td bgcolor="<%=Color%>">PROBLEM DESCRIPTION</td>
</tr>
<tr>
<td><%=rs("RMA_PROBLEM_DESCRIPTION")%></td>
</tr>
</table>
<br>
<table>
<tr>
<td bgcolor="<%=Color%>">TO MFG</td>
<td bgcolor="<%=Color%>">VIA</td>
<td bgcolor="<%=Color%>">MFG RA</td>
</tr>
<tr>
<td><%=rs("RMA_TO_MFG_DATE")%></td>
<td><%=rs("RMA_TO_MFG_VIA")%></td>
<td><%=rs("RMA_TO_MFG_RA")%></td>
</tr>
<tr>
<td bgcolor="<%=Color%>">FROM MFG</td>
<td bgcolor="<%=Color%>">VIA</td>
</tr>
<tr>
<td><%=rs("RMA_FROM_MFG_DATE")%></td>
<td><%=rs("RMA_FROM_MFG_VIA")%></td>
</tr>
</table>
<table>
<tr>
<td bgcolor="<%=Color%>">PROBLEM FOUND</td>
</tr>
<tr>
<td><%=rs("RMA_PROBLEM_FOUND")%></td>
</tr>
</table>
<%
Else
Response.Redirect("http://usautomatic.dyndns.org/home/failed.asp")
End If
If rs.EOF Then
rs.Close
End If
%>
<%
rma_id = Request.QueryString("rma_id")
CUSTOMER_ID = session("CUSTOMER_ID")
SQL = "SELECT * FROM tracking_export.csv WHERE CUSTOMERID='"&CUSTOMER_ID&"' AND RMA_ID='"&rma_id&"'"
rs.open SQL, Conn2
If Not rs.BOF Then
%>
<tr>
<td><a href="http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&sort_by=status&tracknums_displayed=5&TypeOfInquiryNumber=T&loc=en_US&InquiryNumber1=<%=rs("ShipmentID")%>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&AgreeToTermsAndConditions=yes&track.x=32&track.y=6">Track</a></td>
</tr>
<%
Else
Response.Redirect("http://usautomatic.dyndns.org/home/failed.asp")
End If
If rs.EOF Then
RS.Close
End If
%>
/////////////////////////////////////////////////////////
Any help would be appreciated.
Thanks,
X-Centric
View 6 Replies
View Related
Dec 7, 2006
CREATE PROCEDURE Page4
(
@startRowIndex int,
@maximumRows int
)
AS
DECLARE @first_id int, @startRow int
-- A check can be added to make sure @startRowIndex isn't > count(1)
-- from employees before doing any actual work unless it is guaranteed
-- the caller won't do that
-- Get the first employeeID for our page of records
SET ROWCOUNT @startRowIndex
SELECT @first_id = CAST(DATE as int) FROM TOPIC
-- Now, set the row count to MaximumRows and get
-- all records >= @first_id
SET ROWCOUNT @maximumRows
SELECT * FROM TOPIC WHERE CAST(DATE as int) >= @first_id
SET ROWCOUNT 0
GO
I have the date field clustered DESC
The code always starts at the same place but maximum rows always adjusts to my input unlike the startrowindex. What am I doing wrong?
View 2 Replies
View Related
Feb 7, 2007
select sub1.*, case sub1.mdiff when sub1.mdiff<12 then 1 else 0 end as flag
error msg by query analyser
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '<'.
Server: Msg 156, Level 15, State 1, Line 12
Incorrect syntax near the keyword 'as'.
Thanks
Jeff
View 2 Replies
View Related
Dec 13, 2007
CREATE TABLE [dbo].[TestTable]( [Column1] [int] (SQL_Latin1_General_Cp437_BIN) not null, [Column2] [varchar] (7) not null, [Column3] [bit] not null, [Column4] [int] Null, [Column5] [varchar] (12) Null, [Column6] [varchar] (24) Null, [Column7] [varchar] (56) Null ) ON [Primary]
View 1 Replies
View Related
Dec 2, 2007
Hi
I am running this piece of code to execute a package programatically and Yet I get Failure. What could be Wrong with this. If so can anyone tell me How I can debug in SSIS.
Imports Microsoft.SqlServer.Dts.Runtime
Module Module1
Sub Main()
Dim pkgLocation As String
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult
pkgLocation = _
"c:ssisintegration services project2integration services project2Package.dtsx"
pkg = app.LoadPackage(pkgLocation, Nothing)
pkgResults = pkg.Execute()
Console.WriteLine(pkgResults.ToString())
Console.ReadKey()
End Sub
End Module
View 3 Replies
View Related
Nov 3, 2007
Hi,I have code on a page to update one table and insert info into another, but I cant make it work. I am new to coding and i think there are many mistakes. Please can someone pick out a few that need to be changed for the page to work.Code:private bool ExecuteUpdate(int quantity){ SqlConnection con = new SqlConnection(); con.ConnectionString = "ConnectionString"; con.Open(); SqlCommand command = new SqlCommand(); command.Connection = con; TextBox TextBox1 = (TextBox)FormView1.FindControl("TextBox1"); Label labname = (Label)FormView1.FindControl("Label3"); Label labid = (Label)FormView1.FindControl("Label13"); command.CommandText = "UPDATE Items SET Quantityavailable WHERE productID='@productID' = " + TextBox1.Text + command.ExecuteNonQuery(); return true; con.Close();} private bool ExecuteInsert(String quantity) { SqlConnection con = new SqlConnection(); con.ConnectionString = "ConnectionString"; con.Open(); SqlCommand command = new SqlCommand(); command.Connection = con; TextBox TextBox1 = (TextBox)FormView1.FindControl("TextBox1"); Label labname = (Label)FormView1.FindControl("Label3"); Label labid = (Label)FormView1.FindControl("Label13"); command.CommandText = "INSERT Transactions SET Usersname = @UserName" + "; INSERT Transactions SET Itemid WHERE productID='@productID' = @productID; INSERT Transactions SET itemname = @Itemsname" + "; INSERT Transactions SET Date WHERE productID='@productID' = " + DateTime.Now.ToString() + "; INSERT Transactions SET Qty WHERE productID='@productID' = " + TextBox1.Text; command.Parameters.Add("@UserName", System.Web.HttpContext.Current.User.Identity.Name); command.Parameters.Add("@Itemsname", labname.Text); command.Parameters.Add("@productID", labid.Text); command.ExecuteNonQuery(); return true; con.Close(); }protected void Button2_Click(object sender, EventArgs e){ TextBox TextBox1 = FormView1.FindControl("TextBox1") as TextBox; ExecuteUpdate(Int32.Parse(TextBox1.Text) ); ExecuteInsert(Int32.Parse);} Current error message is:The best overloaded method match for 'detailproview.ExecuteInsert(string)' has some invalid argumentsto Line 74: ExecuteInsert(Int32.Parse); Thanks if someone can help!Jon
View 3 Replies
View Related
Oct 23, 2005
Hi, just learning SQL2000.I have this code: mSQL = "UPDATE Contactpersonen SET Naam=? WHERE ContactpersoonID=?" Command = New SqlClient.SqlCommand(mSQL, C_CP) Command.Parameters.Add("Naam", txtNaam.Text) Command.Parameters.Add("CPID", SqlDbType.UniqueIdentifier).Value = m_CP_IDwhere m_CP_ID is defined as a GUID in: Public Property m_CP_ID() As Guid Get If Not viewstate("m_CP_ID") Is Nothing Then Return viewstate("m_CP_ID") End If 'Return 0 End Get Set(ByVal Value As Guid) viewstate("m_CP_ID") = Value End Set End PropertyWhen running the app I got this error:Server Error in '/4D' Application.--------------------------------------------------------------------------------
Line 1: Incorrect syntax near 'Naam'. Line 1: Incorrect syntax near '?'. (points to mSQL above)I know it has something to do with the GUID, but I cannot guess what.Help is appreciated, Ger.
View 2 Replies
View Related
Oct 24, 2005
Hi, I have the following code: Dim RowLoopIndex As Integer DsFuncties.Clear() A_Functies.Fill(DsFuncties) For RowLoopIndex = 0 To (DsFuncties.Tables("Functies").Rows.Count - 1) If DsFuncties.Tables("Functies").Rows(RowLoopIndex).Item("FunctieID") = Func_ID Then Func_naam = (DsFuncties.Tables("Functies").Rows(RowLoopIndex).Item("Functienaam")) DDL_Functie.SelectedIndex = RowLoopIndex + 1 Exit For End If NextFunc_ID has been declared as follows: Public Property Func_ID() As Guid Get If Not viewstate("Func_ID") Is Nothing Then Return viewstate("Func_ID") End If End Get Set(ByVal Value As Guid) viewstate("Func_ID") = Value End Set End PropertyOn the red line I got the following tooltip (error):Operator '=' is not defined for types 'System.Object' and 'System.Guid'.How can I define '=' and eg. '&' for type System.Guid ???? Or another solution ??Help is appreciated, Ger.
View 3 Replies
View Related
Mar 21, 2007
Hi everyone
when i run the below code using sql2000 ,the error was occured,anyone can tell me what's wrong and how to solve it thanks
the error is :
Appointed conversion is invalidation
InvalidCastException: Appointed conversion is invalidation] PhotoManager.GetPhotos(Int32 AlbumID) +571
[TargetInvocationException: ] System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +358 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29 System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +482 System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2040 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +41 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
well i plaster the source's code in the below :
1�the test.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="test" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>æ— æ ‡é¢˜é¡µ</title></head><body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1" AutoGenerateColumns="False"> <Columns> <asp:BoundField DataField="AlbumCategoryID" HeaderText="AlbumCategoryID" ReadOnly="True" SortExpression="AlbumCategoryID" /> <asp:BoundField DataField="Caption" HeaderText="Caption" ReadOnly="True" SortExpression="Caption" /> <asp:BoundField DataField="LastModified" HeaderText="LastModified" ReadOnly="True" SortExpression="LastModified" /> <asp:BoundField DataField="ViewCount" HeaderText="ViewCount" ReadOnly="True" SortExpression="ViewCount" /> <asp:BoundField DataField="PhotoID" HeaderText="PhotoID" ReadOnly="True" SortExpression="PhotoID" /> <asp:BoundField DataField="Location" HeaderText="Location" ReadOnly="True" SortExpression="Location" /> <asp:BoundField DataField="AlbumID" HeaderText="AlbumID" ReadOnly="True" SortExpression="AlbumID" /> </Columns> </asp:GridView> <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetPhotos" TypeName="PhotoManager"> <SelectParameters> <asp:Parameter DefaultValue="1" Name="AlbumID" Type="Int32" /> </SelectParameters> </asp:ObjectDataSource> </div> </form> </body></html>
2�the PhotoManager's class is : public static List GetPhotos(int AlbumID)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Personal"].ConnectionString))
{
using (SqlCommand command = new SqlCommand("GetPhotos", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@AlbumID", AlbumID));
command.Parameters.Add(new SqlParameter("@IsPublic", 1));
connection.Open();
List list = new List();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Photo temp = new Photo(
(int)reader["PhotoID"],
(int)reader["AlbumID"],
(string)reader["Caption"],
(string)reader["Location"],
(int)reader["ViewCount"],
(DateTime)reader["LastModified"],
(int)reader["AlbumCategoryID"]
);
list.Add(temp);
}
}
return list;
}
}
}
3�photo.cs is using System;
using System.Collections;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Drawing.Drawing2D;
using System.Drawing.Imaging;
using System.IO;
using System.Web;
public class Photo
{
private int _id;
private int _albumid;
private string _caption;
private string _location;
private int _ViewCount;
private DateTime _LastModified;
private int _AlbumCategoryID;
public int PhotoID { get { return _id; } }
public int AlbumID { get { return _albumid; } }
public string Caption { get { return _caption; } }
public string Location
{
get
{
return _location;
}
}
public int ViewCount
{
get
{
return _ViewCount;
}
}
public DateTime LastModified
{
get
{
return _LastModified;
}
}
public int AlbumCategoryID
{
get
{
return _AlbumCategoryID;
}
}
public Photo(int id, int albumid, string caption, string location, int viewcount, DateTime lastmodified,int AlbumCategoryID)
{
_id = id;
_albumid = albumid;
_caption = caption;
_location = location;
_ViewCount = viewcount;
_LastModified = lastmodified;
_AlbumCategoryID = AlbumCategoryID;
}
}
4�the StoredProcedure
"GetPhotos" is : ALTER PROCEDURE [dbo].[GetPhotos] @AlbumID int, @IsPublic bitAS SELECT [Photos].[AlbumID],[Photos].[PhotoID],[Photos].[Caption],[Photos].
[Location],[Photos].[ViewCount],[Photos].[LastModified], [Albums].[AlbumCategoryID]
FROM [Photos] LEFT JOIN [Albums] ON [Albums].[AlbumID] = [Photos].[AlbumID] WHERE [Photos].[AlbumID] = @AlbumID AND ([Albums].[IsPublic] =@IsPublic OR [Albums].[IsPublic] = 1) ORDER BY [Photos].[Caption] ASC
RETURN
View 1 Replies
View Related
Jul 28, 2005
In the "Example: Detecting a Poison Message" section, it reads: This Transact-SQL example shows a simple, stateless service that includes logic for handling poison messages. Before the stored procedure receives a message, the procedure saves the transaction. When the procedure cannot process a message, the procedure rolls the transaction back to the save point. The partial rollback returns the message to the queue while continuing to hold a lock on the conversation group for the message.
View 1 Replies
View Related
Sep 22, 2005
oConn = New SqlClient.SqlConnection
oConn.ConnectionString = "user id=MyUserID;data source=MyDataSource;persist security info=False;initial catalog=DBname;password=password;"
oCmd = New SqlClient.SqlCommand
oCmd.Connection = oConn
oCmd.CommandType = CommandType.StoredProcedure
oCmd.CommandText = "TestStdInfo"
'parameters block
oParam1 = New SqlClient.SqlParameter("@intSchoolID", Me.ddlSchl.SelectedItem.ToString())
oParam1.Direction = ParameterDirection.Input
oParam1.SqlDbType = SqlDbType.Int
oCmd.Parameters.Add(oParam1)
oParam2 = New SqlClient.SqlParameter("@dob", Convert.ToDateTime(Me.txbBirth.Text))
oParam2.Direction = ParameterDirection.Input
oParam2.SqlDbType = SqlDbType.DateTime
oCmd.Parameters.Add(oParam2)
oParam3 = New SqlClient.SqlParameter("@id", Me.txbID.Text)
oParam3.Direction = ParameterDirection.Input
oParam3.SqlDbType = SqlDbType.VarChar
oCmd.Parameters.Add(oParam3)
oConn.Open()
daStudent = New SqlClient.SqlDataAdapter("TestStdInfo", oConn)
dsStudent = New DataSet
daStudent.Fill(dsStudent) 'This line is highlighted when error happens
oConn.Close()The error I am getting :Exception Details: System.Data.SqlClient.SqlException: Procedure 'TestStdInfo' expects parameter '@intSchoolID', which was not supplied.I am able to see the value during debugging in the autos or command window. Where does it dissapear when it comes to Fill?Could anybody help me with this, if possible fix my code or show the clean code where the procedure called with multiple parameters and dataset filled.Thank you so much for your help.
View 2 Replies
View Related
Feb 14, 2008
Hi All,
I am getting the following error if I am using the package "Transaction Option=Required" while running through Sql Job:
The AcquireConnection method call to the connection manager "<connection name>" failed with error code 0xC0202009.
while I running the SSIS package on BI environment, I am getting the following error:
[Connection manager "<connection name>"] Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00A "Unable to enlist in the transaction.".
I know the alternative solution is to make the "Transaction Option=Supported", but in my case I have run the whole flow in a single transaction. I came to know that this has been fixed in the service pack1(ref. to http://support.microsoft.com/kb/914375). FYI.. some time it was running successful.
I have taken all the necessary step to run the SSIS package in a distributed transaction(like the steps for MSDTC) and also created the package flow in a sequence.
I was going through the link - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=160340&SiteID=1 but all those didn't solve my problem.
If anyone can help me it will be great. or it is a bug in SSIS?
Thanks.
Jena
View 5 Replies
View Related
Mar 7, 2006
Hello, I have a sql 2005 server, and I am a developer, with the database on my own machine. It alwayws works for me but after some minutes the other developer cant work in the application
He got this error
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.1.140]
and When I see the log event after that error, it comes with another error.
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.1.140]
He has IIS5 and me too.
I created a user on the domain called ASPSYS with password, then in the IIS on anonymous authentication I put that user with that password, and it works, on both machines.
and in the connection string I have.
<add key="sqlconn" value="Data Source=ESTACION15;Initial Catalog=GescomDefinitiva;Integrated Security=SSPI; Trusted_Connection=true"/>
I go to the profiler, and I see that when he browses a page, the database is accesed with user ASPSYS, but when I browse a page, the database is accesed with user SElevalencia.
Thats strange.
The only way that the other developer can work again on the project is to restart the whole machine. He has windows xp profession, I have windows 2000.
If you want me to send logs please tellme
View 20 Replies
View Related
Jan 5, 2007
Hi
My C# application has a DataGridView which is bound to a DataSet. I used Visual Studio to add/configure the data source. Everything works fine on my computer. When I try to run the application on another computer I can't connect to the database, because it uses a wrong connection string.
How can I make a specific connection/connection string permanent for a specific application?
Thanks.
View 6 Replies
View Related
Nov 5, 2007
Hi
Im writing a program that stores data to SQL server 2005.
Program writen on VC++ 2003.
Code is very simple and it works ok if server runs and parameters are ok.
try
{
HRESULT hr = m_Connection.CreateInstance(__uuidof(ADODB::Connection));
String ConnectionStr;
ConnectionStr.Format(_T("Provider=sqloledb;Data Source=%s;Initial Catalog=MyDB;User Id=%s;Password=%s;"),m_Server.c_str(),m_Username.c_str(),m_Password.c_str());
_bstr_t bstrConnection(ConnectionStr.c_str());
m_Connection->CursorLocation = ADODB::adUseClient;
hr = m_Connection->Open(bstrConnection, L"", L"", ADODB::adConnectUnspecified);
}
catch(_com_error &e)
{
_bstr_t Description = e.Description();
}
But!
if i give wrong paramterer for Data Source , it may happen if user configures it and misprints it, or if server goes offline for some reason, program just hangs on m_Connection->Open and never gives exception as it should.
Any ideas what wrong?
Thanks.
View 4 Replies
View Related
Mar 24, 2008
I am using SSIS 2005 on Windows 2003 server. Using Excel Source to dump the data for staging database.
I am getting following error while I execute it through BI studio's execute button.
Please help.
- Sachin
View 2 Replies
View Related
Mar 11, 2008
I have deployed my packages into Sql Server and I am using Configuration File. As my Data Source is Excel, I have changed the connection string during deployment with Server Path. But I am getting the following errors. Actually the File Exist in Path. May I know What is cause of the issue? Do I need to give any permission to execute the package.
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
component "Excel Source Service Contract Upload" (1) failed validation and returned error code 0xC020801C.
One or more component failed validation.
There were errors during task validation.
DTS_E_OLEDBERROR, Error Code: 0x80004005 Source: "MS JET DB Engine" Description : Path is not valid
View 27 Replies
View Related
Dec 27, 2007
Hi,
I am working on SQL Server 2005 (x64) with Windows Server 2003 (x64) operating system. I am having a major issue in SSIS. Here is the detailed explanation of the issue :
I have an EXCEL file in 2003 / 2007 version. It contains some data. I want to import the data using SSIS into SQL Server 2005 (x64) database table. I have taken "EXCEL FILE SOURCE" and "SQL Server DESTINATION". It was failed on importing data. Surprisingly it works fine in SQL Server 2005 (x32). Can you please explain why it is NOT woking on (x64) ?
Here is the error code i am getting:
[Excel Source [1]] Error: The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.
Appreciate your time and patience !!
Thanks
View 3 Replies
View Related
