Stores Procedures with Informix

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
    - Cannot fill Dataset Hi, I am still a beginner concerning ADO.net. When I am trying to read data from a Access-file into a dataset I always fail... :-( I am using the following code. The DB-Connection (Me.Con) is established and open. The SQL-Code is correct and the specified table exists. Dim DA As New OleDbDataAdapter() DA.SelectCommand = New OleDbCommand _ ("SELECT MID, From, To, Subject FROM gmx", Me.Con) DA.TableMappings.Add("Table", "gmx") Dim Tbl As DataTable Dim NR As DataRow Dim DS As DataSet DS = New DataSet("gmx") DA.Fill(DS) .... The error "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll" occurs in at the DA.Fill(DS) Command. I can do what I want. I also tried just to fill a datatable, but I always get the same error. What am I doing wrong? Thanks, Sebastian Walters Tag: Stores Procedures with Informix Tag: 62990
  - 2
    - OleDbDataCommand problem I'm know the "old" implementation of ADO very well, and I am now trying to get used to ADO.NET. I've always preferred creating connection, commands and recordsets programmaticaly since every application I've built that needs data access allows for modifiable connection settings. This leads me to my question: When I create a OleDbConnection, OleDbCommand and OleDbDataReader to retrieve data from an Access database, everything works the way it should until I set the CommandText for the OleDbCommand object. It seems that if I try to order the results using the ORDER BY command an OleDbException is thrown with the following description: Unspecified error: E_FAIL(0x80004005) However, if I do not use and ORDER BY command, the exception is not thrown. Here's the code: public OleDbDataReader GetPopUps() { OleDbCommand cmd=new OleDbCommand(); OleDbDataReader dr; cmd.Connection=mcn; cmd.CommandType=CommandType.Text; cmd.CommandText="SELECT PUKey, Domain FROM PopUp ORDER BY Domain ASC"; dr = cmd.ExecuteReader(); cmd=null; return dr; } Any help would be greatly appreciated. Paul Tag: Stores Procedures with Informix Tag: 62989
  - 3
    - Can't find component or one of its dependencies?!? I have several COM+ objects (amongst others): BO.Dispatch, DAL.BaseDAL, Config, BF.Inventory, and DAL.Inventory Each object (except DAL.BaseDAL and Config) implements the IGateway interface (my creation; contains a single function, Gateway(String, String) As Object). Every object is registered in COM+ and the GAC. In this case, every object is in COM+ in a separate COM+ application, all as Server Applications running as the Interactive User. And I have the following sequence of events: TestApp.exe runs TestApp.exe calls a method on BO.Dispatch BO.Dispatch calls DAL.BaseDAL DAL.BaseDAL calls Config Config returns a connection string stored in the registry DAL.BaseDAL uses connection string to get a DataSet BO.Dispatch examines values in DataSet BO.Dispatch calls BF.Inventory BF.Inventory calls DAL.Inventory DAL.Inventory calls DAL.BaseDAL... What *should* happen is the DAL.BaseDAL calls Config for the connection string and gets another DataSet. However, I'm getting an error that DAL.Inventory can't create a DAL.BaseDAL object because it can't find it (full error is below). How can this be? It obviously *can* be found, since BO.Dispatch uses it just fine. All objects are compiled with references to the bin\[objectname].dll file they depend on, and the dependencies are set up so that, when I compile all the objects, DAL.BaseDAL is one of the first things to get compiled (after IGateway and Config). Specifically, here, both BO.Dispatch and DAL.Inventory are set to depend on BaseDAL. --Error follows-- {System.IO.FileNotFoundException} [System.IO.FileNotFoundException]: {System.IO.FileNotFoundException} HelpLink: Nothing InnerException: Nothing Message: "File or assembly name DAL.BaseDAL, or one of its dependencies, was not found." Source: "DAL.Inventory" StackTrace: " Server stack trace: at DAL.Inventory.SearchInventory(String Security, String Transaction) at DAL.Inventory.Gateway(String Security, String Transaction) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(Met hodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessa ge msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at DAL.Inventory.Gateway(String Security, String Transaction) at BF.Inventory.PassThrough(String Security, String Transaction) at BF.Inventory.Gateway(String Security, String Transaction) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(Met hodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessa ge msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [1]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at IGateway.Gateway(String Security, String Transaction) at modDispatch.ExecuteTransaction(String ObjectName, String Security, String Transaction) at BO.Dispatch.Gateway(String Security, String Transaction) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(Met hodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessa ge msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [2]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at BO.Dispatch.Gateway(String Security, String Transaction) at TestApp.Form1.Button1_Click(Object sender, EventArgs e) in C:\WMS\TestApp\Form1.vb:line 111" TargetSite: {System.Reflection.RuntimeMethodInfo} Tag: Stores Procedures with Informix Tag: 62985
  - 4
    - Object reference not set to an instance of an object I am constantly receiving the "Object reference not set to an instance of an object" Exception when I try to set the autoincrement to true. I found the Knowledge Base Article 819346 which seems to address the error message, but how do I know that this is what is causing the problem..? If this is the route I must take, is the only fix for this is to upgrade to .Net 2003??? Here is the line of code I am receiving error on: Dim IdCol As String = "type_id" Dim ParentTable As String = "PgmTypes" 'Error occurs here Ds1.Tables(ParentTable).Columns(IdCol).AutoIncrement = True Ds1.Tables(ParentTable).Columns(IdCol).AutoIncrementSeed = -1 Ds1.Tables(ParentTable).Columns(IdCol).AutoIncrementStep = -1 Ds1.Tables(ParentTable).PrimaryKey = New Object() {Ds1.Tables(ParentTable).Columns(0)} sqlDataAdp.Fill(Ds1, ParentTable) uwGrid.DataSource = Ds1 uwGrid.DataMember = ParentTable 'Set the datakeyfield for the row.datakey property population uwGrid.Bands(0).DataKeyField = IdCol uwGrid.DataBind() Any help would be great, Thanks. Tag: Stores Procedures with Informix Tag: 62981
  - 5
    - Read This Look in this group threads there is an enourmous thread on just this in the last week or so Tag: Stores Procedures with Informix Tag: 62970
  - 6
    - try/catch question In building a web or windows based application, I'm not sure how best to set up my structured error handling. And any suggestions or known practice tips will be greatly apprecited. :) Specifically, in my classes that are called by a form (Web/Windows), do I try to be specific about the errors that are trapped or be more generic. Do I then be more specific on the forms? For example: Class public class DoSomethingHere public sub ASubRoutine try -- implementaion code here --- catch ex as exception throw ex end try end sub end class Windows form pub class frmMain inherits system.windows.forms.form private sub DoASubRoutine dim x as nw aSubRoutine try x.ASubroutine catch ex as sqlexception -- implemention code for a sqlexception here -- catch ex as system.arithmaticexception -- implement code for arithmatic exception here --- catch ex as exception -- implement generic exception code here -- end try end sub end class Any tips, advice, or pointers would be greately appreciated. Tag: Stores Procedures with Informix Tag: 62966
  - 7
    - Would like to learn asp.net, ado.net Hello. I am looking for some individual tutoring on ASP.Net and ADO.Net, in conjunction with reading/writing to an Access database. Ideally, I would like to get a "hello world" database up and running. I have learned a bit about each of these technologies through reading, although I am finding it rough going combining them to get a real-world project going. Is there anybody who'd be available for this sort of thing? I own Office 2000 and Visual Studio.Net Professional, as well as have a .Net web hosting account. I live in San Francisco, CA, and can pay (what I think is) a reasonable hourly fee. If anybody is interested, please email me at msofficeguyNOSPAM@yahoo.com. (remove the NOSPAM part) Thanks. Tag: Stores Procedures with Informix Tag: 62964
  - 8
    - DropdownList SelectedIndexChanged event I am using the SelectIndexChanged event for a dropdownList control. Currently, the only way the SelectIndexChange event is fired is after a user changes the selection within the dropdownlist AND clicks a command button. Does anyone know how to get this event to fire (or some other event) right after the user changes the selection w/i the dropdownList control? Tag: Stores Procedures with Informix Tag: 62961
  - 9
    - DataGrid question Does anyone know if you can disable the grid from allowing manual creation of new records, i want to only allow programitic creation and only allow editing of existinf records to take place in the grid. TIA Tag: Stores Procedures with Informix Tag: 62954
  - 10
    - problem with displaying new row Hello, My problem must be very simple to solve, but I havennt found the answer yet, so any help is appreciated. I have a form with bound controls, mostly textboxes, to an access database. When I fill the dataset the datatable which is used in the binding correctly populates the controls on the form. All navigation buttons work perfectly. The edit and delete button do their work without a problem. After a delete the label which displays current and total records by counting the rows in the table is decreased by one as it should. My only problem is after I add a new row. The row is added, but I can not navigate to it. The counter adds 1 record, so I know the add was successfull, but when I want to go to the last record it just doesnt do it. It stops at record 14/15. I use the me.databidings(dt).position = dt.rows.count - 1 to jump to the last record, which normally works, bt doesnt after I added a record. Finally, when I stop the application and restart the record the new record is added to the database and I can use it like any other record. Any ideas why I cant navigate to the new record after I created it? Thanks in advance. Tag: Stores Procedures with Informix Tag: 62944
  - 11
    - Earn $500 to $700 per Week Downloading FREE Software We know it sounds TOO good to BE true, but it?s REAL! Our International Technology firm will pay you hard cash each time FREE software is downloaded. Best of all you will only have to download ONE piece of software ONE time for FREE and you can be on your way to earning BIG! FIND OUT MORE BY VISITING http://JeromeMcCrea.PlugUsIn4Cash.com Tag: Stores Procedures with Informix Tag: 62943
  - 12
    - Login failed for user '(null)'. Reason: Not associated vs asp.net ASP.NET vs SQL Server¸ I have an ASP.NET Application In IIS I checked the Integrated Windows Authentication option In Web.Config the connection string include Integrated Security = SSPI and Impersonate=true in Web.Config When I start then Web Application I have this messge Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Could you help me PS My account have the permission to connect to SQl Server the security model is base on role security I have many users Tag: Stores Procedures with Informix Tag: 62936
  - 13
    - calculated column in datatable using parent's columns Can I use the parent table's columns in the Expression property of a DataColumn? Tag: Stores Procedures with Informix Tag: 62933
  - 14
    - Weird Timeout Expired error Hello all, Here is current snapshot of our environment: ASP.NET (C#) .Net Framework 1.0 SP2 MDAC 2.71 (SP1) Windows 2000 (Build 2195 SP3) SQL Server 2000 - 8.00.760 (SP3) We are using Microsoft SqlHelper from the Application Blocks and we currently have connection pooling = no Every now and then we get two types of errors: First Error: "System.Data.SqlClient.SqlException: General network error. Check your network documentation." This error tends to go away if we refresh the browser. Second Error: "System.Data.SqlClient.SqlException: Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." What is interesting about this error is that the procedure being called takes 1 parameter (a state UID) and returns within 3 seconds. I was getting an exception immediately (no 3 second delay) if I passed a state returning couple of hundred records consisting of VARCHAR and INT values, but works fine if there are fewer or no return values. Once I executed that same procedure using Query Analyzer for the problem state, the application started to work fine. It is happening on various procedure calls every few hours. I have looked on Microsoft's newsgroups, google, and on MSDN but I cannot find anything that applied to us. Any input would be appreciated. Fadi Tag: Stores Procedures with Informix Tag: 62930
  - 15
    - enforcing FK constraints on datatables that are not in a DS Hi All, I've created two datatables dtCountries and dtCities in memory. I am able to create a FK constraint on dtCities without adding these datatables to a dataset. But unless I add them to a dataset I am not able to enforce the constraint. Is there any way to enforce FK constraint without adding them to a dataset? TIA Sankar Tag: Stores Procedures with Informix Tag: 62926
  - 16
    - Returning a cursor from a stored procedure How do I capture a resultset from a stored procedure with ado.net code? ALTER PROCEDURE dbo.sp_ins_contacts ( @FName nvarchar(50), @LName nvarchar(50), @Initials nvarchar(50), @IntakeDate smalldatetime, @SSN nchar(10), @Advisor nvarchar(50 ) AS SET NOCOUNT OFF; INSERT INTO tbl_Contacts(FName, LName, Initials, IntakeDate, SSN, Advisor) VALUES (@FName, @LName, @Initials, @IntakeDate, @SSN, @Advisor); SELECT ContactID, FName, LName, Initials, IntakeDate, SSN, Advisor FROM tbl_Contacts WHERE (ContactID = @@IDENTITY) Tag: Stores Procedures with Informix Tag: 62925
  - 17
    - Returning a cursor from a stored procedure How do I capture a resultset from a stored procedure with ado.net code? ALTER PROCEDURE dbo.sp_ins_contacts ( @FName nvarchar(50), @LName nvarchar(50), @Initials nvarchar(50), @IntakeDate smalldatetime, @SSN nchar(10), @Advisor nvarchar(50 ) AS SET NOCOUNT OFF; INSERT INTO tbl_Contacts(FName, LName, Initials, IntakeDate, SSN, Advisor) VALUES (@FName, @LName, @Initials, @IntakeDate, @SSN, @Advisor); SELECT ContactID, FName, LName, Initials, IntakeDate, SSN, Advisor FROM tbl_Contacts WHERE (ContactID = @@IDENTITY) Tag: Stores Procedures with Informix Tag: 62924
  - 18
    - DefaultViewManager In MSDN library, it says that when data binding if you bind to a DataTable, in fact you bind to its DefaultView, and if you bind to a DataSet, in fact you bind to its DefaultViewManager. It is true for DataTable. If I use the following binding: dataGrid1.DataSource = dataSet1.Employee; dataGrid1.DataMember = null; Everytime I change the filter, the DataGrid changes, too. dataSet1.Employee.DefaultView.RowFilter = "Name < 'H'"; However, if I use the following binding: dataGrid1.DataSource = dataSet1; dataGrid1.DataMember = "Employee"; When I change the filter, the DataGrid is not responding. dataSet1.DefaultViewManager.DataViewSettings ["Employee"].RowFilter = "Name < 'H'"; I saw some programmers work around the problem by constructing a new DataViewManager. I wonder why Microsoft doesn't admit there is a bug, or say this behavior is by design. JT Tag: Stores Procedures with Informix Tag: 62921
  - 19
    - How do I query a DataSet to get unique IDs? Hi, I have a DataSet that contains data pairs for computers and IP addresses. Because in some cases a computer has multiple IP addresses, the HardwareID is in the DataSet multiple times. I want to create a DataView that has only the unique HardwareID's in the DataSet. How do I query my DataSet to get these HardwareIDs? Someone suggested DISTINCT but I don't know how to use DISTINCT against a DataSet to create a DataView. Could someone help me with this? Thanks, Sam Tag: Stores Procedures with Informix Tag: 62912
  - 20
    - String Error in ADo.Net Dataset code I am developing an database appliction using SQL 7 with a Visual Basic Front End using ADO.Net. When generating a dataset from the DataAdapter all the Textboxes and ComboBoxes contain the following error "'Convert' is not a member of 'String'" in the autogenerated DataSet Name.vb file. The error occurs in the following type Subs: Public Sub SetinvestigationNull() Me(Me.tablerer.investigationColumn) = System.Convert.DBNull End Sub If I comment out the "Me(Me.tablerer.investigationColumn) = System.Convert.DBNull" portion of the Sub the code compiles and runs correctly. Since I have many textboxes in the VB form, about 40, that is a lot commenting to get the application to run correctly. Is were a way to get the code to compile? Thanks Joe Tag: Stores Procedures with Informix Tag: 62909
  - 21
    - data file to database Hello I have a data file like this : 01 "" "09:04" "PLMDX " 3.20 0.35 1.74 0.23 2.49 0.17 1.37 0.18 03 02 "" "09:05" "PLMDX " 3.70 0.18 1.93 0.14 2.75 0.19 1.05 0.01 03 03... 04... ..... and i want to read each number and fileds and save it to variables to save it in to the database . with stream reader and file rader i can only read all of it as a single string , is that possible to do it with regular expression ? i don't know how . any idea ... help please Tag: Stores Procedures with Informix Tag: 62891
  - 22
    - What happens when you delete a DataRow ? I know that the state is changed to deleted, but what else happens ?, does the table make a new version of itself each time or the row ? The reason i'm asking is because I'm have a tough time understanding how making changes to more than one row ( but not more than one change per row ) and then trying to update the dataadapter can cause a concurrency error. There are no other users involved any assistance is appreciated in understanding this . . . Regards - Terry Tag: Stores Procedures with Informix Tag: 62889
  - 23
    - Oracle or SQLServer - .NET or J2EE? Hello, I am doing a very large web based database project. Over the period of 5 years, "more than 100, 000 Books" will be stored in a Database along with a LARGE amount of book attributes majorly consists of very large amount of people reviews about a book. We then need to analyze or generate reports from that large volume of STATIC data in Infinite number of ways. My questions are: Q1. Just to get general sence, Which suits the best Oracle or SQL Server for this project and Why? Keeping scalibility, volume of data, etc. in mind? Q2. Which development platform best suits best for this kind of project .NET or J2EE and Why. Q3. We have to analyze or generate reports from that STATIC data in Infinite number of ways, Which analysis technology should be used and Why? Thanks, Rafey. Tag: Stores Procedures with Informix Tag: 62884
  - 24
    - Connection Pooling with Microsoft Access? Hello, Is it possible to connection pool with Microsoft Access? I am coding in VB.NET and my application is giving me errors because the connection is still open and fetching records. Thanks! Tag: Stores Procedures with Informix Tag: 62883
  - 25
    - Unexpected error in webform any body seen this error? No error information available: E_UNEXPECTED(0x8000FFFF). 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.OleDb.OleDbException: No error information available: E_UNEXPECTED(0x8000FFFF). It's random occuring mostly when i update the webserver with a fresh dll, but not every time. Only way around that is to re-start the application pool or re-start iis. My hunch at this time is that this is occuring because oledb and odbc providers are hosted in the same page. That's a wild guess though, not based on anything concrete. tia Tag: Stores Procedures with Informix Tag: 62856
- Next
  - 1
    - Cannot update Access database records I have code that inserts, updates, and deletes records from an Access 2002 table using OleDbCommand and OleDbConnections. Everything works great until I place the Access database on the network and more than one person launches the application. Everyone can still insert and delete but not update (using the custom app). Any ideas? Tag: Stores Procedures with Informix Tag: 62842
  - 2
    - [ANN] Innovation to ADO.NET - Object Access Services for .NET Innovation to ADO.NET - Object Access Services for .NET New Software Matisse Software Inc. provides its native ADO.NET Data provider for Matisse 6.0, the Database for .NET. Matisse Software has pushed the envelope of Microsoft ADO.NET architecture and extended it into a powerful Object Access Services component for .NET. Unlike the standard ADO.NET data provider, which returns data in a table format to integrate seamlessly with relational products, Matisse has extended the ADO.NET architecture to return data in an object format. http://www.matisse.com/ Tag: Stores Procedures with Informix Tag: 62836
  - 3
    - Schema problem with Strongly Typed dataset I have a strongly typed dataset whose schema looks as such: <?xml version="1.0" encoding="utf-8" ?> <xs:schema id="Dataset1" targetNamespace="http://tempuri.org/Dataset1.xsd" elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/Dataset1.xsd" xmlns:mstns="http://tempuri.org/Dataset1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="Dataset1" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="cc"> <xs:complexType> <xs:sequence> <xs:element name="usr" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="distributionList" nillable="true" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:simpleContent> <xs:extension base="xs:string" /> </xs:simpleContent> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="nam" type="xs:string" form="unqualified" /> <xs:attribute name="uid" type="xs:string" form="unqualified" /> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> I have a test function in a windows form in which I try to fill the dataset up with xml. My function looks as such: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ds As New Dataset1 Dim xreader As XmlReader Try Dim stream As New System.IO.StringReader("<cc>" & _ "<usr uid=""123"" nam=""Test User"">" & _ "<distributionList>testing</distributionList>" & _ "</usr>" & _ "</cc>") xreader = New XmlTextReader(stream) ' I am crashing here ds.ReadXml(xreader, XmlReadMode.InferSchema) MsgBox(ds.GetXml) Catch ex As Exception MsgBox(ex.Message) End Try End Sub My believe my problem lies in the schema. If I specify multiple or zero distributionList nodes the xml is read into the dataset correctly. If I specify just one distributionList node I get a "Specified cast is not valid". Am I missing something in the schema? Thanks, Collin Tag: Stores Procedures with Informix Tag: 62835
  - 4
    - Proposed method implementation in a new generic data access component I've mentioned in other posts that I am creating a generic ADO.NET project. Version 1 is already done actually (see my signature, and read synopsis in docs) I am making alot of additions in version 2. One being the addition of a bunch of classes that form a "Gen" provider... (GenConnection, GenDataAdapter, etc...). In the constructor of each data object I'm adding an additional parameter specifying the "DbContext". For example the standard IDbCommand constructor... public IDbCommand() //creates a standard Command, must set properties separately In my GenCommand as proposed... /// <summary> /// This constructor will use the connection of the /// DbContext if it has a ConnectionString assigned. /// </summary> /// <param name="ctx"></param> public GenCommand(DbContext ctx) { _ctx = ctx; _cmd = _ctx.DbTemplate.Command(); if (_ctx.ConnectionString.Length > 0) { _cmd.Connection = _ctx.Connection; } } Do you think it is a bad idea to imply the Connection from the context? I require the context to be able to dynamically load the appropriate underlying provider (Sql, OleDb, ODbc, etc...). But should I also use it to imply the connection. If the user desired they could overide it and specifiy a different connection. However, for those lazy people, the context gives enough info to specify the connection. It behaves different than all the other providers, which is why I'm wondering if it is a bad idea? Any advice? Which would you prefer as a user? -- Michael Lang, MCSD See my .NET open source projects http://sourceforge.net/projects/dbobjecter (code generator) http://sourceforge.net/projects/genadonet ("generic" ADO.NET) Tag: Stores Procedures with Informix Tag: 62830
  - 5
    - how can I get the path for the error ORA-01458 it is told on the microsoft web site that to resolve this=20 problem i must contact "the microsoft support service"=20 and they will send me the patch. THERE IS TONS OF MICROSOFT SUPPORT SERVICE... which one=20 must i contact and how much it will cost... I leave in qu=E9bec - canada (i speak french) thanks Tag: Stores Procedures with Informix Tag: 62827
  - 6
    - Why is this login failing? I am using VS in conjunction with SQL Server 2000. I am trying to create a new SQLConnection but am getting an error message of "Login failed. Not associated with a trusted SQL Server Connection" I drag a SQLConnection to my components tray. In the Connection String property I say New connection. I give the server name (which is the name of my computer) and put the radio on specific name and password. I enter a user name of sa and a password of xxx. I click on the field "Select the database on the server" and get the above mentioned error, followed by "Login failed, Catalog info can not be retrieved". In the past I have solved this problem by going into SQL Server and in the Server, Properties, Security tab changing the authenication to SQL Server and Windows. My notes indicate that in the past when I've had this problem it was because the authentication was not set to mixed. However this does not seem to fix the problem in this case. Does anyone have any idea what's going on? Tag: Stores Procedures with Informix Tag: 62826
  - 7
    - Record Locking? How would I go about locking records using ADO.Net? It seems that everything in ADO.Net is based upon opening a connection, retrieving data, and closing the connection. To keep the records locked, is it as simple as leaving the database connection open? ~Thanks Tag: Stores Procedures with Informix Tag: 62817
  - 8
    - What is the best way to delete multiple rows Grid, DataAdapter, Access Source What is the best way to delete multiple rows bound to a datagrid without getting a concurrency exception. TIA Tag: Stores Procedures with Informix Tag: 62816
  - 9
    - Connection String with Access Workgroup Info (mdw) I've searched through several forums without finding a definitive answer to this question: What is the proper syntax for a connection string that is connecting to an Access 97 db with workgroup security applied? I tried the following. I don't get an error, but it also displays NO results: Public Shared ReadOnly OleDbConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DBQ=c:\CORmandOTweb\NewSecure CORMandatoryOTList.mdb SystemDB=c:\inetpub\wwwroot\aspdotnet\cormandot\db\corrections.mdw;UID=usern ame;PWD=anything" Also tried: Dim cnn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=false;Data Source=" & System.Web.HttpContext.Current.Server.MapPath("/CORmandOTweb/NewSecure CORMandtoryOTList.mdb") & "; Jet OLEDB:System Database=c:\inetpub\wwwroot\aspdotnet\cormandot\db\corrections.mdw;UserID=us ername;Password=anything") All help will be greatly appreciated! Lynnette Tag: Stores Procedures with Informix Tag: 62802
  - 10
    - Concurrecy Error, anyone see what I'm doing wrong here ? This code takes the Person index drom the datagrid dgPeople and uses it to delete all the records from the dgEvents grid and underlying records. It works but i do get that concurrency message Case "Delete" Try 'open connection con.Open() 'Setup the Delete Command for events for this person DeleteCmd.CommandText = "DELETE * FROM [Events] WHERE PersonIndex = ?" DeleteCmd.Connection = con DeleteCmd.CommandType = CommandType.Text DeleteCmd.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_PersonIndex", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PersonIndex", System.Data.DataRowVersion.Original, Nothing)) Dim r As DataRow PersonIndex = CType(dgPeople.Item(dgPeople.CurrentRowIndex, 0), Int32) For Each r In tableEvents.Rows If PersonIndex = CType(r.Item(0), Int32) Then r.Delete() End If Next daEvents.DeleteCommand = DeleteCmd daEvents.Update(tableEvents) Catch ex As OleDbException MessageBox.Show(ex.Message) Finally con.Close() End Try Tag: Stores Procedures with Informix Tag: 62788
  - 11
    - Installation of VB.NET Program Let's say now that I have my program finished. How do I go about writing a setup program that would install the required directories, and place my files where they need to be? For starters, I have my exe file, and two jpg files that I want to bundle in an install program that will just create a folder on the desktop, and then create those files automatically. How could I do that? Also, what's the difference between Build Solution, Rebuild Solution, Build ProjectName, Rebuild ProjectName? Thanks Jordan Tag: Stores Procedures with Informix Tag: 62787
  - 12
    - ADO.NET xxxConnection best practice hello In my project i have classes whoes read,update , insert database for exemple in one method , i do 20 request which is best the practice ? a) open and close ADO.NET connection for each requests (using pooling connection but slower cause of .open() method ?) or b) open one connection for method , excute requests , close connection ( the pooling connection is use for the project and calls methods but not in each methods ) rq: my question is NOT for Execute multi request on one command , and NOT for using stored procedure thanks Tag: Stores Procedures with Informix Tag: 62783
  - 13
    - many repeatable operations Hi I have in my project (C#) many operation such as add, update, remove record from table. How to automate this. I don't wan to use grid. Are some code generators or something else to get this. The best for me is dialog with fields to fill in and verification of filled fields. Thanks Konrad Tag: Stores Procedures with Informix Tag: 62771
  - 14
    - Extending Typed "DataTables" I am facing the following problem in my applications and would like suggestions from you guys. My database schema has changed many times over the years and keeps chaging frequently according to specific client needs. My business layer (webservices) returns datasets to the thick client. The problem is that as the database changes so often, more than 800 datasets will have to be changed everytime. The solution suggested was as follows: a) Create 1 DataTable for each TABLE in the database. b) Create own DataSet for each visible screen or processing function by addind DataTables to this DataSet. c) Add Ref Contraints manually to this custom DataSet. This way, if the database changes, only one single DataTable class (schema) in the application will have to be changed. Now my problem is that i want to use Typed Datasets and Typed DataTables. What would be the best solution for this scenario. As mentioned on MSDN, DataTables can be instantiated independent of DataSets. In this case, the schema for the DataTable and the constraints are added manually in the code. But I could not find anything about extending Typed DataTables and using them independent of the DataSet. There is a powertoy by Shawn Wildermuth that helps you extend Typed DataSets, but i couldn't extrapolate his ideas to fit my requirements. Any ideas what the best thing for me would be ? Thanks, Nishith Tag: Stores Procedures with Informix Tag: 62769
  - 15
    - System.Type.GetType("System.Data.SqlTypes.SqlString") problem Hi, I'm trying to create a DataColumn with the following code: DataColumn dc = new DataColumn("CustomerID", System.Type.GetType("System.Data.SqlTypes.SqlString")); but the GetType method does not return a valid type. If I use "System.String" it works. If I create an instance of System.Data.SqlTypes.SqlString and the use the instance's GetType method inherited from System.Object I can get the type but I would like to get the type directly from Type.GetType. Can anyone see what I'm doing wrong? Is there another way to get what I need with a single method call? Thanks...Ron Tag: Stores Procedures with Informix Tag: 62764
  - 16
    - Transaction IsolationLevel Hi, I found the following statement regarding IsolationLevels in MSDN: "If changed during a transaction, the expected behavior of the server is to apply the new locking level to all statements remaining." (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html /frlrfsystemdataisolationlevelclasstopic.asp) My question is: if I already have a SqlTransaction running, and want to change the isolation level in the middle, how do I change it? I found that the SqlTransaction.IsolationLevel property is ReadOnly. Thanks for any help. Tag: Stores Procedures with Informix Tag: 62760
  - 17
    - Updating BLOBS to database I need to store the logo of my enterprise in a image field. I find the way to retreave this field, but a cant´t find the way to store my logo's file in a table. I'am using ado.net Thanks Tag: Stores Procedures with Informix Tag: 62749
  - 18
    - DataTable Events? I am getting started with DataTables and the DataGrid control. I want to find out when the user adds a row to a DataGrid, but I can't find a 'new row' or 'row added' method in either the DataGrid control or the DataTable class. I have bound a DataGrid to a stand-alone, in-memory DataTable. The user can edit the DataGrid cells and add new rows. When the user adds a new row, the calls all show "(null)", since they don't yet have values. I'd like to know when the user adds a new row, so I can plug in some default values, or do something to supress the "(null)" display in the cells. Is there an easy way to do that? Is an event fired when a user adds a new row? Thanks. -- Dave Veeneman davidv@nospam.com (actual domain is my last name) Tag: Stores Procedures with Informix Tag: 62748
  - 19
    - Autoincrement Key values in Relationships ADO.NET and Autoincrement fields. Recently, while attempting to use .NET to build an interface for a new system, I came upon the issue of using Autoincrement fields as Key values. In and of themselves, they are not terribly troublesome, but when used as part of a Key defining a Parent-Child relationship, things get a little sticky. Per the MicrosoftPress book, ADO.NET by David Sceppa, handling Autoincrement values in Parent-Child relationships is no bother at all. In chapter 11 - Advanced Updating Scenarios : Section 'Working with Autoincrement Values and Relational Data', Sceppa states, (after fetching the new Autoincrement value for the Parent record from the database)"...how do you apply the new Autoincrement values to the pending new line items? Actually, you don't. You let ADO.NET do the work for you through the DataRelation.". That statement is only half right. ADO.NET will in fact update the values through the DataRelation, but in the process, it changes the RowState of the (child) records from 'Added' to 'Modified'. Since this property is read- only, this effectively prevents the child records from being INSERTed into the database (because the DataAdapter now believes these records are NOT NEW, but simply existing records that have been modified. Using this methodology, your detail data will never get stored to the Database. Ever. In his book, Sceppa also discourages the use of Autoincrement values in favor of the GUID. Since that value can be generated by either the client or server, it is much easier to handle since you do not need any special code to retrieve the values from the Database after the row has been added. Except for the fact that GUID values CAN BE DUPLICATED, and the fact that they are four times larger than an (SQL)Int, this would probably be a good suggestion. Even if the uniqueness could be guaranteed, who wants to use a 16-byte random 'string' as a key value for lookups and cross referencing between tables!?!? After fighting with this particular issue for several days (and nights), and repeated attempts to find something resembling an answer on Microsoft's many websites, I found something that actually works, and is not terribly difficult to achieve. I would like to say that the idea, if not the code, came from Microsoft. It didn't. Let's use the standard ORDERS and ORDERDETAILS tables to illustrate.... ORDERS : PrimaryKey = (ORDER_ID) --------------------------------- ORDER_ID : Autoincrement (-1, -1) CUSTOMER_ID : Int .... ORDERDETAILS : PrimaryKey = (ORDER_ID + LINEITEM_ID) ---------------------------------------------------- ORDER_ID : Int LINEITEM_ID : Int .... DataRelation -------------------------------- Parent : ORDERS("ORDER_ID") Child : ORDERDETAILS("ORDER_ID") Let's say that a single new order has been added to the DataSet and has been assigned an ORDER_ID of -1. the new records would look something like this... ORDERS.Rows(0)("ORDER_ID") = -1 ORDERS.Rows(0)("CUSTOMER_ID") = 7026 .... ORDERS.Rows(0).RowState = Added ORDERDETAILS.Rows(0)("ORDER_ID") = -1 ORDERDETAILS.Rows(0)("LINEITEM_ID") = 27 .... ORDERDETAILS.Rows(0).RowState = Added In order for the Database assigned Autoincrement value to propagate to the child table in the relationship, you need to use the Parent tables Select method, and NOT GetChanges since GetChanges will not cascade the values to the ORDERDETAILS DataTable. The call would look something like this.... nEffectedRows = sdaORDERS.Update(ds.ORDERS.Select ("ORDER_ID < 0")) ----->Insert statement is as follows.... "INSERT INTO dbo.ORDERS(CUSTOMER_ID) "_ "VALUES (@CUSTOMER_ID) ; "_ "SELECT ORDER_ID, CUSTOMER_ID FROM dbo.ORDERS "_ "WHERE (@ORDER_ID = @@IDENTITY)" This will add the new ORDER record to the Database and return the new database assigned ORDER_ID, which in turn is stored in the appropriate ORDERS datarow. If the DataRelation is set up correctly and in effect, the ORDER_ID values in the Child record(s) will also be updated with the correct ORDER ID. This makes our records look like this... ORDERS.Rows(0)("ORDER_ID") = 99 ORDERS.Rows(0)("CUSTOMER_ID") = 7026 ORDERS.Rows(0).RowState = Unchanged ORDERDETAILS.Rows(0)("ORDER_ID") = 99 ORDERDETAILS.Rows(0)("LINEITEM_ID") = 27 ORDERDETAILS.Rows(0).RowState = Modified ... This brings us to the problem with using this method. At this point, we have called the Update method for the ORDERS DataAdapter, but NOT for the ORDERDETAILS DataAdapter. If you look at the RowState for the ORDERDETAILS row you will see that it has been changed from 'Added' to 'Modified'. If you now try to send this row to the DataAdapters Update method, it will attempt to UPDATE it rather than INSERT it. Obviously this fails since the row does not exist in the Database. What makes this really fun to deal with is the fact that the RowState property is READONLY. Microsoft does not offer any solution to this. Sceppa is obviously unaware of this problem since he goes on to say, "Once the new rows in the order details DataTable contain the appropriate values for the OrderID column, you can successfully submit the pending new rows to your database". No biggie. It's not the first time Microsoft has left out a detail or two. Solution. It took me about 5 days to find a combination of tactics that actually worked. The sequence of events are the same as what is described above, but with a couple of extra steps tossed in. The solution itself isn't terribly difficult to code, infact it's rather simplistic. What made it difficult was trying to do it 'their way'. The brief run-down is as follows.... <data has already been added - we are about to update the database with our changes > //------------------------------------------------------ //------------------------------------------------------ Dim xx, yy As Int16 Dim tOrdersAry() As DataRow Dim tDetailsAry() As DataRow ' Get our array of (POINTERS to) the ADDED ROWS... tOrdersAry = _ ds.ORDERS.Select("", "ORDER_ID", Added) tDetailsAry = _ ds.ORDERDETAILS.Select("", "ORDER_ID", Added) ' Now, update the ORDERS Table with the NEW records... xx = sdaORDERS.Update(tOrdersAry) Dim tempTable As DataTable tempTable = <dsClassDef>.ORDERS.Clone ' The ORDER_ID field is an Autoincrement column. ' TURN IT OFF!!!!! tempTable.Columns("ORDER_ID").AutoIncrement = False ' Copy over all the data from the real (Details) DataTable ' (which includes the new, correct ORDER_ID value)... Dim tmpRow, tmpRow2 As DataRow For Each tmpRow In tDetailsAry tmpRow2 = tempTable.NewRow tmpRow2("ORDER_ID") = tmpRow("ORDER_ID") tmpRow2("CUSTOMER_ID") = tmpRow("CUSTOMER_ID") tempTable.Rows.Add(tmpRow2) Next ' Update the Database with the 'Added' records... yy = sdaOREDRDETAILS.Update(tempTable) //------------------------------------------------------ //------------------------------------------------------ One detail left to do at this point is call the AcceptChanges method for the -real- rows in the ORDERDETAILS DataTable. Since this is dependant upon your particular handling of the transaction, I do not include that code in this example, though I would suggest handling the INSERTS in a separate transaction and calling the AcceptChanges method for each added (detail) row rather than for the entire table after all updates, inserts, and deletes. In closing, I would just like to add that under normal circumstances I would not have bothered to comment on this problem. I have in this case because Microsoft has documented this situation to a fair degree of detail, but has done so incorrectly, ineffectively, and when consulting more than one source, in a conflicting manner. I paid good money to buy a MicrosoftPress book since they, by all rights, should be the absolute experts on the subject. I then added to my confusion by consulting the Microsoft website to clarify, only to find more wrong answers (though stated in a very matter-of-fact manner). I freely admit that I have never, and I mean never, really liked Microsoft. Mostly because of their business practices, but also because of the quantity of bugs and known problems within their software (which will be fixed in the next release for only $xxx.xx!!). When the company I work for decided to use .NET for a system re-write, I began investigating it, and to my own surprise, I was very pleased with what I found. For the first time in twelve years, I had something NICE to say about Microsoft. However, as with everything else from MS, once you get down to the details, the documentation ALWAYS works better than the actual software. Tag: Stores Procedures with Informix Tag: 62743
  - 20
    - Problem with IConvertible and text column I'm trying to execute a stored procedure, which receives some parameters, to insert a row in a table. One of those parameters is defined with text data type, just as the column in the table. When I call that sp from my C# app, I get an exception of "Object must implement IConvertible". Although I call stored procedures daily, this is the first time I see this exception, and is the first time I use a text parameter in a sp. This is the C# code ... SqlParameter []parametros = new SqlParameter[4]; parametros[0] = new SqlParameter("@Id",SqlDbType.Int); parametros[1] = new SqlParameter("@Contenido",SqlDbType.Text); parametros[2] = new SqlParameter("@PalabrasClave",SqlDbType.VarChar,2048); parametros[3] = new SqlParameter("@Nombre",SqlDbType.VarChar,255); parametros[0].Value = objCanal.Id; parametros[1].Value = objCanal.Contenido; parametros[2].Value = objCanal.Palabras; parametros[3].Value = objCanal.Nombre; if (SqlHelper.ExecuteNonQuery(ConnectionString,"InsertarCanalEstatico",parametros) == 0) throw new Exception("Fila no insertada"); ... and this is the sp ALTER PROCEDURE dbo.InsertarCanalEstatico ( @Id int, @Contenido text, @PalabrasClave varchar(2048), @NombreCanal varchar(255) ) AS declare @cant int select @cant = count(*) from contenido where Id = @Id if @cant = 1 update Contenido set Contenido = @Contenido, PalabrasClave = @PalabrasClave, NombreCanal = @NombreCanal where Id = @Id else insert into Contenido (Id,Contenido,PalabrasClave,NombreCanal) values (@Id,@Contenido,@PalabrasClave,@NombreCanal) Tag: Stores Procedures with Informix Tag: 62739
  - 21
    - Problems connecting to Oracle using Oracle Provider for .Net Framwork Hello, Trying to use .Net oracle provider, but am getting the following error. I am using Oracle 9i client to Oracle 9i. Any ideas? Could not create an environment: OCIEnvCreate returned - 1. 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.Exception: Could not create an environment: OCIEnvCreate returned -1. Source Error: Line 27: Dim myConnection As OracleConnection = New OracleConnection(strConn) Line 28: Line 29: myConnection.Open() Line 30: Line 31: myConnection.close() Source File: c:\inetpub\wwwroot\HL7Delete\HL7Delete.aspx.vb Line: 29 Stack Trace: [Exception: Could not create an environment: OCIEnvCreate returned -1.] System.Data.OracleClient.DBObjectPool.GetObject (Boolean& isInTransaction) System.Data.OracleClient.OracleConnectionPoolManager.GetPo oledConnection(String encryptedConnectionString, OracleConnectionString options, Boolean& isInTransaction) System.Data.OracleClient.OracleConnection.OpenInternal (OracleConnectionString parsedConnectionString, Object transact) System.Data.OracleClient.OracleConnection.Open() HL7Delete.HL7Delete.getConfirmation() in c:\inetpub\wwwroot\HL7Delete\HL7Delete.aspx.vb:29 HL7Delete.HL7Delete.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\HL7Delete\HL7Delete.aspx.vb:23 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain() Tag: Stores Procedures with Informix Tag: 62735
  - 22
    - SQL Query for Datagrid Paging I under stand how to pull the results for all but the first page in the grid using one query or stored proc. If I could specify TOP 0 in the sub query, you would think that would work. Do I need to create another stored proc to pull the results for the first page of the datagrid? SELECT TOP 3 id, name FROM mytable WHERE id NOT IN (SELECT TOP 0 id FROM myTable ORDER BY name) ORDER BY name TIA, Steve Tag: Stores Procedures with Informix Tag: 62734
  - 23
    - timberline hello does someone knows how to access timberline accounting softwares database using .net? Tag: Stores Procedures with Informix Tag: 62724
  - 24
    - @@ROWCOUNT I am trying to return the Row Count from a stored proc Here is the sp CREATE PROC AS SELECT * FROM accounts RETURN @@ROWCOUNT GO Here is where I am pulling the return value, but I am getting nothing??? All the return parameters are set correctly. lblMessage.Text = cmdDepositoriesRetrieve.Parameters("@returnvalue").Value TIA, Steve Wofford www.IntraRELY.com Tag: Stores Procedures with Informix Tag: 62719
  - 25
    - Flexible Data Provider Architecture Hello, I need advice on how to design flexible data handling for an app that meets the following general installation options: 1. data on local machine, single user, probably using Access or FoxPro 2. data on network, multi-user, client server, SQL Server or Oracle 3. data on web service using SQL Server and IIS The option chosen must be transparent to the client. Currently my design is based on separating the client app from the data provider. The client instantiates a class from a separate dll that handles communication between the client and the data - currently SQL Server. I figured that I would later expand data handling to other data sources through subclassing. While I haven't since ruled this out, I'm guessing that the web service version will throw a wrench into this approach. The question is how to provide elegant and transparent switching between data handling code for a flexible and growing list of data providers. I'm tempted to implement an intermediate "generic" wrapper class containing all the methods needed by the client. The wrapper class would then farm out the actual work to provider-specific classes based on the provider in use. Unfortunately, I have yet to work with web services, so anything I come up with at this point would be a guess. Any advice would be appreciated. Randy Tag: Stores Procedures with Informix Tag: 62715

How I can handle to the stores procedures in informix
9.30?
Thanks

Re: Stores Procedures with Informix by John

John
Mon Aug 18 08:02:33 CDT 2003

In article <002201c364e6$f7fe7510$a501280a@phx.gbl>,
pablinvb@hotmail.com says...
> How I can handle to the stores procedures in informix
> 9.30?

For Informix 7.x using odbcnet I had to enter
"Execute Procedure [procedurename]" in order to use stored procs.

Hopefully this will work for you.

Top