Dear All,
i'm getting this error while trying to connect to any of the servers.
on that perticular system, sqlserver2000, 2005 client tools are there.
the error is :
a connection was established successfully to the server but an error was occured prelogin handshake. how can i overcome this?
thank you very much
Vinod
Even you learn 1%, Learn it with 100% confidence.
i get this error when i try to connect to sql server 2005 developer edition with the latest JDBC.
sql string =>> jdbc:sqlserver://localhost:1434;databaseName=c1 Elvis elvis
SQL STATE: 08S01
ERROR CODE: 0
MESSAGE: An I/O error occurred while receiving the TDS prelogin response.
And the stacktrace is:
com.microsoft.sqlserver.jdbc.SQLServerException: An I/O error occurred while receiving the TDS prelogin response.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.DBComms.Prelogin(Unknown Source)
at com.microsoft.sqlserver.jdbc.DBComms.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
and is called :connection=DriverManager.getConnection(con, user, password);
Please tell me what is wrong ? Because in other part of the code it works fine !
What is this "I/O error occurred while receiving the TDS prelogin response" ?
Hi,
Anyone know what I'm doing wrong? My JDBC is erroring. I'm using the Microsoft 1.2 driver, I have a SQL Server 2005 back end with the following clients connecting to it:
ASP.NET 2.0 web application
Visual Studio C# console applications (*2)
Java command line client.
Everything runs hunky-dory on my dev. environment (laptop, local, launched via Visual Studio) but now it's on the server, the Java client is erroring.
When I use the 1.2 sqljdbc.jar file, I get:
25-Jan-2008 12:20:29 com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
WARNING: ConnectionID:1 TransactionID:0x0000000000000000 Prelogin response packet not marked as a REPLY
My Error Trap:
--------------
SQL STATE : 08S01
ERROR CODE: 0
MESSAGE : The TDS protocol stream is not valid.
When I use the 1.1 file I get:
My Error Trap:
--------------
SQL STATE : 08S01
ERROR CODE: 0
MESSAGE : The TDS prelogin response is incomplete. The target server must be SQL Server 2000 or later.
I don't know what these errors mean. I've tried compiling as java 1.5 and 1.6 with the same results. It works fine on my laptop (Vista Home Premium) but won't when I try and connect to the server. I've searched the web on the error messages and can't find an answer yet.
Any help appreciated.
My drivers are the Windows versions. Also, everything else is working okay on the server: The consoles are up and running and the web browser connects and SELECTs, UPDATEs & INSERTs okay.
I ought to mention: My laptop is running SQL Server Development edition and the Server is running obviously something else.
My SQL Server version is 9.0.1399 and the OS is Windows Server 2003. SQL Authentication is mixed mode.
i am starting work on developing an HR system and have been advised that i cannot have a copy of the live HR data for obvious reasons. I am reluctant to use made up data as it wont have the correct history or peculiarities of the live dataset.
is there a way or randomising the data so that noone in the database is recognisable? i can see that certain fields could be adjusted by adding random numbers of days, weeks or months to all date fields, multiplying the currency fields by a random %age etc..
does anyone have any ideas about how it could be achieved? I would like to be able to put the process into a DTS or adhox job so that i can take a new set of data as and when the test data becomes out of date.
tia
On one of the workstations being used by a developer we see the following entries in the event log:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17828
Date: 17/12/2007
Time: 10:24:25
User: N/A
Computer: <removed>
Description:
The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: <local machine>]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
<removed>
Searching on the internet we don't get a satisfying answer. This connection to the database is made through a .NET web service using the default client libraries from the Base Class Library. We are talking about a fully patched SQL Server 2005 Developer Edition and .NET Framework 3.5.
Any clues?
I only found the following "relevant" link:
http://www.webservertalk.com/message1539518.html
But I am the kind of guy that likes to know what went or goes wrong instead of trying out hacks like the one described in the above link.
I unable to setup a linked server on sql server 2012. The destination server is on sql server 7.0. I can able to setup the same linked server on sql 2005 sp4 and sql 2008 r2 but unable to setup on 2012. I am getting the below error message. OLE DB provider "SQLNCLI11" for linked server "" returned message "Client unable to establish connection due to prelogin failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
OLE DB provider "SQLNCLI11" for linked server "" returned message "Client unable to establish connection".
Msg 26, Level 16, State 1, Line 0
Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server.
i've been writing an app for my company that has a front end screen in which the user types in all infos needed (ie. name, address, city, state, etc - 82 fields to be exact) then clicks an "add" button, which i put at the bottom, and have that data dumped into a SQL table... the page is then redirected to another page which reads the record just added and displays all the fields that the user submitted...
here is my front end "add" screen code behind written in C#:
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 Vinny_Credit_Application_AddCredApp : System.Web.UI.Page
{protected void Page_Load(object sender, EventArgs e)
{
}protected void SubmitButton_Click(object sender, EventArgs e)
{string ConnectionString = ConfigurationManager.ConnectionStrings["ws2dbConnectionString2"].ConnectionString;
SqlConnection connection = new SqlConnection(ConnectionString);SqlCommand cmd = new SqlCommand(@"INSERT INTO CreditAppFile (
GI_RB_Div,
GI_RB_ExistCust,
GI_TB_LegalFirmName,
GI_TB_Address,
GI_TB_City,
GI_DDL_State,
GI_TB_Zip,
GI_TB_TradeName,
GI_TB_BillAddress,
GI_TB_BillCity,
GI_DDL_BillState,
GI_TB_BillZip,
GI_TB_ContName,
GI_TB_Title,
GI_TB_MobilePager,
GI_TB_Email,
GI_TB_Fax,
GI_TB_BusDesc,
GI_TB_BusStartDate,
GI_TB_BusPhone,
GI_RB_PuchOrdsReq,
GI_RB_BusType,
GI_RB_LiensJudges,
GI_RB_TaxExempt,
GI_TB_FedIDNO,
GI_RB_PriorBankrupt,
GI_TB_PriorBankr,
BFR_TB_ContPhone,
BFR_TB_AcctNum1,
BFR_TB_AcctNum2,
BFR_TB_CurrBal1,
BFR_TB_CurrBal2,
BFR_TB_CurrBal3,
BFR_TB_CurrBal4,
BFR_RB_AcctType,
TR_TB_ContName1,
TR_TB_ContAddr1,
TR_TB_ContCity1,
TR_DDL_ContSt1,
TR_TB_ContZip1,
TR_TB_ContPhone1,
TR_TB_Cont_Acct1,
TR_TB_ContName2,
TR_TB_ContAddr2,
TR_TB_ContCity2,
TR_DDL_ContSt2,
TR_TB_ContZip2,
TR_TB_ContPhone2,
TR_TB_Cont_Acct2,
TR_TB_ContName3,
TR_TB_ContAddr3,
TR_TB_ContCity3,
TR_DDL_ContSt3,
TR_TB_ContZip3,
TR_TB_ContPhone3,
TR_TB_Cont_Acct3,
PI_TB_Name1,
PI_TB_HomeAddr1,
PI_TB_BDay1,
PI_TB_SSNum1,
PI_TB_HomePh1,
PI_TB_PrcntOwn1,
PI_TB_NetWorth1,
PI_TB_AnnInc1,
PI_TB_MonHouPay1,
PI_TB_Name2,
PI_TB_HomeAddr2,
PI_TB_BDay2,
PI_TB_SSNum2,
PI_TB_HomePh2,
PI_TB_PrcntOwn2,
PI_TB_NetWorth2,
PI_TB_AnnInc2,
PI_TB_MonHouPay2,
PI_TB_Name3,
PI_TB_HomeAddr3,
PI_TB_BDay3,
PI_TB_SSNum3,
PI_TB_HomePh3,
PI_TB_PrcntOwn3,
PI_TB_NetWorth3,
PI_TB_AnnInc3,
PI_TB_MonHouPay3
)
VALUES (
@GI_RB_Div,
@GI_RB_ExistCust,
@GI_TB_LegalFirmName,
@GI_TB_Address,
@GI_TB_City,
@GI_DDL_State,
@GI_TB_Zip,
@GI_TB_TradeName,
@GI_TB_BillAddress,
@GI_TB_BillCity,
@GI_DDL_BillState,
@GI_TB_BillZip,
@GI_TB_ContName,
@GI_TB_Title,
@GI_TB_MobilePager,
@GI_TB_Email,
@GI_TB_Fax,
@GI_TB_BusDesc,
@GI_TB_BusStartDate,
@GI_TB_BusPhone,
@GI_RB_PuchOrdsReq,
@GI_RB_BusType,
@GI_RB_LiensJudges,
@GI_RB_TaxExempt,
@GI_TB_FedIDNO,
@GI_RB_PriorBankrupt,
@GI_TB_PriorBankr,
@BFR_TB_ContPhone,
@BFR_TB_AcctNum1,
@BFR_TB_AcctNum2,
@BFR_TB_CurrBal1,
@BFR_TB_CurrBal2,
@BFR_TB_CurrBal3,
@BFR_TB_CurrBal4,
@BFR_RB_AcctType,
@TR_TB_ContName1,
@TR_TB_ContAddr1,
@TR_TB_ContCity1,
@TR_DDL_ContSt1,
@TR_TB_ContZip1,
@TR_TB_ContPhone1,
@TR_TB_Cont_Acct1,
@TR_TB_ContName2,
@TR_TB_ContAddr2,
@TR_TB_ContCity2,
@TR_DDL_ContSt2,
@TR_TB_ContZip2,
@TR_TB_ContPhone2,
@TR_TB_Cont_Acct2,
@TR_TB_ContName3,
@TR_TB_ContAddr3,
@TR_TB_ContCity3,
@TR_DDL_ContSt3,
@TR_TB_ContZip3,
@TR_TB_ContPhone3,
@TR_TB_Cont_Acct3,
@PI_TB_Name1,
@PI_TB_HomeAddr1,
@PI_TB_BDay1,
@PI_TB_SSNum1,
@PI_TB_HomePh1,
@PI_TB_PrcntOwn1,
@PI_TB_NetWorth1,
@PI_TB_AnnInc1,
@PI_TB_MonHouPay1,
@PI_TB_Name2,
@PI_TB_HomeAddr2,
@PI_TB_BDay2,
@PI_TB_SSNum2,
@PI_TB_HomePh2,
@PI_TB_PrcntOwn2,
@PI_TB_NetWorth2,
@PI_TB_AnnInc2,
@PI_TB_MonHouPay2,
@PI_TB_Name3,
@PI_TB_HomeAddr3,
@PI_TB_BDay3,
@PI_TB_SSNum3,
@PI_TB_HomePh3,
@PI_TB_PrcntOwn3,
@PI_TB_NetWorth3,
@PI_TB_AnnInc3,
@PI_TB_MonHouPay3
); Select Scope_Identity()"
, connection);
try
{cmd.Parameters.AddWithValue("@GI_RB_Div", GI_RB_Div.SelectedValue);
cmd.Parameters.AddWithValue("@GI_RB_ExistCust", GI_RB_ExistCust.SelectedValue);cmd.Parameters.AddWithValue("@GI_TB_LegalFirmName", GI_TB_LegalFirmName.Text);
cmd.Parameters.AddWithValue("@GI_TB_Address", GI_TB_Address.Text);cmd.Parameters.AddWithValue("@GI_TB_City", GI_TB_City.Text);
cmd.Parameters.AddWithValue("@GI_DDL_State", GI_DDL_State.SelectedValue);cmd.Parameters.AddWithValue("@GI_TB_Zip", GI_TB_Zip.Text);
cmd.Parameters.AddWithValue("@GI_TB_TradeName", GI_TB_TradeName.Text);cmd.Parameters.AddWithValue("@GI_TB_BillAddress", GI_TB_BillAddress.Text);
cmd.Parameters.AddWithValue("@GI_TB_BillCity", GI_TB_BillCity.Text);cmd.Parameters.AddWithValue("@GI_DDL_BillState", GI_DDL_BillState.SelectedValue);
cmd.Parameters.AddWithValue("@GI_TB_BillZip", GI_TB_BillZip.Text);cmd.Parameters.AddWithValue("@GI_TB_ContName", GI_TB_ContName.Text);
cmd.Parameters.AddWithValue("@GI_TB_Title", GI_TB_Title.Text);cmd.Parameters.AddWithValue("@GI_TB_MobilePager", GI_TB_MobilePager.Text);
cmd.Parameters.AddWithValue("@GI_TB_Email", GI_TB_Email.Text);cmd.Parameters.AddWithValue("@GI_TB_Fax", GI_TB_Fax.Text);
cmd.Parameters.AddWithValue("@GI_TB_BusDesc", GI_TB_BusDesc.Text);cmd.Parameters.AddWithValue("@GI_TB_BusStartDate", GI_TB_BusStartDate.Text);
cmd.Parameters.AddWithValue("@GI_TB_BusPhone", GI_TB_BusPhone.Text);cmd.Parameters.AddWithValue("@GI_RB_PuchOrdsReq", GI_RB_PuchOrdsReq.SelectedValue);
cmd.Parameters.AddWithValue("@GI_RB_BusType", GI_RB_BusType.SelectedValue);cmd.Parameters.AddWithValue("@GI_RB_LiensJudges", GI_RB_LiensJudges.SelectedValue);
cmd.Parameters.AddWithValue("@GI_RB_TaxExempt", GI_RB_TaxExempt.SelectedValue);cmd.Parameters.AddWithValue("@GI_TB_FedIDNO", GI_TB_FedIDNO.Text);
cmd.Parameters.AddWithValue("@GI_RB_PriorBankrupt", GI_RB_PriorBankrupt.SelectedValue);cmd.Parameters.AddWithValue("@GI_TB_PriorBankr", GI_TB_PriorBankr.Text);
cmd.Parameters.AddWithValue("@BFR_TB_ContPhone", BFR_TB_ContPhone.Text);cmd.Parameters.AddWithValue("@BFR_TB_AcctNum1", BFR_TB_AcctNum1.Text);
cmd.Parameters.AddWithValue("@BFR_TB_AcctNum2", BFR_TB_AcctNum2.Text);cmd.Parameters.AddWithValue("@BFR_TB_CurrBal1", BFR_TB_CurrBal1.Text);
cmd.Parameters.AddWithValue("@BFR_TB_CurrBal2", BFR_TB_CurrBal2.Text);cmd.Parameters.AddWithValue("@BFR_TB_CurrBal3", BFR_TB_CurrBal3.Text);
cmd.Parameters.AddWithValue("@BFR_TB_CurrBal4", BFR_TB_CurrBal4.Text);cmd.Parameters.AddWithValue("@BFR_RB_AcctType", BFR_RB_AcctType.Text);
cmd.Parameters.AddWithValue("@TR_TB_ContName1", TR_TB_ContName1.Text);cmd.Parameters.AddWithValue("@TR_TB_ContAddr1", TR_TB_ContAddr1.Text);
cmd.Parameters.AddWithValue("@TR_TB_ContCity1", TR_TB_ContCity1.Text);cmd.Parameters.AddWithValue("@TR_DDL_ContSt1", TR_DDL_ContSt1.SelectedValue);
cmd.Parameters.AddWithValue("@TR_TB_ContZip1", TR_TB_ContZip1.Text);cmd.Parameters.AddWithValue("@TR_TB_ContPhone1", TR_TB_ContPhone1.Text);
cmd.Parameters.AddWithValue("@TR_TB_Cont_Acct1", TR_TB_Cont_Acct1.Text);cmd.Parameters.AddWithValue("@TR_TB_ContName2", TR_TB_ContName2.Text);
cmd.Parameters.AddWithValue("@TR_TB_ContAddr2", TR_TB_ContAddr2.Text);cmd.Parameters.AddWithValue("@TR_TB_ContCity2", TR_TB_ContCity2.Text);
cmd.Parameters.AddWithValue("@TR_DDL_ContSt2", TR_DDL_ContSt2.SelectedValue);cmd.Parameters.AddWithValue("@TR_TB_ContZip2", TR_TB_ContZip2.Text);
cmd.Parameters.AddWithValue("@TR_TB_ContPhone2", TR_TB_ContPhone2.Text);cmd.Parameters.AddWithValue("@TR_TB_Cont_Acct2", TR_TB_Cont_Acct2.Text);
cmd.Parameters.AddWithValue("@TR_TB_ContName3", TR_TB_ContName3.Text);cmd.Parameters.AddWithValue("@TR_TB_ContAddr3", TR_TB_ContAddr3.Text);
cmd.Parameters.AddWithValue("@TR_TB_ContCity3", TR_TB_ContCity3.Text);cmd.Parameters.AddWithValue("@TR_DDL_ContSt3", TR_DDL_ContSt3.SelectedValue);
cmd.Parameters.AddWithValue("@TR_TB_ContZip3", TR_TB_ContZip3.Text);cmd.Parameters.AddWithValue("@TR_TB_ContPhone3", TR_TB_ContPhone3.Text);
cmd.Parameters.AddWithValue("@TR_TB_Cont_Acct3", TR_TB_Cont_Acct3.Text);cmd.Parameters.AddWithValue("@PI_TB_Name1", PI_TB_Name1.Text);
cmd.Parameters.AddWithValue("@PI_TB_HomeAddr1", PI_TB_HomeAddr1.Text);cmd.Parameters.AddWithValue("@PI_TB_BDay1", PI_TB_BDay1.Text);
cmd.Parameters.AddWithValue("@PI_TB_SSNum1", PI_TB_SSNum1.Text);cmd.Parameters.AddWithValue("@PI_TB_HomePh1", PI_TB_HomePh1.Text);
cmd.Parameters.AddWithValue("@PI_TB_PrcntOwn1", PI_TB_PrcntOwn1.Text);cmd.Parameters.AddWithValue("@PI_TB_NetWorth1", PI_TB_NetWorth1.Text);
cmd.Parameters.AddWithValue("@PI_TB_AnnInc1", PI_TB_AnnInc1.Text);cmd.Parameters.AddWithValue("@PI_TB_MonHouPay1", PI_TB_MonHouPay1.Text);
cmd.Parameters.AddWithValue("@PI_TB_Name2", PI_TB_Name2.Text);cmd.Parameters.AddWithValue("@PI_TB_HomeAddr2", PI_TB_HomeAddr2.Text);
cmd.Parameters.AddWithValue("@PI_TB_BDay2", PI_TB_BDay2.Text);cmd.Parameters.AddWithValue("@PI_TB_SSNum2", PI_TB_SSNum2.Text);
cmd.Parameters.AddWithValue("@PI_TB_HomePh2", PI_TB_HomePh2.Text);cmd.Parameters.AddWithValue("@PI_TB_PrcntOwn2", PI_TB_PrcntOwn2.Text);
cmd.Parameters.AddWithValue("@PI_TB_NetWorth2", PI_TB_NetWorth2.Text);cmd.Parameters.AddWithValue("@PI_TB_AnnInc2", PI_TB_AnnInc2.Text);
cmd.Parameters.AddWithValue("@PI_TB_MonHouPay2", PI_TB_MonHouPay2.Text);cmd.Parameters.AddWithValue("@PI_TB_Name3", PI_TB_Name3.Text);
cmd.Parameters.AddWithValue("@PI_TB_HomeAddr3", PI_TB_HomeAddr3.Text);cmd.Parameters.AddWithValue("@PI_TB_BDay3", PI_TB_BDay3.Text);
cmd.Parameters.AddWithValue("@PI_TB_SSNum3", PI_TB_SSNum3.Text);cmd.Parameters.AddWithValue("@PI_TB_HomePh3", PI_TB_HomePh3.Text);
cmd.Parameters.AddWithValue("@PI_TB_PrcntOwn3", PI_TB_PrcntOwn3.Text);cmd.Parameters.AddWithValue("@PI_TB_NetWorth3", PI_TB_NetWorth3.Text);
cmd.Parameters.AddWithValue("@PI_TB_AnnInc3", PI_TB_AnnInc3.Text);cmd.Parameters.AddWithValue("@PI_TB_MonHouPay3", PI_TB_MonHouPay3.Text);
cmd.Connection = connection;
cmd.Connection.Open();string NewID = cmd.ExecuteScalar().ToString();
cmd.Connection.Close();
Response.Redirect("DisplayCredApp.aspx?ID=" + Request["NewID"]);
}catch (Exception ex)
{lblMessage.Text = "ERROR: " + ex.Message;lblMessage.Visible = true;
}
}
}
this seems to be ok... but i get a load of errors on my "read/display" page which looks like the folowing... (this is the code behind, again, written in C#)
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 Vinny_Credit_Application_DisplayCredApp : System.Web.UI.Page
{protected void Page_Load(object sender, EventArgs e)
{if (!IsPostBack && Response["NewID"] != null)
{string ConnectionString = ConfigurationManager.ConnectionStrings["ws2dbConnectionString"].ConnectionString;
SqlConnection connection = new SqlConnection(ConnectionString);SqlCommand cmd = new SqlCommand(@"SELECT * FROM CreditAppFile WHERE ID = @ID", connection);cmd.Parameters.Add("@ID", Response["NewID"].ToString());
connection.Open();SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
GI_RB_Div.Text = reader["GI_RB_Div"].ToString();GI_RB_ExistCust.Text = reader["GI_RB_ExistCust"].ToString();
GI_TB_LegalFirmName.Text = reader["GI_TB_LegalFirmName"].ToString();GI_TB_Address.Text = reader["GI_TB_Address"].ToString();
GI_TB_City.Text = reader["GI_TB_City"].ToString();GI_DDL_State.Text = reader["GI_DDL_State"].ToString();
GI_TB_Zip.Text = reader["GI_TB_Zip"].ToString();GI_TB_TradeName.Text = reader["GI_TB_TradeName"].ToString();
GI_TB_BillAddress.Text = reader["GI_TB_BillAddress"].ToString();GI_TB_BillCity.Text = reader["GI_TB_BillCity"].ToString();
GI_DDL_BillState.Text = reader["GI_DDL_BillState"].ToString();GI_TB_BillZip.Text = reader["GI_TB_BillZip"].ToString();
GI_TB_ContName.Text = reader["GI_TB_ContName"].ToString();GI_TB_Title.Text = reader["GI_TB_Title"].ToString();
GI_TB_MobilePager.Text = reader["GI_TB_MobilePager"].ToString();GI_TB_Email.Text = reader["GI_TB_Email"].ToString();
GI_TB_Fax.Text = reader["GI_TB_Fax"].ToString();GI_TB_BusDesc.Text = reader["GI_TB_BusDesc"].ToString();
GI_TB_BusStartDate.Text = reader["GI_TB_BusStartDate"].ToString();GI_TB_BusPhone.Text = reader["GI_TB_BusPhone"].ToString();
GI_RB_PuchOrdsReq.Text = reader["GI_RB_PuchOrdsReq"].ToString();GI_RB_BusType.Text = reader["GI_RB_BusType"].ToString();
GI_RB_LiensJudges.Text = reader["GI_RB_LiensJudges"].ToString();GI_RB_TaxExempt.Text = reader["GI_RB_TaxExempt"].ToString();
GI_TB_FedIDNO.Text = reader["GI_TB_FedIDNO"].ToString();GI_RB_PriorBankrupt.Text = reader["GI_RB_PriorBankrupt"].ToString();
GI_TB_PriorBankr.Text = reader["GI_TB_PriorBankr"].ToString();BFR_TB_ContPhone.Text = reader["BFR_TB_ContPhone"].ToString();
BFR_TB_AcctNum1.Text = reader["BFR_TB_AcctNum1"].ToString();BFR_TB_AcctNum2.Text = reader["BFR_TB_AcctNum2"].ToString();
BFR_TB_CurrBal1.Text = reader["BFR_TB_CurrBal1"].ToString();BFR_TB_CurrBal2.Text = reader["BFR_TB_CurrBal2"].ToString();
BFR_TB_CurrBal3.Text = reader["BFR_TB_CurrBal3"].ToString();BFR_TB_CurrBal4.Text = reader["BFR_TB_CurrBal4"].ToString();
BFR_RB_AcctType.Text = reader["BFR_RB_AcctType"].ToString();TR_TB_ContName1.Text = reader["TR_TB_ContName1"].ToString();
TR_TB_ContAddr1.Text = reader["TR_TB_ContAddr1"].ToString();TR_TB_ContCity1.Text = reader["TR_TB_ContCity1"].ToString();
TR_DDL_ContSt1.Text = reader["TR_DDL_ContSt1"].ToString();TR_TB_ContZip1.Text = reader["TR_TB_ContZip1"].ToString();
TR_TB_ContPhone1.Text = reader["TR_TB_ContPhone1"].ToString();TR_TB_Cont_Acct1.Text = reader["TR_TB_Cont_Acct1"].ToString();
TR_TB_ContName2.Text = reader["TR_TB_ContName2"].ToString();TR_TB_ContAddr2.Text = reader["TR_TB_ContAddr2"].ToString();
TR_TB_ContCity2.Text = reader["TR_TB_ContCity2"].ToString();TR_DDL_ContSt2.Text = reader["TR_DDL_ContSt2"].ToString();
TR_TB_ContZip2.Text = reader["TR_TB_ContZip2"].ToString();TR_TB_ContPhone2.Text = reader["TR_TB_ContPhone2"].ToString();
TR_TB_Cont_Acct2.Text = reader["TR_TB_Cont_Acct2"].ToString();TR_TB_ContName3.Text = reader["TR_TB_ContName3"].ToString();
TR_TB_ContAddr3.Text = reader["TR_TB_ContAddr3"].ToString();TR_TB_ContCity3.Text = reader["TR_TB_ContCity3"].ToString();
TR_DDL_ContSt3.Text = reader["TR_DDL_ContSt3"].ToString();TR_TB_ContZip3.Text = reader["TR_TB_ContZip3"].ToString();
TR_TB_ContPhone3.Text = reader["TR_TB_ContPhone3"].ToString();TR_TB_Cont_Acct3.Text = reader["TR_TB_Cont_Acct3"].ToString();
PI_TB_Name1.Text = reader["PI_TB_Name1"].ToString();PI_TB_HomeAddr1.Text = reader["PI_TB_HomeAddr1"].ToString();
PI_TB_BDay1.Text = reader["PI_TB_BDay1"].ToString();PI_TB_SSNum1.Text = reader["PI_TB_SSNum1"].ToString();
PI_TB_HomePh1.Text = reader["PI_TB_HomePh1"].ToString();PI_TB_PrcntOwn1.Text = reader["PI_TB_PrcntOwn1"].ToString();
PI_TB_NetWorth1.Text = reader["PI_TB_NetWorth1"].ToString();PI_TB_AnnInc1.Text = reader["PI_TB_AnnInc1"].ToString();
PI_TB_MonHouPay1.Text = reader["PI_TB_MonHouPay1"].ToString();PI_TB_Name2.Text = reader["PI_TB_Name2"].ToString();
PI_TB_HomeAddr2.Text = reader["PI_TB_HomeAddr2"].ToString();PI_TB_BDay2.Text = reader["PI_TB_BDay2"].ToString();
PI_TB_SSNum2.Text = reader["PI_TB_SSNum2"].ToString();PI_TB_HomePh2.Text = reader["PI_TB_HomePh2"].ToString();
PI_TB_PrcntOwn2.Text = reader["PI_TB_PrcntOwn2"].ToString();PI_TB_NetWorth2.Text = reader["PI_TB_NetWorth2"].ToString();
PI_TB_AnnInc2.Text = reader["PI_TB_AnnInc2"].ToString();PI_TB_Name2.Text = reader["PI_TB_MonHouPay2"].ToString();
PI_TB_Name3.Text = reader["PI_TB_Name3"].ToString();PI_TB_HomeAddr3.Text = reader["PI_TB_HomeAddr3"].ToString();
PI_TB_BDay3.Text = reader["PI_TB_BDay3"].ToString();PI_TB_SSNum3.Text = reader["PI_TB_SSNum3"].ToString();
PI_TB_HomePh3.Text = reader["PI_TB_HomePh3"].ToString();PI_TB_PrcntOwn3.Text = reader["PI_TB_PrcntOwn3"].ToString();
PI_TB_NetWorth3.Text = reader["PI_TB_NetWorth3"].ToString();PI_TB_AnnInc3.Text = reader["PI_TB_AnnInc3"].ToString();PI_TB_MonHouPay3.Text = reader["PI_TB_MonHouPay3"].ToString();
connection.Close();
}
}
}
been working on this for days... everytime i get a little closer i seem to get that much farther away... if you can help by all means give me what you got...
thanks for all the help in advance!!!!
- Vinny
Hello !
I came across some interesting issues that solving them will definately help me a lot !
1) Is there a way to insert my database a row, and that it will automatically fill up the datetime column with the local machine time ? (so that I won't have to worry about users local time)
2) I'm trying to synchronize between two data sources - one is my DB and the other is a file. The data in the file should represent the data to be in the DB. However, I don't want to delete all the records and then just insert everything in the file, but to perform Insert, Update or Delete operations according to the file's changes. I managed to do the Insert and Update, but I can't find a solution to a scenario where old data, which is on the DB but not on the file, could be deleted from the DB.
I appreciate the help A LOT !
Is it possible to write these two blocks of code as one? The onlydifference between them is the AND clause: AND is_trade_date = 1 versus ANDis_sett_date = 1.Cheers,DavidIF (@trade_dates = 1)BEGINIF EXISTS (SELECT 1 FROM calendarWHERE calendar_date = @dateAND is_trade_date = 1)BEGINSELECT @day_cnt = @day_cnt + 1ENDENDELSEBEGINIF EXISTS (SELECT 1 FROM calendarWHERE calendar_date = @dateAND is_sett_date = 1)BEGINSELECT @day_cnt = @day_cnt + 1ENDENDEND
View 3 Replies View RelatedHi -
Is there a resource I can go to that lists people who I pay to talk me through stuff like getting SQL Server Express installed, get some sample data input and then get that data into Excel? I just cannot seem to get any help that works for me to learn SQL Server; the books are obtuse, the online help too indirect. Once I get something working I hope to enhance it on my own, but I have been stuck at the start for a very long time. There is stuff for me to do that is not getting done.
Doug
I have a question about a query.I have 2 tables:As an example I have the following tables (not my real tables)1) lstParts: Complete list of parts with 2 fields: partID, partName.2) tblOrders: table of orders with 2 fields: partID, custIDObviously the partID’s are keys to each other.
What I want is a list of all the records in lstParts that are not in tblOrders for an individual customer. So it might answer, “what parts has this customer NOT ordered?�
What I have so far is close but it is repeating the correct result for each row in tblOrders.
Here is what I have so far
SELECT
p.partID,
p.partName
FROM
lstParts p
LEFT OUTER JOIN tblOrders o
ON p.partID <> o.partID
WHERE
o.custID = ‘123’
Any help would be appreciated-Thanks
I have a table control on a report that is when it is displayed it shows the right side of the report being cut off. If I go to the next page the report displays properly. When I go back to the first page it then displays properly.
How can I get it to display properly the first time it is viewed?
Folks,
On matrix reports, when viewed with IE through the ReportServer URL access page, Matrix reports are getting cut off on the right-hand side to the original size of the report. However, this corrects itself immediately if you toggle any item, or change the zoom level.
What's really confusing is that most of our reports that have expanding functionality work just fine -- there's just a couple that don't. We have spent a couple days trying to figure out what's different with no luck.
EDITED: navigating away from the page by typing another URL in the address bar, and then hitting back, corrects this. The problem is also not present with &rc:Toolbar=false, but with the toolbar on, it's there.
Any ideas?
Thanks so much!
--randy
We are running SQL Version 7.0.
I recently set up a simple snapshot replication. After restarting enterprise manager a hand symbol showed up under the database barrel as if a share symbol.
Am I correct in assuming the symbol means replication. Is there a source that explains what the various symbols mean?
I'm trying to run some reports on SQL 2005, but can't even pass the first step of launching the report builder. I have SQL2005 on my local machine, but the report server is installed on a remote server. I launched SQL Business Intelligence Development Studio, which brings Visual studio, but i keep getting a prompt to enter a connection string. How do i get the connection string, or how do i set up my datasource?
Help!
I have a problem with ordering and I am hoping that someone is able to help.
In my table I have two fields, "requestdate" and "sentdate", and when I display the records I would like to sort by BOTH fields. I want to do this so that the full query is in order by date.
I tried:
ORDER BY requestdate, sentdate DESC
But obviously all that does is order by requestdate (which is NULL or a date) and than it will order by sentdate.
Can somebody tell me how to order by both as if they were the same field?
Thanks!
vs2005 help���� a textbox ，a button ， a sqldatasource ,a dataview when click the button execute sql: select * from authors where name=''+textbox.text+''
the dataset returned list in dataview , just like c/s 。 I feel it very hard to
contral sqldatasource,
code is holpful 2!
I'm happyguy and this is the first time to post my problem. Thanks a lot
here is a SQL query that I know how to write in Oracle, which is
Select * from AttandanceRecord where date like '%__/Apr/2006%'
but, now i'm developing my system with using Ms Sql Server 2000, so I don't know how to write a query with same output as above...
Please, can somebody help me??
Hi, I have created a search page which needs to perform different
search function in same page. I have setuped a sqldatasource then
manual
setup the connection string and command inside the codefile. So the
select command can be various depends on the event. The problem is
all of those setting will be reset after I click on the pageindex in
the girdview control to go to next pages. Since this gridview is linked
with this sqldatasource control, I need to restore the connection
string/command when user choose decide to view next page of data inisde
the
gridview.
I think I must have done something wrong in here becuase it will end up
retrieving the total amount of data when everytime user choose to
view next
or perivous page.
Can someone give me a hand on this ? Thanks
I want to calculate stock aging (qty, cost) based on the on hand quantity.
Currently I am recording only in/out transaction only.
For ex: Item A i have 115 pieces (Balance stock) as on to day.
Transaction History
---------------------
Lot 1 - 01/01/2015 - 50
Lot 2 - 10/02/2015 - 50
Lot 3 - 11/03/2015 - 50
Lot 4 - 15/04/2014 - 50
I want to calculate cost of balance qty as shown below.
Jan -
Feb - 15 @ 1.1
Mar - 50 @ 0.90
Apr - 50 @ 1.2
Database schema
--------------------
CREATE TABLE [dbo].[StockManagement](
[Uniid] [int] IDENTITY(1,1) NOT NULL,
[StockCode] [int] NULL,
[TransactionDate] [datetime] NULL,
[TransactionTime] [time](0) NULL,
[Code] .....
Since as soon as you extend your mdx datasets manually you can no longer switch back into design mode without losing your changes, right?
If that's the case, is there some way to disable design mode completely? i'm finding that the GUI has the tendency to SILENTLY revert the dataset editor back to design mode while I'm busy editing a layout, thereby losing my carefully crafted MDX.
I am having report parameter end date I am showing the default value "5/21/2007 11:59:59 PM" in the end date paramter. And also I want to show date time format "(MM/DD/YYYY HH:MMS)" in the right hand side of the parameter. How to do this?
Thank You
I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.
Extract from log:
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).
I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.
Any ideas?
Hi -
I have an File System Task that copies a file from one directory ot another. When I hard code the target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:
[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".
Where do I change the security settings?
Thanks - Grace
I cannot execute a package by using Execute Package task.
I supplied sa credentials to connection manager, and it shows the list of Packages on SQL Server but when running the task it says
Error 0xC0202009 while preparing to load the package. An OLE DB error has occurred. Error code: 0x%1!8.8X!.
Any clue ?
Thanks,
Fahad
Hi,
I am running dts in Sql Server 2005 management studio from Management, Legacy and data Transformation Services.
Once the dts has run, I get this error message "Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error accessing Windows Event Log."
Please help me
thanks in advance
Srinivas
We have reports deployed in the Report Server. While connecting from client, we are getting the error
"An internal error occurred on the report server. See the error log for more details. rsInternal Error)"
Then we went to Report Server, Reporting Service and SQL Server service are all are running fine.
Important thing is some time the reports are working fine, sometimes i am receiving this error. Please help.
We predict whether the services are automatically restarted or transaction logs exceeding the limit or any other parameters to set to avaoid this error?
Please help.
I'm trying to use an XML Task to do a simple XSLT operation, but it fails with this error message:
[XML Task] Error: An error occurred with the following error message: "There are multiple root elements. Line 5, position 2.".
The source XML file validates fine and I've successfully used it as the XML Source in a data flow task to load some SQL Server tables. It has very few line breaks, so the first 5 lines are pretty long: almost 4000 characters, including 34 start-tags, 19 end-tags, and 2 empty element tags. Here's the very beginning of it:
<?xml version="1.0" encoding="UTF-8"?>
<ESDU releaselevel="2006-02" createdate="26 May 2006"><package id="1" title="_standard" shorttitle="_standard" filename="pk_stan" supplementdate="01/05/2005" supplementlevel="1"><abstract><![CDATA[This package contains the standard ESDU Series.]]></abstract>
There is only 1 ESDU root element and only 1 package element.
Of course, the XSLT stylesheet is also an XML document in its own right. I specify it directly in the XML Task:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"/>
<xsl:template name="identity" match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="kw">
<xsl:copy>
<xsl:apply-templates select="@*"/>
<xsl:attribute name="ihs_cats_seq" select="position()"/>
<xsl:apply-templates select="node()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
Its 5th line is the first xsl:template element.
What is going on here? I do not see multiple root elements in either the XML document or the XSLT stylesheet.
Thanks!
I have the error above, but no error log. I can preview the sub report - but this main report fails after working this morning. This is for internal company reports and I rebuilt this one after converting from access.
I have looked where the error logs should be, but there are no error logs.
I rebuilt the query as I needed to change this, but this did not help.
Is there someone who could point me in the correct direction.
Thanks!
Terry
This has worked fine for weeks, and months.
I'm running Vista Ultimate. SQL 2005 is set as my Default instance, and SQL2000 is set as (local)SQL2000.
Today, actually half way through today, I restarted my computer after installing Photoshop Updates.
Upon getting my computer back up and running, I cannot access SQL2000 from any website on my computer, nor can I access it from SQL2005 Management Stdio. I CAN access it from Enterprise Manager (SQL2000 tool).
Whenever I run an web app that connects to it 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)
Now I usually get these when ASP.NET can't point to the right spot, but in this case I'm pointing exactly where I need to go. Any thoughts?
--Edit
I should also add my password got changed a few days ago on our Domain. This was the first time restarting after the PW change.
My link server was working just fine until friday evening.
It stopped worked over the week end.
with and error Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error .
---my oracle 10g client is working just fine
--TNS names looks fine
---i recreated the link but i am still getting the same error.
I need your help because a lot of jobs are using that link on Monday it is going to be crazzzy.
Hi,
We have a production SQLServer 6.5 running with service pack SP5a update:
I got the following 2 errors.....
1.
Error : 806, Severity: 21, State: 1
Could not find virtual page for logical page 67833121 in database 'tempdb' database 'tempdb'
2.
I got error when I ran a job for Update statistics
Error : 614, Severity: 21, State: 3
A row on page 2697653 was accessed that has an illegal length of -8631 in database 'abc'.
For Error 2: I ran update statistics using query analyser. It is fine
Is there anything I have to do further?
For Error 1 : The work around given by Microsoft
=================================================
I ran
DBCC CHECKTABLE(syslogs)
I am getting the following message on :
master:
Checking syslogs
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 11 data rows.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.
model:
Checking syslogs
The total number of data pages in this table is 47.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 532 data rows.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.
tempdb:
Checking syslogs
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 31 data rows.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.
I ran dbcc checkdb on master,model and tempdb . Still I get the same problem.
for tempdb:
Checking 8
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 19 data rows.
for master:
Checking 8
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 27 data rows.
for model:
Checking 8
The total number of data pages in this table is 47.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 532 data rows.
All system databases and userdatabase recovered successfully when I restarted sqlserver.
Please advice how to get rid of this problem.
Thanks in advance,
Anu
where can i find it?
thanks