Sybase Processes Problem

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
 - 1
 - Performance Testing.... Hi, Now I am developing C#.net Web Application. It is almost completed. Now I want to check performance testing of it. I want... 1) Create 100 user environments, mean 100 users simultaneously request a same page I want to see response time and load on server. 2) As per my idea we can use test project it has web base test and load test inbuilt in Microsoft visual studio Whidbey. Any one has idea about Load test in Microsoft visual studio Whidbey? BYE. Samir (Software Developer, Ahmedabad, INDIA). Tag: Sybase Processes Problem Tag: 95053
 - 2
 - Case-sensitive collation and queries Hi all, I installed a Ms SQL Server 2000 instance with a case-sensitive collation, but I have databases with case-insensitive collations. When I try to make a ExecuteQuery through ADO.NET on case-insensitive database tables I need to set the CommandText in a case-sensitive manner, otherwise I get error messages : I have a table named MyTable, if CommandText is "SELECT * FROM myTable" => error message : object 'myTable' does not exist and "SELECT * FROM MyTable" works fine. 1. This is the correct behaviour ? Any workaround ? It's hell to remember exactly the column or table names 2. How can I find the sql server collation ? (programatically) I'm using .NET Frmw 1.0 Thanks Tag: Sybase Processes Problem Tag: 95051
 - 3
 - Creating XML file with many-to-many relations with a dataset I need to retrieve data from sql sever db that contains link tables which provide many-to-many functionality. Than I need to convert this data to xml file with nesting parent and child relations. The XML need not contain the link tables only their function (relations). Should I use the DataSet object and the DataSet.GetXml() method to this purpose? I would greatly appreciate an example preferably in C#. (I have already seen examples with one-to-many, so please don't refer me to such). Thank you in advance. Hilel. Tag: Sybase Processes Problem Tag: 95050
 - 4
 - Procedure or function has too many arguments specified Hi, Can anyone help me with this error? It works on the local natwork, but not on the webhost. (ive tried everything i can think of... even MS KB 827366) TIA, Bill. Error: System.Data.SqlClient.SqlException: Procedure or function sp_adduser has too many arguments specified my code: public int addUser(string userFirstName, string userLastName, string userEmail, string userPassword, bool userCMSAccess, bool userAdministerOthers, bool userMaster, bool userDemo, int userPartner) { string[] paramName = new string[9]; object[] paramValue = new object[9]; System.Data.SqlDbType[] paramType = new System.Data.SqlDbType[9]; paramName[0] = "@userFirstName"; paramValue[0] = userFirstName; paramType[0] = System.Data.SqlDbType.NVarChar; paramName[1] = "@userLastName"; paramValue[1] = userLastName; paramType[1] = System.Data.SqlDbType.NVarChar; paramName[2] = "@userEmail"; paramValue[2] = userEmail; paramType[2] = System.Data.SqlDbType.NVarChar; paramName[3] = "@userPassword"; paramValue[3] = userPassword; paramType[3] = System.Data.SqlDbType.NVarChar; paramName[4] = "@userCMSAccess"; paramValue[4] = userCMSAccess; paramType[4] = System.Data.SqlDbType.Bit; paramName[5] = "@userAdministerOthers"; paramValue[5] = userAdministerOthers; paramType[5] = System.Data.SqlDbType.Bit; paramName[6] = "@userMaster"; paramValue[6] = userMaster; paramType[6] = System.Data.SqlDbType.Bit; paramName[7] = "@userDemo"; paramValue[7] = userDemo; paramType[7] = System.Data.SqlDbType.Bit; paramName[8] = "@userPartner"; paramValue[8] = userPartner; paramType[8] = System.Data.SqlDbType.Int; return SaveValuesDBTYPED("sp_addUser",paramName,paramValue,paramType,true); } public int SaveValuesDBTYPED(string procedureName,string[] paramName,object[] paramValue,System.Data.SqlDbType[] paramType,bool identity) { SqlConnection con = new SqlConnection(ConnectionString); try { SqlCommand com = new SqlCommand(procedureName,con); SqlParameter p = new SqlParameter(); for(int i=0;i<paramName.Length;i++) { SqlParameter p = new SqlParameter(paramName[i],paramType[i]); p.Value = paramValue[i]; com.Parameters.Add(p); } com.CommandType = CommandType.StoredProcedure; con.Open(); return int.Parse(com.ExecuteScalar().ToString()); return identity ? int.Parse(com.ExecuteScalar().ToString()) : com.ExecuteNonQuery(); } catch(Exception exc) { throw exc; } finally { con.Close(); } Tag: Sybase Processes Problem Tag: 95046
 - 5
 - ADO.NET converting numerical zero to NULL I am seeing a funny effect with ADO.NET - or am I missing some documented behavior here?? I have a stored proc that I need to call, and for that purpose, I create an array of type SQLParameter[], and initialize it with parameters and their values. When I fill my parameters, everything seems to work just fine, except when I need to fill an INT parameter with the value of 0 (zero). Here's a sample: SqlParameter[] oParams = new SqlParameter[15]; oParams[0] = new SqlParameter("@lSprachID", 1); // works fine ...... oParams[9] = new SqlParameter("@lSomeValue", 0); // bombs out The trouble is - instead of creating a parameter no. 9 with a value of 0 (zero), ADO.NET seems to convert this into a NULL parameter, and my stored proc then complains that it doesn't allow NULL values in that particular column. If I chance it to oParams[9] = new SqlParameter("@lSomeValue", SqlDbType.Int); oParams[9].Value = 0; and then call my stored proc, everything's just fine. I don't get it - why would ADO.NET convert a parameter which I create and initialize with a numerical value of "0" (zero) to a NULL parameter?? Is that works-as-designed (and if so, WHERE is that documented??). Is there anything I can do (except use the work around) to change this behaviour?? Thanks! Marc ================================================================ Marc Scheuner May The Source Be With You! Bern, Switzerland m.scheuner(at)inova.ch Tag: Sybase Processes Problem Tag: 95044
 - 6
 - Cast output parameter from SqlGuid to Guid Hi, I had a look at MSDN and it clearly sais that SqlGuid can be casted as Guid. To execute a stored procedure I have the following function (note the s.proc does not return any recordsets, just sets the output value): function updateEntry(ref System.Guid valueID, ...){ ... cmd.ExecuteNonQuery(); //get the output value now: valueID = (System.Guid)cmd.Parameters["@valueID"].Value; .... } Please note that the valueID is passed by reference. The code works fine if I don't pass a value (i.e. set the parameter to DBNull): the valueID gets set as expected. The problem occurs when I do pass a value. I get an Invalid Cast exception?! If I use the following sequence for getting the valueID, the code works fine, but as you can guess, it seems a bit too much: .... //get the output value now: object o = cmd.Parameters["@valueID"].Value; valueID = new Guid(o.ToString()); ... Any ideas what I am missing in the first version? Thanks, Goran Tag: Sybase Processes Problem Tag: 95043
 - 7
 - DataRelation's Nested property is seemingly ignored I have a strongly typed dataset (generated from Visual Studio schema designer) containing two related elements. In the resulting dataset class, the DataRelation's Nested property is set to true. Reading a conforming XML data document works fine, but when I create new child elements and write out the full dataset, the new child elements are not nested in the parent. For example, Staff and StaffMember are related by the DataRelation relationStaff_StaffMember whose Nested property is true. After adding a new StaffMember, "Lucas Gavitt", to the StaffDS dataset, the resulting file looks like this: <?xml version="1.0" standalone="yes"?> <StaffDS xmlns="http://mydomain.com/StaffDS.xsd"> <Staff> <StaffMember FirstName="Holli" LastName="Elliott"> <IsTeacher>true</IsTeacher> <IsActive>true</IsActive> </StaffMember> <StaffMember FirstName="Kristin" LastName="Barker"> <IsTeacher>true</IsTeacher> <IsActive>true</IsActive> </StaffMember> </Staff> <StaffMember FirstName="Lucas" LastName="Gavitt"> <IsTeacher>true</IsTeacher> <IsActive>true</IsActive> </StaffMember> </StaffDS> Any reason why the Nested property would be ignored for the new element? Thanks! Kristin Tag: Sybase Processes Problem Tag: 95041
 - 8
 - OLEDB data reader not reading Extended ASCII values properly -Help In our intranet website Login passwords are encrypted using a= function in Login=2Easp and stored in Oracle database=2E When a user= logs in his password information are retrieved from the oracle= table with recordset object, then we encrypt the password= entered by the user with same function and match both values,= accordingly user may allow or deny login=2E Now we started working= on a new project using ASP=2ENET but OLEDB data reader not reading= the ASCII values of password correctly=2E I tried with both Oracle= connection and OLEDB connection We are using =2ENet framework 1=2E1 version Please help me to overcome this problem; otherwise I have to= change the encryption in existing web application which is= stabilized and running since 2001 ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>5K+wzhK910KAvisPqp6dEA=3D=3D</Id> Tag: Sybase Processes Problem Tag: 95040
 - 9
 - OledbCommand queries I thought that a parmeterized query to an access database utilized parameter position and not name. However, I find that I can not get a successful ExecuteNonQuery() result unless the names of the parameters added to the oledbcommand.parameters.add("Name", OLEDBType) statements match the name of the parameter in the access database. Needless to say, position also is required. Am I getting this wrong or do name in addition to position matter? Thanks, E Bender Tag: Sybase Processes Problem Tag: 95036
 - 10
 - output parameter values not displaying properly I have a SQL Server stored procedure that outputs 4 parameters and a recordset. They are outputting just fine in Query Analyzer, but come out as [@gcLatestNav] = 1/1/0001 [@pubLatestNav] = 0 [@gcPreviousNav] = 1/1/0001 [@pubPreviousNav] = 0 -- Here is my stored procedure -- Create Procedure fn3MainNav @gcLatestNav int = 1 output, @pubLatestNav smalldatetime = '5/5/2002' output, @gcPreviousNav int = 1 output, @pubPreviousNav smalldatetime = '5/5/2002' output as SELECT TOP 1 @gcLatestNav = gc1.gc_id, @pubLatestNav = gc1.published SELECT TOP 1 @gcPreviousNav = gc1.gc_id, @pubPreviousNav = gc1.published FROM general_content gc1 -- Here's the relevant section of my .aspx code -- <% = pubLatestNav %> <% = gcLatestNav %> <% = pubPreviousNav %> <% = gcPreviousNav %> -- Here's my code behind -- Public Class mainNav Inherits System.Web.UI.UserControl #Region " Web Form Designer Generated Code " 'This call is required by the Web Form Designer. <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.SqlConnection1 = New System.Data.SqlClient.SqlConnection Me.SqlCommand1 = New System.Data.SqlClient.SqlCommand ' 'SqlConnection1 ' Me.SqlConnection1.ConnectionString = "server=myserver_2;database=mdb;uid=sa;pwd=mypwd;" ' 'SqlCommand1 ' Me.SqlCommand1.CommandText = "fn3MainNav" Me.SqlCommand1.CommandType = System.Data.CommandType.StoredProcedure Me.SqlCommand1.Connection = Me.SqlConnection1 Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@gcLatestNav", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Output, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing)) Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@pubLatestNav", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Output, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing)) Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@gcPreviousNav", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Output, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing)) Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@pubPreviousNav", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Output, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing)) End Sub Public gcLatestNav As Integer Public pubLatestNav As String Public gcPreviousNav As Integer Public pubPreviousNav As String Protected WithEvents SqlConnection1 As System.Data.SqlClient.SqlConnection Protected WithEvents SqlCommand1 As System.Data.SqlClient.SqlCommand 'NOTE: The following placeholder declaration is required by the Web Form Designer. 'Do not delete or move it. Private designerPlaceholderDeclaration As System.Object Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init 'CODEGEN: This method call is required by the Web Form Designer 'Do not modify it using the code editor. InitializeComponent() End Sub #End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here gcLatestNav = Me.SqlCommand1.Parameters("@gcLatestNav").Value pubLatestNav = FormatDateTime(Me.SqlCommand1.Parameters("@pubLatestNav").Value, DateFormat.ShortDate) gcPreviousNav = Me.SqlCommand1.Parameters("@gcPreviousNav").Value pubPreviousNav = FormatDateTime(Me.SqlCommand1.Parameters("@pubPreviousNav").Value, DateFormat.ShortDate) End Sub End Class from database right but showing -- _____ DC G Tag: Sybase Processes Problem Tag: 95027
 - 11
 - Sync with desktop app Hi We have an app with access db backend which is used to enter daily orders. Is it possible to upload these orders daily to a windows mobile 2003 device (we are using xda http://www.my-xda.com/), to allow each client to sign their order on delivery on the wm2003 device and then download all accepted orders back to the desktop app? What I am not sure is how to upload/download data from desktop (or server) to the wm2003 device and how to detect and record client signature. The xda's connect to individual PCs through usb and also connect to the windows 2003 server uisng gprs. Thanks Regards Tag: Sybase Processes Problem Tag: 95026
 - 12
 - "Failed to get schema for this stored proceure" I'm trying to configure an SqlDataAdapter to a stored procedure that has no recordsets, but rather a handful of output parameters. VS.Studio gives me "Failed to get schema for this stored procedure" -- _____ DC G Tag: Sybase Processes Problem Tag: 95019
 - 13
 - datagrid it's not showing relationships Hi. I have a strong type dataset. I have populated data in it. I added relationships because the generated code it's not including it. My problem is that I added the relations for some tables, not all of them but when binding the datagrid the relationships are not appearing. What can I do ? Tag: Sybase Processes Problem Tag: 95017
 - 14
 - Change password programatically for access database Hi there, I was wondering if it is at all possible to programatically change a password for an access database using VB.NET? Do I use a specific SQL command to perform such a task? Thanks in advance. Nick. Tag: Sybase Processes Problem Tag: 95016
 - 15
 - certain column is unchangeable Hi, all I have three columns in a datagrid, so what I need to do to make certain column unchangeable? For example, user can view column 1,2 and 3, but they can not change data in column 1. TIA. Tag: Sybase Processes Problem Tag: 95007
 - 16
 - How do I update child keys when I update their string data? I'm new to VB .NET and I've made an Access database with several one-to-many relationships. I want to display the data in a datagrid and give users the ability to edit the database. It's simple enough to import the database into a DataSet and display the string data that the keys point to using SQL INNER JOIN statements, but once the data has been updated, how do I use the new string data values to update the child keys that need to be returned to the database? Do I need to import the parent tables in their entirety and make a relational dataset? If anyone could point me to some example code that would be very helpful. Tag: Sybase Processes Problem Tag: 95004
 - 17
 - Lots of code Hi All, I have a connection and a table called Settings. Now i want to execute "Select Value from settings where setting='CID'" read this value Add One to this value and store it. Do i need 10 lines of code to do this or did i miss some cool feature Rob. Tag: Sybase Processes Problem Tag: 95001
 - 18
 - Problems with Password Protected Access DB I can access a password protected mdb file just fine when I write a VB dotnet windows application. However using the same connection string and running in a VB dotnet web application I get an exception: "The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\fpdb\NewGoodGas.mdb'. It is already opened exclusively by another user, or you need permission to view its data." It is not already opened so it must be the permission thing. Any ideas? Dan P.S. Sorry for the double posting - didn't know which ng this should go to. Tag: Sybase Processes Problem Tag: 95000
 - 19
 - how to access and display an output parameter I would like to know how to set an output parameter to a variable and output it on a web form: This didn't work: Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@gcLatest", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Output, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, ???THEVARIABLE???)) <% = THEVARIABLE %> -- _____ DC G Tag: Sybase Processes Problem Tag: 94993
 - 20
 - In memory sort a DataTable in DataSet Hi, I have a DataSet, returned by a stored procudure, which has only on DataTable. At this step there is no sort in DataTable. Is there is a way I can do to sort DataRows in this DataTable (not from select statement of sql query) in memory? Thanks -- WWW: http://hardywang.1accesshost.com ICQ: 3359839 yours Hardy Tag: Sybase Processes Problem Tag: 94991
 - 21
 - help trying to pass in a parameter I am trying to pass an input parater to SQL Server. The parameter is a URL querystring variable. I can't seem to get it to pass a variable, only a literal value... Help! In the following example, the @archiveType parameter accepts the "all" sample value. If I replace "all" with Request.QueryString("archiveType"), it doesn't work. What am I doing wrong? 'SqlSelectCommand1 ' Me.SqlSelectCommand1.CommandText = "[myProcedure]" Me.SqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure Me.SqlSelectCommand1.Connection = Me.SqlConnection1 Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing)) Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@archiveType", System.Data.SqlDbType.VarChar, 5, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, "all")) --------------------------------- Here's the procedure: CREATE PROCEDURE myProcedure @archiveType varchar(5) as SELECT col1 FROM table1 WHERE col1 = @archiveType -- _____ DC G Tag: Sybase Processes Problem Tag: 94983
 - 22
 - SQLDbType Error. Need quick solution please. I'm using abstract interfaces to implement my business solution, and can't seem to find a way to pass SmallMoney to my stored procedure without casting up to a SqlDataParameter. I've tried DbType.Decimal, DbType.Currency, and DbType.Double. conn.Open(); cmd = conn.CreateCommand(); cmd.CommandText = "MyProc"; cmd.CommandType = CommandType.StoredProcedure; {...} IDataParameter pqty = cmd.CreateParameter(); pqty.ParameterName = "@Quantity"; pqty.DbType = DbType.Currenccy; {...} cmd.Parameters.Add(pqty); s.Add(ppolldate); cmd.Prepare(); {...} cmd.ExecuteNonQuery(); //<-- Code breaks here. I get the infamous System Error with the following Inner Exception: "Error converting data type money to smallmoney." Please Help. Thanks. --ROBERT Tag: Sybase Processes Problem Tag: 94982
 - 23
 - SP fails, but OleDbCommand does not throw error! BlankI have found a major problem with the OleDb portion of ADO.NET. If you are using it to call a stored procedure and the procedure has an internal error of some type, the sp will fail, but the OleDbCommand object will not throw any type of error. For example, I have a proc that does an insert and I pass in a value for one of the parameters that will cause a foreign key violation. The call the proc will complete but nothing will be inserted. I can create that same insert statement and call it with an OleDbCommand object and will get the error. Other than a return value, does anyone know how to get a call to an SP to throw an error when it fails?????? -- John Mark Howell Tag: Sybase Processes Problem Tag: 94980
 - 24
 - Query Problems Hi, I'm trying to port the IGo Portal on the gotdotnet site from vb.net to c#. I'm having problems with the following: public DataSet GetAnnouncements(int moduleId) { // Create Instance of Connection and Command Object SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]); SqlDataAdapter myCommand = new SqlDataAdapter("SELECT ItemID, CreatedByUser, CreatedDate, Title, MoreLink, MobileMoreLink, ExpireDate, Description FROM Portal_Announcements WHERE ModuleID = ? AND ExpireDate > ?", myConnection); // Mark the Command myCommand.SelectCommand.CommandType = CommandType.Text; // Add Parameters SqlParameter parameterModuleId = new SqlParameter("@ModuleID", SqlDbType.Int, 4); parameterModuleId.Value = moduleId; myCommand.SelectCommand.Parameters.Add(parameterModuleId); // Add Parameters SqlParameter parameterExpireDate = new SqlParameter("@ExpireDate", SqlDbType.DateTime); parameterExpireDate.Value = DateTime.Now; myCommand.SelectCommand.Parameters.Add(parameterExpireDate); // Create and Fill the DataSet DataSet myDataSet = new DataSet(); myCommand.Fill(myDataSet); // Return the DataSet return myDataSet; } I get this error: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '?'. Does anyone have any ideas? Thanks. - Don Kim Tag: Sybase Processes Problem Tag: 94979
 - 25
 - Parameters vs. Dynamic SQL Ok I know the pro's and con's of this subject http://www.knowdotnet.com/articles/dynamisql.html I'm trying to convert my colleagues, but they are stuck on one thing = with dynamic sql, when they have a problem it is much easier to get the = exact view of the sql statement with the values they've loaded onto it = when they debug. So if they see an error they can cut/paste the entire = string to query analyzer and investigate. Is there an easy way to do this when using parameters. Something that = would "fill in the blanks" for me, just so I can see what the end result = sql would look like? Thanks, --Michael Tag: Sybase Processes Problem Tag: 94977
- Next
 - 1
 - Use connection pool after sql server restart the query will fail This is a multi-part message in MIME format. ------=_NextPart_000_008D_01C494C4.3F6C75B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, If I use the connection pool (It is default) in ADO sql server = provider,=20 it will get trouble to run any sql after the sql server restarted. Is ther a way to detect the pooling connection is valid ?=20 The SqlConnection state is useless.=20 It can not reflect the real situation when we use pooling connection. If I switch to use non pooling connection, it is ok.=20 I still prefer to use pooling connection. Is any way to solve the = problem ? Thanks. The sample code that I get the trouble is below. try {=20 string connectionstring =3D"Server=3Dlocalhost;Initial = Catalog=3DNorthWind;user id=3Dsa;pwd=3Dsapassword"; string strquery =3D "select * from categories"; string strcolumn =3D "categoryid"; //connectionstring +=3D ";Pooling=3Dfalse"; SqlConnection conn =3D new SqlConnection(); conn.ConnectionString =3D connectionstring; conn.Open();=20 SqlCommand cmd =3D new SqlCommand(strquery,conn); SqlDataReader reader =3D cmd.ExecuteReader(); int id ; while( reader.Read() ) { id=3D reader.GetInt32( reader.GetOrdinal(strcolumn)); //Debug.WriteLine(id.ToString());=20 } reader.Close(); conn.Close(); // Net Stop mssqlserver // Net Start mssqlserver conn =3D new SqlConnection(); conn.ConnectionString =3D connectionstring; conn.Open();=20 //Debug.WriteLine("ServerVersion: " + conn.ServerVersion + "\nState: " + conn.State.ToString()); cmd =3D new SqlCommand(strquery,conn); reader =3D cmd.ExecuteReader(); // Exception will raise here while( reader.Read() ) { id=3D reader.GetInt32( reader.GetOrdinal(strcolumn)); //Debug.WriteLine(id.ToString());=20 } reader.Close(); conn.Close(); } catch( Exception ex) { string str =3D ex.Message; //"General network error. Check your network = documentation. //Debug.WriteLine(str);=20 } Guo ------=_NextPart_000_008D_01C494C4.3F6C75B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV>Hi,</DIV> <DIV> </DIV> <DIV>   If I use the connection = pool (It is=20 default) in ADO sql server provider, </DIV> <DIV>it will get trouble to run any sql = after the sql=20 server restarted.</DIV> <DIV>Is ther a way to detect the pooling = connection is=20 valid ? </DIV> <DIV>The SqlConnection state is useless. = </DIV> <DIV>It can not reflect the real situation = when we use=20 pooling connection.</DIV> <DIV>If I switch to use non pooling = connection,  it=20 is ok. </DIV> <DIV>I still prefer to use pooling = connection. Is any=20 way to solve the problem ?</DIV> <DIV> </DIV> <DIV>Thanks.</DIV> <DIV> </DIV> <DIV>The sample code that I get the trouble = is=20 below.</DIV> <DIV> try { string connectionstring = =3D"Server=3Dlocalhost;Initial=20 Catalog=3DNorthWind;user id=3Dsa;pwd=3Dsapassword"; string strquery =3D "select * from=20 categories"; string strcolumn =3D = "categoryid"; //connectionstring +=3D = ";Pooling=3Dfalse"; SqlConnection conn =3D new = SqlConnection(); conn.ConnectionString =3D = connectionstring; conn.Open(); SqlCommand cmd =3D new=20 SqlCommand(strquery,conn); SqlDataReader reader =3D=20 cmd.ExecuteReader(); int id ; while( reader.Read() ) { id=3D reader.GetInt32(=20 reader.GetOrdinal(strcolumn)); //Debug.WriteLine(id.ToString()); = } reader.Close(); conn.Close(); // Net Stop mssqlserver // Net Start mssqlserver conn =3D new SqlConnection(); conn.ConnectionString =3D = connectionstring; conn.Open(); //Debug.WriteLine("ServerVersion: " +=20 conn.ServerVersion + "\nState: " + = conn.State.ToString()); cmd =3D new = SqlCommand(strquery,conn); reader =3D=20 cmd.ExecuteReader();   // Exception will raise = here while( reader.Read() ) { id=3D reader.GetInt32(=20 reader.GetOrdinal(strcolumn)); //Debug.WriteLine(id.ToString()); = } reader.Close(); conn.Close(); } catch( Exception ex) { string str =3D ex.Message; //"General = network error.=20 Check your network documentation. //Debug.WriteLine(str); }</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Guo</DIV></BODY></HTML> ------=_NextPart_000_008D_01C494C4.3F6C75B0-- Tag: Sybase Processes Problem Tag: 94976
 - 2
 - dataset to database not updating http://support.microsoft.com/default.aspx?scid=kb;EN-US;815660 on this online tutorial i have thi line that i do not understand... -------------------------------------------------- To update the original database with all of these changes, pass the DataSet into the Update method of the DataAdapter object. However, before you can call Update, you must set the InsertCommand, UpdateCommand, and DeleteCommand properties of the DataAdapter object. You can manually write SQL and populate these three properties with corresponding SqlCommand objects, but you can also use Visual Studio .NET to generate these three commands automatically. To generate the required commands when they are needed, you must create an instance of the SqlCommandBuilder object and use the DataAdapter in the constructor. If you want to use this method (shown in the code sample that follows), you must have primary key information available for your table. To access primary key information, call FillSchema, and then set the MissingSchemaAction property of your DataAdapter to AddWithKey, or manually set the primary key in your code. -------------------------------------------- I open and created a data binding connection to the form controls using the wizard and i works fine... But i can not make the changes made into the dataSet to go also no the database when i press the confirm button on the form. I used the VS wizard to create the connection, but something must be missing? How do i set the InsertCommand, UpdateCommand, and DeleteCommand properties of the DataAdapter object? Tag: Sybase Processes Problem Tag: 94971
 - 3
 - How can I update teh database via datagrid I have created a view of a database on the screen via datagrid. Users can change this data. How can I update the database with this data? Can somebody please help me.. //To get one row on the screen private void Button1_Click(object sender, System.EventArgs e) {DataView firstview = new DataView(); sqlDataAdapter1.Fill(test,"tblUser"); firstview.Table = test.Tables["tblUser"]; DataGrid1.DataSource = firstview; DataGrid1.DataBind(); } //Change the row in the database with the input private void Button2_Click(object sender, System.EventArgs e) {sqlDataAdapter1.Update(test,"tblUser"); } ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>xa4+U6n4kUWbNI6NufVTsg==</Id> Tag: Sybase Processes Problem Tag: 94970
 - 4
 - SQL-query with ADO.NET How to do something like IIf with Sql-query using Sql-Server 2000? I mean my database table has bit(boolean) field, and if this bit field is on (true) then calculation field should use other formula than when this bit-field is not on (false) like ... IIF(MyTable.BitField = true, "FieldA + FieldB", "FieldA + FieldC") AS SumValue I think this should be easy, but I haven't succeeded yet. Yes, I know this is not Sql-query question, but I need this query with ADO.NET :) -- Thanks in advance! Mika Tag: Sybase Processes Problem Tag: 94966
 - 5
 - date selection not working in sql Hi The following SQL statement returns what I would expect "select * from polls where ref = '" + ref + "' order by jobDate" This one always fails "select * from polls where ref = '" + ref + "' and jobdate = #" + CType(sdate, string) + "# order by jobDate" Anyone know why? We are using VB.Net & ADO to Jet Database Thanks in advance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.752 / Virus Database: 503 - Release Date: 03/09/2004 Tag: Sybase Processes Problem Tag: 94964
 - 6
 - many-to-many relationships (m:n) Hi, is there anybody out there knowing about a good way (best practice) or ressource describing how to display and manage a many-to-many relationship on a WinForm? I have exactly the same situation reflected in the MS 'pubs' sample-db. There are authors and books. An author could have written many books and a book could have been written by many authors. The relationship is held in the titleauthor table. I'd like to have a WinForm where I can select a book and it shows me the corresponding authors. How to do that? Additionally I'd like to have the opportunity to add authors to a book while keeping track of the order attribute (reflected in the titleauthor.au_ord column). Any suggestions? Regards, Lorenz Tag: Sybase Processes Problem Tag: 94963
 - 7
 - help setting up factory design pattern I am attempting to set up a factory design pattern for my data access design. In my investigation, I have been unable to find anything in regards to the dbtypes for the different datatypes. ie SqlClient, OracleClient etc. Does anyone have any examples of this, or point me to a web site that I can look at. Thanks in advance Darren Tag: Sybase Processes Problem Tag: 94962
 - 8
 - MS Oracle Client - OCI throws "Specified module could not be found Hi, We are trying to connect oracle 9i database through windows services application using ADO.NET [MS Oracle Client]. When the service tries to connect oracle 9i database, OCI.DLL throws an exception as "The specified module could not be found". The same code is working good when we run as a windows application or web application. The issue is only when we call the same code from windows services. Environment Details: Windows 2003 stand-alone server Oracle 9i [ 9.2.0.1.0 ] Database Server/Client MS .NET v1.1 Any immediate help would be greatly appreciated. Thanks. Prabakaran.G Tag: Sybase Processes Problem Tag: 94953
 - 9
 - DataSet Foreign Key Constraint Error I have a dataset with a parent table and 3 child tables. The dataset is filled and manipulated on one particular web page. During the user interaction one of the child tables can have records inserted,edited, or deleted. Upon clicking save I call the Update method of my dataAdapter mapped to the child table in my db and pass the dataset childtable in as a parameter. I'm getting an inconsistent foreign key constraint error. The error is telling me that a certain child key value(1768) must exist in the parent table. The value I'm being given is the parent primary key of one of the records in my database. The strange thing is upon entry into the aspx page an entirely different parent record and related children records were loaded into the dataset. How am I getting this rogue child record in my dataset for an entirely different parent record than the one I'me inserting child records for? I thought I may be loading my dataset with more child rows than I wanted but my dataset should give the same foreign key constraint error if I try loading rogue child records without the parent record in the parent datatable. Anyone seen this type of bahavior before? I had a hunch that the auto generated SELECT statement appended to the INSERT statement of my dataadapter may be causing the issue so I got rid of it. Seems to have solved the problem, but I would like to know if this truly is the solution, or if I'm missing something else? Any suggestions on how to properly debug this error or alternate solutions are appreciated. Tag: Sybase Processes Problem Tag: 94952
 - 10
 - Connection Problem I suspect I am missing the obvious here but I don't see it. I am trying to establish a connection to an SQL Server from an ASP.NET page I have defined the subroutines shown below, I have myConn defined at the top of the page as: Friend myConn As SqlClient.SqlConnection and then when I try to execute the following code I get an error that "Object reference not set to an instance of an object" ------------------------------------------------------- CreateConnection() myConn.Open() --------------------------------------------------------------------- I must be missing something basic here? Wayne ================ SUB & FUNC ================== ' Create Connection Private Sub CreateConnection() Dim myConn As New SqlConnection(GetSQLConnectionString()) End Sub ' Returns database connection string Private Function GetSQLConnectionString() As String Return "Data Source = sql.myhost.com; Initial Catalog = wengert; User ID = myid; Password=xxxx" End Function Tag: Sybase Processes Problem Tag: 94951
 - 11
 - error handling when updating a datasource via a data adapter i'm updating a table using a data adapter and stored procedure as it's insert/update commands. in certain cases, i would like the stored procedure to throw an exception and fail -- or just return an error, and then i want to catch the exception at the .net application layer. how is the best way to handle this? i don't mind if the entire update fails, rather than just one of the updated rows in the dataset. i would just like to handle it simply. i wasn't successful with the docs on this one. much appreciated, matthew Tag: Sybase Processes Problem Tag: 94950
 - 12
 - SQL Server and MS VS 2003 ADO.Net I have downloaded SQL Server MSDE. I am trying to create a data adapter and a connection object. The server explorer shows the SQL Server with the pubs database loaded. When I drag the adapter onto the form the wizard starts. Thing is on the connections tab the fields are blank. Supposedly the database and server should be listed on the tab and recognised by my computer. I have tried the other adapters. Is the reason the this is so is because of a security issue? I have managed to get one of the data walkthroughs to work, so I am sure that the data in the database is there. Help! Thanks. -- Spencer Tag: Sybase Processes Problem Tag: 94948
 - 13
 - Array to Database Hi, I want to store a multi-dimensioned array to the database. For the application i am writing, it is not necessary to store this data in a row/column format. So in other words, i want to store it as 1 chunk of binary data. Is it possible to store a 2-dim array in a binary format in an image field (or some other field). If so, are there examples of how to do this anywhere? Additionally, how would i retrieve this data and store it back into a 2-dim array? Lastly, can I assume that I can pass the data to a stored proc in the same way that i would call an INSERT statement (w/ out using a stored proc)? Thank you for your help, Paul Tag: Sybase Processes Problem Tag: 94944
 - 14
 - Transforming a typed dataset Hello, I need to reorder a Typed DataSet in memory using an Xsl Transform. Most of the examples use stream which write to the hard disk or xml file. I want to do this in memory and then write the resulting Typed Dataset into a Session object which will be reused on multiple postbacks and then finally saved when editing is done. Get various problems depending on what objects I use, rather than go through each one I will post what I have and see if anyone can suggest where to go from here. Xsl is simple, reordering (this is done becuase onitemupdate of datagrid I delete element then add a new one. this is because there are different types of columns and the use="optional" in the xsd file didn't give me an extra method to remove by column row.MultipleSelect.Delete() Anyhow this is peripheral as I am already down the alley which I hope isn't blind. <?xml version="1.0" encoding="UTF-8" ?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output omit-xml-declaration="yes"/> <xsl:template match="/*"> <Test> <xsl:for-each select="/Test/Question"> <xsl:sort select="@id" order="ascending" data-type="number"/> <xsl:copy-of select="."/> </xsl:for-each> </Test> </xsl:template> </xsl:stylesheet> Method for reordering DataSet: try { XmlDataDocument xmlDoc = new XmlDataDocument(ds); XslTransform xslTran = new XslTransform(); xslTran.Load(Server.MapPath("QuestionSort.xslt")); System.IO.MemoryStream s = new System.IO.MemoryStream(); System.Xml.XmlTextWriter w = new XmlTextWriter( s, System.Text.Encoding.Default ); xslTran.Transform(xmlDoc, (XsltArgumentList)null,w,(XmlResolver)null); s.Position = 0; //reset position of the in-memory stream. StreamReader r = new StreamReader(s); Test dsnew = new Test(); dsnew.ReadXml( r.ReadToEnd() ); //this method saves to session object setDataSet(SessionTestName, dsnew); } catch (Exception ex) { ex = ex; } Thanks, matt Tag: Sybase Processes Problem Tag: 94943
 - 15
 - Binding a combobox to a related DataTable Hi all, I have a DataSet with 2 related DataTables. Here's a simplified schema: Member [MemberID(PK), FirstName, LastName, FacultyID(FK)] Faculty [FacultyID(PK), Name] I have a 1:n DataRelation between those tables named 'Faculty_Member': Faculty(1) ---> (n)Member Now the problem: I have a WinForm for editing the Members. Also important is that I'm using a DataView on the Member-table. I'd like to have a ComboBox for choosing the Faculty a Member belongs to. I don't know how to bind the combobox so it will display Faculty.Name, use Faculty.FacultyID as value and then propagate the changes made into the Member.FacultyID. Also when the CurrencyManager of the DataView changes its position I want the combobox to display the Faculty of that member. How do I get this to work? Can I use the DataRelation at all for that kind of purpose or do I have to populate the combobox manually? I'd be glad about any suggestions. Regards, Lorenz Tag: Sybase Processes Problem Tag: 94940
 - 16
 - ¿Se puede ejecutar scripts con C# al igual que podía con VBScript? ¿Se puede ejecutar scripts con C# al igual que podía con VBScript? Con VBScript escribo codigo en un archivo .vbs o .vbe y lo ejecuto, ¿como puedo hacer esto con C#, pues hago un .cs pero no se como ejecutarlo? Otra consulta: con Sqlserver 2000, puedo ejecutar trabajos con ActiveX, con VBScript y Javascript, ¿puedo hacer lo mismo con C#, es decir ejecutar scripts hechos en C#, con trabajos de Sqlserver 2000? Quiero automatizar ciertos procesos entre bases de Sqlserver 2000 usando scripts en C# y no se como hacerlo.. gracias, saludos.... Tag: Sybase Processes Problem Tag: 94935
 - 17
 - INSERT statement fails in Datagrid Hi I have hardcoded method to populate (Select), delete and update a database table through a datagrid, these 3 operations work, but all inserts fail. I have noted that when i add a row to the datagrid (insert), all columns have a defult value of (null) assigned to them prior to the insert. Once i have added my data, the insert still fails - even if i assign the next number in sequence to the primary key field. The error generated is a system error. I have the following line of code to handle the primary key in each operation cmd.Parameters["PrimaryKeyField"].SourceVersion = DataRowversion.Original Any suggestions Thanks Tag: Sybase Processes Problem Tag: 94933
 - 18
 - Updating Database I need help. I am trying to figure out the best way to uodate a database with information. I am gathering my information from text fields on a form and I just want to insert them into the database that I have. I tried builing the SQL string and then adding it to a command object and then executing a non query but .NET does not seem to like this approach. I have been reviewing the various VB .NET manuals and they seem to want me to fill a dataset. Can this be done without the dataset? Would I be better off just sticking with regular ADO for this kind of operation? I was trying something like the following and getting errors: Dim cn As OdbcConnection cn = New OdbcConnection("dsn=CMI;uid=;pwd=;") strSQL = "INSERT INTO Customer _(FirstName,LastName,Address,City,Province,PostalCode,Email)" strSQL += " VALUES ('" strSQL += "'" & Replace(txtFirstName.Text, "'", "''") & "'," strSQL += "'" & Replace(txtLastName.Text, "'", "''") & "'," strSQL += "'" & Replace(txtAddress.Text, "'", "''") & "'," strSQL += "'" & Replace(txtCity.Text, "'", "''") & "'," strSQL += "'" & Replace(txtProvince.Text, "'", "''") & "'," strSQL += "'" & Replace(txtPostal.Text, "'", "''") & "'," strSQL += "'" & Replace(txtEmail.Text, "'", "''") & "')" cn.Open() Dim cmdInsertCustomer As New OdbcCommand(strSQL, cn) cmdInsertCustomer.ExecuteNonQuery() cn.Close() Can anyone suggest a way I could accomplish what I need to do here. Many thanks. Tag: Sybase Processes Problem Tag: 94930
 - 19
 - Copy table I have a dataset which contains a table which holds 4 columns. I want to copy column 2 and 3 into a new table with their contents. How ? Tag: Sybase Processes Problem Tag: 94926
 - 20
 - Dataset and typed datasets Hi, is there a way to cast a normal dataset to a typed dataset? I tried using the directcast but that didn't seem to work. Thx Tag: Sybase Processes Problem Tag: 94922
 - 21
 - Oracle Connection Pooling Problem (Type your message here) I am using Oracle Data Provider ( System.Data.OracleClient) to connect to Oracle Database 8.1.7. When I set connection pooling to true in my connection string, sometimes, My application can not open connection to database. But when I set connection pooling to false, then everything works fine. It looks like that something is going wrong with connection pooling. -------------------------------- From: Basharat Ali ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>OUNLxeOji0iVMYBPJLFE/w==</Id> Tag: Sybase Processes Problem Tag: 94920
 - 22
 - sqldatareader compare to server side read only cursor in ado Hi, SqlDataReader must be connected to the database in order to bring data. this is like server side cursor read only in ado. the point is that in the SQL Profiler, when my code is running over the records in ado recordset with server side cursor, i see SQL activity for each move in the record. in SqlDataReader i don't see the same activity in the profiler for each record. can someone explane why is the difference and is the DataReader really a server side cursor? TIA, z. Tag: Sybase Processes Problem Tag: 94917
 - 23
 - Ado.Net can't create Adapter ? I create a table in SQL 2000 with 100 columns, want to use SqlAdapter or OleDbAdapter access it, but I can't create Insert,Delete,Update command, why? How to do it? thanks! -----> create table kjcg ( itemid numeric identity, item_cglb nvarchar(1) not null, item_32 nchar(1) not null, item_140 nchar(1) not null, item_110 nchar(1) not null, item_64 nvarchar(3) not null, item_304 nchar(1) not null, item_47 nchar(2) not null, item_305 nchar(1) not null, item_46 nchar(2) not null, uid int not null, item_21 nchar(1) not null, item_163 nchar(1) not null, item_200 nvarchar(15) not null, item_51 nchar(1) not null, item_300 nchar(1) null, item_125 nvarchar(15) null, item_2 nchar(1) not null, item_126 nvarchar(50) null, item_62 nchar(1) not null, item_15 nvarchar(10) not null, stateid int not null, item_9 nvarchar(140) null, item_41_3 nchar(2) not null, item_12 nvarchar(12) not null, item_16 nchar(1) not null, item_12_1 nvarchar(12) not null, item_63 nvarchar(3) not null, item_33 nchar(1) not null, item_201 nchar(1) not null, item_124_1 nvarchar(15) null, item_123 nchar(1) not null, item_15_1 nvarchar(10) not null, item_210 nchar(1) not null, item_1 nchar(1) not null, item_dqdm nvarchar(3) not null, item_4 nvarchar(10) not null, item_share bit not null, item_year int not null, item_upload bit not null, item_120 nvarchar(20) null, item_121 datetime not null, item_125_1 nvarchar(7) null, item_127 nvarchar(30) null, item_128 nvarchar(80) null, item_13 text null, item_13_1 text null, item_13_2 text null, item_13_3 text null, item_130 nvarchar(80) null, item_131 nvarchar(1) null, item_133 text null, item_32_1 nvarchar(10) null, item_14 nvarchar(200) null, item_141 money not null, item_142 money not null, item_142_1 money not null, item_142_2 money not null, item_142_3 money not null, item_143 money not null, item_144 money not null, item_145 money not null, item_148 money not null, item_149 money not null, item_150 money not null, item_151 money not null, item_152 money not null, item_153 money not null, item_154 money not null, item_160 nvarchar(30) null, item_161 nvarchar(10) null, item_162 money not null, item_22 nvarchar(30) null, item_3 nvarchar(140) null, item_301 nvarchar(80) null, item_302 nvarchar(14) null, item_303 text null, item_306 nvarchar(14) null, item_34 nvarchar(14) null, item_37 nvarchar(100) null, item_38 nvarchar(6) null, item_39 nvarchar(30) null, item_40 nvarchar(30) null, item_41 nvarchar(20) null, item_41_1 nvarchar(20) null, item_41_2 nvarchar(30) null, item_420 nvarchar(20) null, item_45 int not null, item_52 nvarchar(80) null, item_53 nvarchar(12) null, item_56 nvarchar(12) null, item_60 nvarchar(100) null, item_61 nvarchar(80) null, item_8 nvarchar(22) null, item_sjdc nvarchar(1) null, item_sjdr nvarchar(1) null, item_xh money not null, item_243 money not null, item_244 money not null, item_51_1 nvarchar(1) null, item_51_2 money not null, item_51_3 money not null, item_151_1 money not null, item_152_1 money not null, constraint PK_KJCG primary key (itemid) ) go Tag: Sybase Processes Problem Tag: 94905
 - 24
 - database path and dataadapters Hello, I connect to an access database through the ui oledbdataadapters. This is fine becuase the wizard prompts for a file location. Puttig my page on a server, I have run into a few diffilculties. The page still asks for c:\database\database.mdb. I have changed all the other events such as submit/delete etc to server.mappath("/database/database.mdb"). How then do i change that in the dataadapters? Tag: Sybase Processes Problem Tag: 94904
 - 25
 - How to execute a Transform SQL Query? I try to use a data adapter to fill a dataset with a transform sql query from ms access database. The query string works at ms access's query area but when I run the asp.net application, this error occures : "There is a syntax error near TRANSFORM ..." (error is in Turkish language so maybe this is not the exact translation). Isn't it possible to run TRANSFORM queries at ADO.Net? My querystring is : strQuery= "TRANSFORM iif(Count(records.isPaid) is null, 0,Count(records.isPaid)) AS PaymentCount" strQuery &= " SELECT records.paymentGroupID, records.explanation, Count(records.paymentGroupID) AS TotalPaymentCount, MAX(paymentDate) AS LastPaymentDate" strQuery &= " FROM(records)" strQuery &= " WHERE(records.paymentGroupID <> 0)" strQuery &= " GROUP BY records.paymentGroupID, records.explanation" strQuery &= " PIVOT records.isPaid;" Tag: Sybase Processes Problem Tag: 94903

Processes are staying open. I am closing my connections in my code,
but they do not close on the server. Once I reach the Max # of
processes everything bombs out.

The is Sybase ASE 12.0 running on Sun Solaris 9. I am using the
Sybase .NET Provider v1.1.

Any ideas?

TIA

Top