OracleClient stored procedure parameter - can it handle 8 bit VarChars?

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
    - RowDeleting, RowChangeing, ColumnChanging exception handling As I figured out, the recomended way to cancel editing of a column, or deletion of a row is to create an event handler for ColumnChanging or RowDeleting events, and to throw your own exception. Well, I did just that, and the problem is that I do not know where to catch this exception. As I understand, it should be done somewhere in the DataGrid which is bound to the DataTable which raised an event, but I don't know where. Can anybody help me? Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88783
  - 2
    - parent column in child row Hello, I have a dataset with 2 tables and a relation (parent - child). I linked that ds to a datagrid. Shows everything fine (very little coding for such functionality!). But.. in the child row I want to show a column of the parent. Example: orderColumn shows customerId and I want the customerName which is located in the parent. How do I do that? Thanks in advance Frank Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88778
  - 3
    - DataTable.New() and Rows.Add() not working right I'm using a SqlReader to read results from a query and insert them into a DataTable. The DataTable is from a DataSet which contains an Xml that was read in using ReadXml(). My problem is, only 1 row gets written correctly. The others don't have any attributes and are not in the proper hierarchy in the Xml yet they're all created from the same loop. while (sqlReader.Read() ) { DataRow dr = dtProducts.NewRow(); dr.ItemArray[dr.Table.Columns.IndexOf("Col1")] = sqlReader.GetString(indexPT); ... ... // set more rows dtProducts.Rows.Add(dr); } ds.WriteXml(@"X:\temp\Test.xml"); Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88777
  - 4
    - SQL Stored Procedure not updating. Hoping someone can provide some insight into what I'm doing wrong here. I have a Win.Form with a bunch of text controls, bound to a Dataset (DsCustomerInfo1), and a ComboBox bound to the ClientID Field of that Dataset (DsCustomerInfo1.cw_clientinfo.ClientID) so that I can select a client ID, and get all the text boxes filled with data for the selected client. That all works beautifully. I edit the address field for instance, and hit my Update Client Button. Private Sub btnUpdateClient_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdateClient.Click Me.connExpress.Open() 'Open the connection Try Debug.Assert(Me.DsCustomerInfo1.HasChanges, "No Changes Present") Me.daCustomerInfo.Update(Me.DsCustomerInfo1, "CW_customerinfo") Catch ex As Exception MsgBox(ex.ToString, MsgBoxStyle.Critical, "SQL Error") End Try Me.connExpress.Close() 'Close the connection End Sub The Assert says that there are no changed Rows. I have a breakpoint on the daCustomerInfo.Update line, and I have a watch on CType(CType(DsCustomerInfo1.cw_customerinfo.rowCollection.Item(0),System.Dat a.DataRow),SupportTool.dsCustomerInfo.CW_customerinfoRow) Which is the row I'm changing. The Address field shows my new edited address, but the Rowstate property is Unchanged. I can select a new client from the Combobox, and come back to this one, and my new edited address is still displayed, but it hasn't been reflected back to the SQL Database. If I log out of the application and come back in, I'm back to my original address as stored in the SQL DB. Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88773
  - 5
    - [store procedure] + sqldatareader problem my simple store procedure like thiese:- CREATE PROCEDURE dbo.companyinfo_shipper_search @searchcode varchar(10) as select name from companyheader where code = @searchcode GO ------------------------------------------------------------------- my vb.net code cmdSearch.CommandType = "dbo.companyinfo_shipper_search" prmCompany_Code = cmdSearch.Parameters.Add("@searchcode", strCode) prmCompany_Code.Direction = ParameterDirection.Input prmCompany_Code.SqlDbType = SqlDbType.VarChar Try Dim drCompanyReader As SqlClient.SqlDataReader = cmdSearch.ExecuteReader(CommandBehavior.SequentialAccess) Do While drCompanyReader.Read Console.Write(drCompanyReader.GetString(0)) Loop ......etc I use sql analyzer to check and it really return the correct records. However, as I use sqldatareader, it returns error" Invalid attempt to read when no data is present". What's wrong with my code ??? Please help. Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88771
  - 6
    - Child Table In ado.net cannot have table as child of more than one parent. Is there a way around this? Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88749
  - 7
    - How to maintain state of the listbox while it is bound to Datasource? Hi I have bound my listbox to a dataset. But when I select multiple choices from the listbox, when I again come back to that list box the selected items are lost I have 2 tabs. One has bounded listbox, so when I select multiple items and then go to the other tab and then came back to the first one the selected items are lost Pl help Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88738
  - 8
    - Connecting to Excel via ADO.net: ISAM driver error Hi, I've got following problem: I'm trying to open a excel sheet via a ado.net oledb connection. but as soon as the function Open is called I'm getting an exception with following text: "Could not find installable ISAM driver". Looking in the msdn I found several issues to that problem. I checked the registry as described and re-registered the dll but that was effectless. Here's my code: string sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=J:\\MyDir\\MyExcelFile.xls" + /*+ ofdExcelSheet.FileName + */ ";Extended Properties=\"Excel 8.0;HDR=Yes\""; System.Diagnostics.Trace.WriteLine( sConnString ); System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection( sConnString ); cn.Open(); I'm using VS.NET 2003 and Office 2003 Does anyone have any expierences with that issue Thanks in Advance Markus Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88737
  - 9
    - DataTable.Select returns no rows on a date filter H I am using the DataTable Select to filter my data on a date column within the data table, as follows dr_DataRow = m_dt_ScheduleDataTable.Select("StartDate=#" & Format(dte_DiaryDate, "MM/dd/yyyy") & "#" This would appear to intermittently return rows, and I can't see why it does sometimes and doesn't on other occasions. The data table I have has 136 rows and the date I am initially testing with matches 22 of these rows. On occasions all 22 are reurned, other times just some of these and at other times no rows I also allow the user to filter on an integer column dr_DataRow = m_dt_ScheduleDataTable.Select("InterpreterID=" & CType(int_Interpreter, String) And this never seems to exhibit any problems so I think it must be a date issue. I am passing the string in in US format as you can see, although I am in UK and everything is in UK format, bit if I pass a date string in UK format it never returns rows and throws an error if I pass in a date which does not comply with US format e.g 16/05/2004, therefore leading me to believe that the Data table holds dates in US format regardless of all my system settings Has anyone seen anthing like this Thank Siobha Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88734
  - 10
    - How to create COM+ object which use .NET EnterpriceServices on remote machine? How to create COM+ object which use .NET EnterpriceServices on remote machine? I use on remote machine: object comObject; comObject = Activator.CreateInstance(Type.GetTypeFromCLSID(classGiud,remoteMachineName)) ; classGuid - GUID of class which inherits from serviced component. After execution this expression, It shows error like this: "Could not find server.dll assembly." Before I have been installed COM+ proxy. Can I deploy COM+ client as registered type library from server.dll? Thank You, Vasily! Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88733
  - 11
    - "MDAC required" but it's installed... Hi, I'm having this error in a VB.NET-application at the moment that I attempt to read data from an SQL Server: The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure However the MDAC 2.7 is installed! And when I look into the registry it is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\FullInstallVer = "2.71.9040.2" The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc. Does anybody know about thisp roblem? And some solution? Could it be because of some restictions (although I do have full Admin rights on the pc). I'ts really urgent and bothering me (I have to do a demo in 20 minutes, hehe). Thanks a lot in advance, any help, hints etc will be really appreciated! Pieter Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88729
  - 12
    - Getting OCI-22060 error while using Microsoft.Net's Oracle Provider Hi, I am trying to get data back from Oracle database using Microsoft .Net's Oracle Provider and I keep on getting a OCI-22060 error stating that argument [2] has unitialized value. SQL plus returns me the data I need without any problems, and for the same query I get this error on the web. This error only happens when I use a materialized view. If I don't use the MV and get data from all the tables everything is fine. However, since there was no automatic redirection of the queries to the MVs were taking place, I decided to write code to use the MVs directly, and that's when I got this error. Any help would be appreciated. Thanks, and best regards, - Amit. --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88723
  - 13
    - DBnull and checkBox when adding new record Yo, Got a checkbox which I databind at runtime to a numeric column. It works fine but when I add a new record I get the error: -------------------------------- An unhandled exception of type 'System.InvalidCastException' occurred in mscorlib.dll Additional information: Object cannot be cast from DBNull to other types. -------------------------------- I'm databinding just after adding a new record, so the order of events is: 1. Add new record code: private void AddRecord() { // daBuilding is my DataAdapter, dsBuilding is my DataSet. daBuilding.FillSchema(dsBuilding, System.Data.SchemaType.Source, "BUILDING"); this.BindingContext[dsBuilding, "BUILDING"].AddNew(); this.DataBindControls(); } 2. Databinding code: private void DataBindControls() { // Check the global flag to see if we have already databound controls. if (this.dataBound) return; . . // this is the line that craps out: chkHeritage.DataBindings.Add("Checked", this.dsBuilding, "BUILDING.HERITAGE_LISTED_YN"); chkHeritage.DataBindings["Checked"].Format += new ConvertEventHandler(NullToBoolean); . . // Set global flag so we don't have to databind again. this.dataBound = true; } My understanding is that you have to databind AFTER having retrieved a dataset to bind to, hence the FillSchema() call at the begining. But how does this work when you add a new record and have checkBoxes which don't know what to do with a null? Any advice on this greatly appreciated. Cheers, PeterZ Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88721
  - 14
    - data access for WinForms I am looking for architectural solution for data access from WinForms. For WebForms I am using MS Data Access Application Block with few modifications. DataReader methods help a lot and this was a big boost for my project. For WinForms requirements are quiet different. For a example databinding is must. If you have few windows opened all of them must be in synch. So Dataset objects comes to mind first but it requires so much coding, with any change to database I have to change Adapters, then regenerate dataset. VS has a lot of support for working with datasets but still a lot of hassle. I would prefer to create data access code separately from UI so in order to use VS tools for working with Dataset I use Components instead of classes. I just don't feel that it is considered rapid development. I just wanted to know if everybody works like this or there is some smarter solutions out there(please don't offer me to by $1000 application)? Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88719
  - 15
    - expression for a instantiation a DataColumnobject Hallo, i not unterstand the expression {oColPk}, see Row 18. What do have the braces with the instantiation a DataColumnobject? >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 1 Private Sub Test() 2 Dim oDsCustomer As DataSet 3 Dim oTblOrders As DataTable 4 Dim oColPk As DataColumn 5 6 'Eine Tabelle mit 3 Spalten im Arbeitsspeicher anlegen 7 oDsCustomer = New DataSet("CustomerOrders") 8 9 oTblOrders = New DataTable 10 oTblOrders = oDsCustomer.Tables.Add("Orders") 11 12 oColPk = New DataColumn 13 14 oColPk = oTblOrders.Columns.Add("OrderID", Type.GetType("System.Int32")) 15 oTblOrders.Columns.Add("OrderQuantity", Type.GetType("System.Int32")) 16 oTblOrders.Columns.Add("CompanyName", Type.GetType("System.String")) 17 18 oTblOrders.PrimaryKey = New DataColumn() {oColPk} '<--- What is that? 19 end Sub <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Greetings Wolfram Hubert Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88716
  - 16
    - DBConcurrencyException (without Concurrency Problems ?) I am experimenting with ADO.NET I use MySQL 3.23 with MyODBC 3.51 At the moment I simply try an insert a select and an update. I use the usual DataSet approach. The select works and retrieves the data from the database. When I try an update I always get a System.Data.DBConcurrencyException I have looked thru some Microsoft documentation and as far as I understood it a DBConcurrencyException is only thrown when the DataSet is out of sync with the database. I am pretty sure that I don't change the database between the filling of the DataSet and testing the Update statement. I have already looked at the DataRow which I try to update immediately before dataAdapter.Update(dataSetChanged); it seems hold the same data as as the database. Does anybody know what could cause this behavior, or give my some hints what to investigate? Many thanks, Hans Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88713
  - 17
    - Delete Record Question I have a SQLDataAdapter created with the wizard and having all of the commands including the DeleteCommand - I used the defaults. To delete a record, this works just fine: myDA.SelectCommand.Parameters("@mykey").Value = mykey myDS.Clear() myDA.Fill(myDS) If myDS.mytable.Rows.Count > 0 Then myDS.mytable.Rows.Item(0).Delete() myDA.Update(myDS) End If However, it seems that I should be able to do this in a more straightforward manner using the DeleteCommand. How should this be done with a minimum of code? thanks, T Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88710
  - 18
    - Oracle Connection Pooling Hello, I am trying to figure out connection pooling. I found this article which discussed the various options available on the connection string, unfortunately it was for the "oracle" provider and not the "Microsoft Oracle provider". Where can I find the options which are avialable for the Microsoft Version? How do I control the number of Connection which are in the pool? I placed this in my connection string "Min Pool Size=30" and it did not bark at me, but then again, I am not sure that it really opened 30 connections? How can I see how man connections are open for my application? I think I am opening connections and not closing them because after a while my application begins to have problems making a connection. Someone indicated that I should create "performance counters" to monitor how many connections are open at any one time. I have never set up performance counters. Does someon how a sample? Thanks in advance for your assistance!!!!! Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88709
  - 19
    - DeleteCommand.executenonquery with ADO.NET - How do I know if a record was deleted? After entering the sql statement da.deletecommand.commandtext = "Delete from Users where username = @username" I set the parameter to the username I wish to delete. This successfully deletes the user. However, even if I enter an non-existant user, I cannot discern whether a user was deleted or not. Is there a way to do this? (I would rather not use a dataset, since I am trying to increase performance). thanks in advance Rodger Dusatko Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88699
  - 20
    - data access layer function call Hi. I have the following requirement and I don't know which way I should approach it In a 3 tier application, the business layer calls a function in the data access layer; the data access layer function opens an Oracle connection, execute an "ExecuteScalar" instruction, closes the connection and returns the result to the business layer I would like to know which is the best way for handling both database errors and invalid data Right now, I wrapped connection.open and command.executescalar in a try/catch block with connection.close in the finally statment. Should I not do that? Should I move the try/catch block in my business layer wrapped around the data access layer function call? Btw, what is the difference between connection.close and connection.dispose - some MS examples have connection.close while others have both Where should I do my data validation? For example, should I throw an exception if the executescalar returns a null, that I should catch in the business layer, or should I have an IIf(retVal.IsDBNull, -1, retVal) statement? Is the data access layer supposed to return clean data Thank TM Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88695
  - 21
    - Dataset VS DataReader - Performance Hi All We have had a HOT discussion on the subject ... to resolve this I need a authentic answer (preferably with some supportings) to my question follows... What and How much difference (in terms of end-user user response time in seconds) it will make to an end-user of a web site if we use Typed DataSet as a dataobject OR custom defined dataobject.. 1) with @ 100 - 200 concurrent users in given circumstances... 2) web page needs to process about 500 Rows (@ 50 columns) (MAX 1000 rows in few circumstances. 3) once the processing is done dataset/datareader will be cleaned-up. 4) if we dont use dataset we will be using some custom defined dataobject, populated programmatically using by looping thru datareader 5) Inclination towards using typed - dataset is owing to ease of development, and other out-of-the box functionality provided by microsoft Any lights on this will be appriciated. Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88690
  - 22
    - Combobox issue. Hi All, I am working in VB.NET. I have a data bound control (combobox) which I want to fill with a certain field of my table from database ( SQL as backend). The issue is, I want these values to fill the combo at the index specified by me, ie, not the usual 0,1,2.... by default. Also, not dataset, but I am using dataReader. Can anyone send me the sample code for the same? Thanks for your help. Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88686
  - 23
    - Deleted Records and DataAdapter.Fill Dear All, Question Why DataAdapter.Fill does not refresh the deleted records in the dataset? If this is by design then how can I refresh the data and get rid of removed records without actually refilling the dataset with clear and fill operations? Detailed I have a DataAdapter refering to a table in database. The data is being shown in a DataGrid. As the data is updated, in the table (from other connection), it is reflected in the grid by a call to the Fill method of the DataAdapter. All is well , but if some row is deleted then the call to Fill method does not delete the record from its underlying DataSet. I have come to know that calling clear method is an option but it seems so dirty - clearing all the data and then getting it again. Can someone plz guide Why it is done this way and what is the resolution. Thank You Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88685
  - 24
    - Unusual binding problem with comboboxes and currency manager Unusual binding problem with comboboxes and currency manager I have an authors form that includes columns whose UI are comboboxes. On the form level I have Dim cm As CurrencyManager In the formload event handler I bind as follows: cm = CType(BindingContext(DsAuthorsTwo1, "Authors"), CurrencyManager) Here's what happened. The form would open to the first Author. The values for the columns represented by textboxes or in one case a checkbox were correct. The values for the columns represented by comboboxes were wrong. They were always the 0th selected index. If I moved the cm.position forward then back to 0, then the values would be correct. So I contrived the obvious at the bottom on the form_load event procedure: MsgBox(cboContentRights.SelectedIndex.ToString) -> 0 cm.Position += 1 cm.Position -= 1 MsgBox(cboContentRights.SelectedIndex.ToString) -> 3 (correct) There's got to be a more elegant way. polynomial5d Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88681
  - 25
    - TypedDataSet doesnot pass correctly in Web service This is a multi-part message in MIME format. ------=_NextPart_000_0122_01C446FD.9D8D7460 Content-Type: text/plain; charset="windows-1255" Content-Transfer-Encoding: quoted-printable Hi, I wrote (not using an automatic tool) a costum DataSet, called = MyDataSet, that holds only costum DataTables, called MyDataTable that = holds only MyDataRows.=20 MyDataSet derives from DataSet, MyDataTable derives from DataTable, and = MyDataRow from DataRow. The Tables collection of MyDataSet holds only = tables of type MyDataTable. Then, I wrote a web method that returns = MyDataSet. When I consume the method, I can see in the debuger that in the server = side, the objects are created correctlly. But when the answer returns to = the client side, the answer is indeed of type MyDataSet, but the tables = in the Tables collection are just DataTables (and not MyDataTable, as = was in the server side). I think that I have a problem with the XmlSerialization of MyDataTables. How can I fix this bug? Thanks, David ------=_NextPart_000_0122_01C446FD.9D8D7460 Content-Type: text/html; charset="windows-1255" 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=3Dwindows-1255"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY dir=3Dltr bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I wrote (not using an automatic tool) a = costum=20 <EM>DataSet</EM>, called <EM>MyDataSet</EM>, that holds only costum=20 <EM>DataTables</EM>, called <EM>MyDataTable </EM>that holds only=20 <EM>MyDataRows</EM>. </FONT></DIV> <DIV><FONT face=3DArial size=3D2><EM>MyDataSet </EM>derives from = <EM>DataSet</EM>,=20 <EM>MyDataTable </EM>derives from <EM>DataTable</EM>, and <EM>MyDataRow=20 </EM>from <EM>DataRow</EM>. The <EM>Tables </EM>collection of = <EM>MyDataSet=20 </EM>holds only tables of type <EM>MyDataTable</EM>. Then, </FONT><FONT=20 face=3DArial size=3D2>I wrote a web method that returns=20 <EM>MyDataSet</EM>.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>When I consume the method, I can see in = the debuger=20 that in the server side, the objects are created correctlly. But when = the answer=20 returns to the client side, the answer is indeed of type = <EM>MyDataSet</EM>, but=20 the tables in the <EM>Tables </EM>collection are just <EM>DataTables = </EM>(and=20 not <EM>MyDataTable</EM>, as was in the server side).</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I think that I have a problem with the=20 XmlSerialization of <EM>MyDataTables</EM>.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>How can I fix this bug?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Thanks, = David</FONT></DIV></BODY></HTML> ------=_NextPart_000_0122_01C446FD.9D8D7460-- Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88679
- Next
  - 1
    - DataColumn hi folks can i get information regarding precision and scale from datacolumn, without using adapter regards, and thanks in advance seril Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88678
  - 2
    - Problems using HasRows Hi. I am using VS.NET 2003. I have a function that runs a procedure and returns a SqlDataReader: Public Overloads Function RunProcedure(ByVal StoredProcName As String, _ ByVal Parameters As IDataParameter()) As SqlDataReader Dim cn As SqlConnection Dim cmd As SqlCommand Dim returnReader As SqlDataReader Try cn = New SqlConnection cn.ConnectionString = strConnectionString cn.Open() cmd = BuildQueryCommand(StoredProcName, Parameters) cmd.Connection = cn cmd.CommandType = CommandType.StoredProcedure returnReader = cmd.ExecuteReader(CommandBehavior.CloseConnection) Return returnReader End Function When I try to use HasRows on the caller routine, I receive the error: "Invalid attempt to HasRows when reader is closed". If I remove the CommandBehaviour.CloseConnection option from the DataReader this error goes away. Can't I use HasRows and CommandBehaviour.CloseConnection? Thanks, Robert Scheer Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88670
  - 3
    - INSERT INTO fails for SqlDbType.Text I want to inser a Text string as a BLOB When I try to insert a series of records I get the following problem -- System.Data.SqlClient.SqlException: String or binary data would be truncated My table has three nvarchar 50 columns, (MessageId, PutDate, MsgType and a Text column (RawMessage), which I want to use as large storage container for XML messages So I read the XML Messages and want to insert each into the Database The code of the INSERT Part looks like this private static void InsertIntoDB(byte[] msgId, DateTime putDate, string message tr string commandText = "INSERT INTO message (MessageId, PutDate, MsgType, RawMessage) " "VALUES ('"+BitConverter.ToString( msgId )+"','"+putDate.ToString("u")+"','Type',@RawMessage)" command.Connection = con command.CommandText = commandText command.Parameters.Clear() SqlParameter msg = new SqlParameter("@RawMessage",SqlDbType.Text,message.Length) msg.Value = message command.Parameters.Add( msg ) command.ExecuteNonQuery() catch(Exception e Console.WriteLine(e.ToString()) Console.WriteLine("Neither record is written to the database!") Any Help? Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88668
  - 4
    - very novice Find Button I have a DataForm bound to a dataSet "dsPhoneBook". I want to have a button "btnFind"on my form open a input box where I can enter a name and the record be set to the name I entered into the input box. I can not figure out how to do this. Need Help! Thanks Kent Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88665
  - 5
    - Merging Data with strong typed DataSet Hi there, I have a strong typed data set which is manually filled by me and then saved on local drive with "objDataSet.write(...)". When I generate two new DataSet with one that has the XMLSchema in it, and the other has the saved DataSet in it (objDataSet.ReadXML) and i do a "Merge" I get an error that the DataTypes of the columns arent matching. When I look at the Schema of the DataSet where I only loaded the data via ReadXML, I see that every column has the datatype "string". How to get arround this problem? Many thanks, i am hanging at this since about two weeks now. Greetz BenLeino CodeExtract: objDataSet = New Data.DataSet objDataSchema = New Data.DataSet objDataSet.ReadXml("C:\PPTR Workdirectory\pptr_tmp196\tmp1A5.xml") objDataSchema.ReadXmlSchema("C:\...\dsSchemaPPTPresentation.xsd") objDataSet.Merge(objDataSchema) Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88664
  - 6
    - Cannot connect to SQL Server I am not connecting to my sql server running local.programming in VB.net Database programming with statement Dim OConn As New SqlConnection("Data Source=localhost\\KIRZAD-APPLE;Initial Catalog=Northwind; UID=sa;PWD=") My server name is KIRZAD-APPLE OConn.Open() 'Throwing exception,probably not getting the server. Please help me.Bye. Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88660
  - 7
    - MDAC 2.8 on Win 2003, How do you repair or re-install MDAC 2.8 on Windows 2003 Server? Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88656
  - 8
    - Is there a .NET version of ADOX. ADOX is the extension ADO. And I wonder if there is any extension for ADO.NET? I need a object model in C#, with which I could easily access the schema of a database. Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88650
  - 9
    - Checking for NULL data Does null check have to explicitly be performed on every nullable value from a DataReader return. ie. for: DataReader dr = sqlCommand.ExecuteReader() while( dr.Read() { int intTestValue = dr.GetInt32( dr.GetOrdinal("TestValue")); } This will cause an exception if value is null, so do I have to do a special check for null on every return?? Or is there a more efficient way of doing this? Thanks Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88644
  - 10
    - Help: OleDbException: Operation must use an updateable query I do an UPDATE query in my ASP.NET page. On my development machine it works PERFECTLY. When I upload the site (inlcuding my Access MDB) to my production website and try to do the same update qry I get this error. Any ideas? System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at MyPage.EditHtml.cmdSave_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\EarlyAlert2\EditHtml.aspx.vb:line 151 Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88640
  - 11
    - Do I Have to Open a Connection 3 Times? I'm just starting to learn asp.net. What I have is a registration form for a message board system. Basically, the user enters in their info and it's validated. So I have a custom validator check to make sure the username is unique, I have another custom validator that makes sure the email address is unique and then I save the info to the database. That means I open the connection to the sqlserver 3 times. Seems inefficient to me. Is there a better way? Sub Button1_Click(sender As Object, e As EventArgs) if me.isvalid then Dim connectionString As String = "server='netsdk'; trusted_connection=true; database='db'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.Connection = dbConnection Dim uname as string Dim password as string Dim em as string Dim ip as string Dim rightnow as date ip = Request.UserHostAddress() rightnow = now uname = username.text password = password1.text em = email.text dbCommand.CommandType = System.Data.CommandType.StoredProcedure dbCommand.CommandText = "sp_register" Dim dbParam_username As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_username.ParameterName = "@username" dbParam_username.Value = uname dbParam_username.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_username) Dim dbParam_password As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_password.ParameterName = "@password" dbParam_password.Value = password dbParam_password.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_password) Dim dbParam_email As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_email.ParameterName = "@email" dbParam_email.Value = em dbParam_email.DbType = System.Data.DbType.String dbCommand.Parameters.Add(dbParam_email) Dim dbParam_ip As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_ip.ParameterName = "@ip" dbParam_ip.Value = ip dbParam_ip.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_ip) Dim dbParam_last_ip As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_last_ip.ParameterName = "@last_ip" dbParam_last_ip.Value = ip dbParam_last_ip.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_last_ip) Dim dbParam_created As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_created.ParameterName = "@created" dbParam_created.Value = rightnow dbParam_created.DbType = System.Data.DbType.DateTime dbCommand.Parameters.Add(dbParam_created) Dim dbParam_last As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_last.ParameterName = "@last" dbParam_last.Value = rightnow dbParam_last.DbType = System.Data.DbType.DateTime dbCommand.Parameters.Add(dbParam_last) Dim rowsAffected As Integer = 0 dbConnection.Open Try rowsAffected = dbCommand.ExecuteNonQuery Finally dbConnection.Close End Try 'Server.Transfer("index.aspx") end if End Sub Sub CustomValidator_Username( s As Object, e As ServerValidateEventArgs ) Dim connectionString As String = "server='netsdk'; trusted_connection=true; database='db'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.Connection = dbConnection dbCommand.CommandType = System.Data.CommandType.StoredProcedure dbCommand.CommandText = "sp_username" Dim dbParam_username As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_username.ParameterName = "@username" dbParam_username.Value = trim(e.value) dbParam_username.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_username) dbConnection.Open Dim cnt as integer cnt = dbCommand.ExecuteScalar If cnt = 0 Then e.IsValid = True Else e.IsValid = False End If End Sub Sub CustomValidator_Email( s As Object, e As ServerValidateEventArgs ) Dim connectionString As String = "server='netsdk'; trusted_connection=true; database='db'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.Connection = dbConnection dbCommand.CommandType = System.Data.CommandType.StoredProcedure dbCommand.CommandText = "sp_email" Dim dbParam_email As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_email.ParameterName = "@email" dbParam_email.Value = trim(email.text) dbParam_email.DbType = System.Data.DbType.String dbCommand.Parameters.Add(dbParam_email) dbConnection.Open Dim cnt as integer cnt = dbCommand.ExecuteScalar If cnt = 0 Then e.IsValid = True Else e.IsValid = False End If End Sub -- . http://sf-f.org, weblog and search engine for fans and writers of speculative fiction. . Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88638
  - 12
    - No Smart Device Choice How come My VB.Net environment does not contain the Smart Device Application Template to open the Smart Device Application Wizard. Any Ideas? Thanks Paul Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88637
  - 13
    - Updating field with single/double quotes I have a memo field in my Access database that is called HtmlText. I have a text box in my ASP.NET application that I fill with HTML. The HTML has both single and double quotes throughout the HTML. I tried to run an UPDATE query to update the db but it fails. I think it's because of the quotes. How can I get the UPDATE command to update fields that contain both single and double quotes? Ideas? Examples? Thanks. Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88627
  - 14
    - ADO Update Problem Greetings all, I am using an Access Database to store question information for a questionare application. I am using VB.net as the front end, and ADO.net to retrieve the information from the database. My data is bring displayed in a DataGrid bound to a dataset. All of my calls to the database are to parameter queries. The problem that I am having is with the update command. When I call the update method for my data adapter, and pass a dataset containing only the changed records, only one record shows the change. I know that parameter queries work because data is being returned and update, just not in the quantities that I want. From what I have read, the update method in ADO.NET should be able to process a batch change, but the only specific information I have been able to find concerns SQL Server and not MS Access. The only information I have been able to find regarding the update method and MS Access were for single records. Does ADO.net send each update request separately, waiting for conformations between requests, or does it send all of the changes at once? I know, if you write the queries properly, SQL server can process the data in a lump sum, but I do not believe Access has that ability. I have been working on this for several days. Any help you can provide would be greatly appreciated Thanks in advance, Edison Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88626
  - 15
    - Books reviewed I've been on a mission this past year to move from VB6 to .Net. I'm fortunate(!?) not to have the big catalog of some long-time VB developers, although I have some CE apps that have to be entirely rewritten in CF. A lot of what I develop has to be written for the PPc, so I knew I would be looking for information in .Net, ADO.Net, CF -- and SQL Server. So in the spirit that others might benefit from my journey, here are my observations. Having been a tech writer many years ago (and a page designer before that), I give these reviews with the caveat that I know how difficult it is to write technical literature and also how difficult it is to pull together all the aspects of a book. Thus I'm not going to give much about any specific errors or bugs, but a general feel for the book and how it helped me. I will also give the caveat that I've never read ANY book that didn't give up some useful bits of information -- no matter how bad that book might be otherwise. Final caveat is that I'm not there yet -- I'm still learning much as I develop and I'll still have many questions here. But I don't see my opinions changing on the books I'm reviewing here. The following list is in no particular author order: Introducing Microsoft.Net 2nd Ed (note: the 3rd Ed is out now), David S. Platt As its title implies, its a great book to get you started in the .Net way of thinking. There are some examples, but that is not really the focus of the book. Touches briefly on all areas of .Net. I wish I had read this book first. VB.Net, Matthew McDonald Strange, I've never seen any reviews of this book, and I got it for $10 at the half-price bookstore, but its chock-full of information and examples. The book is aimed at developers moving from VB to .Net, so it was right up my alley. If you can find it, buy it. Visual Basic.Net, Matt Tagliaferri Another out-of-the-mainstream book (spell that c-h-e-a-p) with some good stuff in it. If you are interested in GDI, this might get you kickstarted. Also gave me some intro to the datareader and datasets. Visual Basic.Net Database Programming, Evangelos Petroutsos, Asli Bilgin I've seen this book slammed in a few reviews, but I feel that's totally undeserved. This is a very good book for those just starting with ADO.Net. Its deep enough, it gives you a lot of great examples, and is fairly well illustrated. I do have some minor heartburn as follows. Some of the examples that required the Command Builder to be used did not show those in the code example. Literally, those examples would not run (I'm thinking this was one of the places that William Ryan straightened me out). Next, a few of the illustrations were actually screen shots of the code that were too small to read (altho in fairness, you have a CD to pull the code up in front of you -- I'm not much on using the CDs unless I do not understand the written word). Finally, the layout of the book is kinda goofy as regards the DataReader (you have to look in a couple of different areas where the material should have been pulled together). I have about a dozen pages tabbed for future reference, so that may give you some idea that despite my misgivings about a few errors, I still find the book very useful. Microsoft ADO.Net, David Sceppa In the lingo of the 20-something crowd, this book is "the bomb". I'd read reviews of how good this book is, and its reputation is well-deserved. I have not finished the book yet, but after several chapters (and some peeks ahead into the "Questions that should be asked more frequently"), I can see already that I'll feel more secure in my knowledge of ADO.Net once I'm finished. I'm thinking that this is probably the only book I've ever paid full-price for. If you were to be stuck with the task of creating a robust application with just any 3 books, this would be 1 of the 3. More about this anon. .Net Compact Framework, Craig Morris, et. al. One of the first books I bought and should've been one of the last. Examples all in C#, and since I had no .Net experience at the time, I didn't spend much time with it. Fairly lightweight tome, but I'm hanging on to it and intend to get back to it Microsoft .Net Compact Framework Kick Start, Erik Rubin, Ronnie Yates This book helped me out tremendously, not only with the CF, but on how to work with the datagrid and datatables. I do not claim to being there completely, but using some pieces of this book in conjunction with answers from the afore-mentioned William Ryan in the forums, I can at least visualize most of the concepts I need to pull things together. Microsoft .Net Compact Framework, Andy Wigley, Stephen Wheelwright I have not finished this book. Examples all in C#, and highly technical (these guys might be wound a little too tight, and might want to check out www.moosehead.com). I'm counting on this to fill in the holes in my technical knowledge once I have the nuts and bolts down. C# Text Manipulation Handbook, Francois Liger, et. al. I found this book also at the half-price book store and oh I love it as a reference! This little gem has helped me tremendously with casts, parsing, math manipulations, numbers to strings, strings to date, you name it. Even if you write only in VB.Net, the examples are easy to read/convert. This book will save you hours and hours of frustration with casting issues. Buy it. Professional SQL Server 2000 Database Design, Louis Davidson How did books about SQL Server land on the .Net list? Frankly, you will miss more than half the journey if you try to learn.Net in a vacuum without some knowledge of SQL Server. This book is so language-agnostic, it is an excellent resource. Written in a very user-friendly conversational tone, I have been enjoying it tremendously -- while learning much along the way. Troubleshooting SQL, Forrest Houlette I found this book totally by accident. It deals exclusively with troubleshooting SQL statements. Heck, while I realized the depth of SQL, I never envisioned that someone could write such a "troubleshooting" book that was language-independent. Using this book in conjunction with "The Practical SQL Handbook", "SQL Queries for Mere Mortals" and "Database Design for Mere Mortals" will make you much more confident in your SQL abilities. SQL Server Black Book, Patrick Dalton, Paul Whitehead I really appreciate the "black book" series of books. They helped me tremendously with VB and got me started with understanding C++. But for some reasons, this particular black book has not been as helpful. Its just as big, has just as many examples in it, but for some reason, I feel disconnected and the descriptive material feels lightweight. This book will remain a reference for me, but I'm somewhat scratching my head about some topics in the book. ADO.Net Step-by-Step, Rebecca Riordin Of all the tech books I've bought over the last 4 years, this is the only one I've ever returned and I did that last night. Because I consider books I buy to be such a repository of reference material, I struggled with even returning it, but something about the book just did not fit my way of thinking (which cannot be considered a knock on the author at all!). I've read some reviews about the book that it has errors and buggy code, but I did not get past the 2nd chapter nor even crack the CD, so I'll not lay that out as an issue either. I think that maybe part of the problem was that I had some knowledge already and clunking around with a "step-by-step" manual was like having someone eager to drive a racecar but their instructor wants to show them how to use the shifter. This book probably has a target audience that I didn't fit in. Visual Basic.Net, Richard Bowman One of my bargain purchases that was a dog. If the author's name is not on the cover of the book, that should be some sort of warning right there. Actually, there is some good material in the book, but its so covered up with screens on every page, you have to spend a lot of time digging for what you need. An excellent example of how NOT to design pages for tech books. Save your money. If you were only allowed 3 books to learn how to write both desktop and Compact Framework database apps, my choices would be: Microsoft ADO.Net, David Sceppa Professional SQL Server 2000 Database Design, Louis Davidson Microsoft .Net Compact Framework Kick Start, Erik Rubin, Ronnie Yates Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88621
  - 16
    - Forcing/Flushing dataset updates to mdb database Hello, When calling the .Update() method on a dataset to make the changes on the undercover database (access .mdb), the changes are not reflected immediatly. If i close the connection, it makes the changes more quickly effective. Do you have an idea how to force the update (writing the cache on the disk) without closing the connection ? Regards, Cybertof. Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88616
  - 17
    - Late and early binding "Patrice" <nobody@nowhere.com> wrote in message news:<ezhVHjLREHA.1388@TK2MSFTNGP09.phx.gbl>... > It's always different. Probably not very well explained but basically : > - Early binding is to know the type of an object at compile time. The > compiler have all the needed element at compile time to build the call into > the excutable code (resolution of calls at compile time) > - With late binding, the type of an object is known only at runtime. It will > need extra instructions to find out where is the method to be called (if it > exists) before calling it (resolution of calls at runtime) > > > > "al" <grawsha2000@yahoo.com> a écrit dans le message de > news:66edfd3c.0405272344.af8f49e@posting.google.com... > > Hi, > > > > Does it make difference to do early or late binding in ADO.net? > > > > > > MTIA, > > Grawsha What about the allocated resources to the early bound object (declared and instantiated at the same time with NEW keyword). This object might not be called untill some time, dose that (untill it is called)waiste needed resources? Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88609
  - 18
    - How to work with MSSQL uniqueidentifier type I have a MSSQL table that has a uniqueidentifier that defaults to (newid()) I'm getting the following Error when I try to insert a new record into the dataset Column 'ID' does not allow null I've hacked at the properties for a while but no luck...any clues TIA Ro Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88601
  - 19
    - avoiding temp table creation Hi All, I'm migrating a legacy, reporting-type application (ODBC) to use ADO.NET in order to facilaite ASP.NET delivery. The problem I have is that some of the reports this old app runs relies heavily on creating temporary tables to hold intermediate results of complex select expressions. The temporary tables are then joined in order to get the final data set, and the temp tables are deleted when done. Needless to say, performance wasn't really stellar. Now that I'm re-wrinting the app, is there any advice people could give me to leverage ADO.NET technology to improve performance? Can I somehow get rid of the temp table creation and bring these intermediate query results into DataAdapters/DataSets AND be able to join them? Another constraint is that I have to support a variety of db's (SQLServer, Oracle, Jet), so I can't rely on the features of any specific provider. Thanks for any advice. Corey. Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88598
  - 20
    - Where can I find a BerkeleyDB XML for .Net || Has anybody found anything about .Net and BerkeleyDB Hi, I am looking for any information regarding BerkeleyDB XML for .NET or if anybody have information regarding an alternativ (free) to BerkeleyDB XML for storing XML and using XQuery. (Yes I have looked at http://www.sleepycat.com) I have found the samples in the download (http://www.merrells.com/john/dbxml/archives/cat_faq.html#000197) ==> I am currently having a look at SWIG.... Any more links or any other information would be much appreciated. Regards, .RikardN Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88597
  - 21
    - Modal / Parent forms VB.net Hi all, Wonder if anyone can shed any light on this scenario. I have an MDI form, Form1, that opens a child window Form2.. - simple enough. However, from Form2, I would like to open a form Form3 (is a 'search and select' type form) and have it modal to form2 AND be an MDI child... i.e. the user cannot get back to Form2 without doing whatever they have to do in Form3, but at the same time can go and do something else in Form1 - e.g. open another form.!!.. I'm sure this has been explained in the past - if anyone can help it would be appreciated. Thanks, Graham Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88596
  - 22
    - [ANN] June 1, "ADO.NET with Visual Basic .NET" chat Wondering about how best to access data from your applications? Then bring your questions and ask them to experts from the Visual Studio and SQL teams. Come learn about the best approaches for working with data in your applications. Date: June 1, 2004 Time: 1:00 - 2:00 P.M. Pacific time 4:00 - 5:00 P.M. Eastern time 20:00 - 21:00 GMT (For a list of local time zones relative to GMT, please see http://msdn.microsoft.com/chats/timezones.asp.) Outlook Reminder: http://msdn.microsoft.com/chats/outlook_reminders/vb_june1.ics Location: http://msdn.microsoft.com/chats (then click the name of the chat to enter the chat room) For more information about Visual Basic .NET, see http://msdn.microsoft.com/vbasic/ To see a list of upcoming chats or set a reminder for this chat, see http://msdn.microsoft.com/chats. For archives of previous chats, see http://msdn.microsoft.com/chats/recent.asp. Thanks! Jason Cooke VB.NET Team ======== This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. (c) 2004 Microsoft Corporation. All rights reserved. Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88590
  - 23
    - Output Parameter Issue I want to use a datareader to execute a stored procedure and records from a table. I want to trap any possible errors in the stored procedure and return the error message via an output parameter. But, the output parameter is empty (nothing!) any time after I execute a query For example, say I have the stored procedur CREATE PROCEDURE sp_Some_Pro @OutMsg varchar(200) = '' OUTPU A SET @OutMsg = 'test RETUR I do the following in my code after the ExecuteReader statement sOutMsg = CType(arParms(0).Value, String and sOutMsg is "test". But when the stored procedure has a select statement in it lik CREATE PROCEDURE sp_Some_Pro @OutMsg varchar(200) = '' OUTPU A SELECT * FROM AnyTabl SET @OutMsg = 'test RETUR I get sOutMsg equal to nothing I also got the same result when I tried to use just straight ADO instead of ADO.NET Has anyone seen this before Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88584
  - 24
    - BindingManagerBase Not Working I have a Windows form with textboxes, labels, comboboxes, and a listbox. I bind the database fields to those objects and would like the user to be able to click through them (forward, back, first, last). The navigation buttons are not working. I commented out the combobox code b/c I read somewhere that could be causing the problem. That didn't work. What am I doing wrong. Thanks. Private Sub btnGetRecords_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetRecords.Click If cboDept.SelectedIndex = 0 Then MessageBox.Show("You must select an area.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error) cboDept.Focus() Else Try sb.Append("SELECT e.eqnum, nvl(purpose, ' ') AS purpose,") sb.Append(" NVL(theory_of_operation,' ') AS theory_of_operation,") sb.Append(" NVL(similar_devices, ' ') AS similar_devices,") sb.Append(" NVL(level_nbr, 1) As level_nbr, l.description AS unit_op,") sb.Append(" nvl(me.description, ' ') AS description, e.tagged") sb.Append(" FROM dbo.th_equipment e, dbo.equipment@MAXLDA_P me, ") sb.Append("dbo.locations@MAXLDA_P l ") sb.Append("WHERE me.location LIKE '%") sb.Append(CType(cboDept.SelectedItem, ItemData).Key) sb.Append("%' AND ") sb.Append("SubStr(me.location,1,5) = l.location AND ") sb.Append(" me.eqnum=e.eqnum") sb.Append(" ORDER BY e.eqnum") da.SelectCommand.CommandText = sb.ToString() da.Fill(ds, "equipment") sb.Remove(0, sb.Length) sb.Append("SELECT eqnum, issue_id FROM dbo.th_equipment_issue") Dim cmdEqIssues As New OleDb.OleDbCommand(sb.ToString, conn) Dim daEqIssues As New OleDb.OleDbDataAdapter(cmdEqIssues) daEqIssues.Fill(ds, "equipment_issues") sb.Remove(0, sb.Length) sb.Append("SELECT issue_id, description FROM dbo.th_issue ") sb.Append("ORDER BY description") Dim cmdIssues As New OleDb.OleDbCommand(sb.ToString(), conn) Dim daIssues As New OleDb.OleDbDataAdapter(cmdIssues) daIssues.Fill(ds, "issues") Dim equip_issue_rel As New DataRelation("eq_issue_rel", ds.Tables(0).Columns("eqnum"), ds.Tables(1).Columns("eqnum")) ds.Relations.Add(equip_issue_rel) Dim issue_rel As New DataRelation("is_rel", ds.Tables(2).Columns("issue_id"), ds.Tables(1).Columns("issue_id")) ds.Relations.Add(issue_rel) lbSelectedIssues.DataSource = ds.Tables("issues") lbSelectedIssues.DisplayMember = ds.Tables("issues").Columns(1).ColumnName lbSelectedIssues.ValueMember = ds.Tables("issues").Columns(0).ColumnName lbSelectedIssues.DataBindings.Add("SelectedValue", ds.Tables("equipment_issues"), "issue_id") txtPurpose.DataBindings.Add("Text", ds.Tables("equipment"), "purpose") lblEQNUM.DataBindings.Add("Text", ds.Tables("equipment"), "eqnum") lblUnitOp.DataBindings.Add("Text", ds.Tables("equipment"), "unit_op") lblDescription.DataBindings.Add("Text", ds.Tables("equipment"), "description") txtTheoryOfOperation.DataBindings.Add("Text", ds.Tables("equipment"), "theory_of_operation") txtSimilarDevices.DataBindings.Add("Text", ds.Tables("equipment"), "similar_devices") ' cboLevel.DataSource = ds.Tables("equipment") ' cboLevel.DisplayMember = "level_nbr" ' cboLevel.ValueMember = "level_nbr" 'cboLevel.DataBindings.Add("SelectedValue", ds.Tables("equipment"), "level_nbr") ' cboTagged.DataSource = ds.Tables("equipment") ' cboTagged.DisplayMember = "tagged" ' cboTagged.ValueMember = "tagged" 'cboTagged.DataBindings.Add("SelectedValue", ds.Tables("equipment"), "tagged") eqBindingManagerBase = Me.BindingContext(ds, "equipment") Catch ex As Exception MessageBox.Show("Encountered error when getting records.", "System Error", MessageBoxButtons.OK, MessageBoxIcon.Error) End Try End If End Sub Private Sub btnLast_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLast.Click eqBindingManagerBase.Position = eqBindingManagerBase.Count - 1 End Sub Private Sub btnFirst_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFirst.Click eqBindingManagerBase.Position = 0 End Sub Private Sub btnBack_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBack.Click eqBindingManagerBase.Position -= 1 End Sub Private Sub btnForward_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnForward.Click eqBindingManagerBase.Position += 1 End Sub Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88576
  - 25
    - COM wrapper around a .NET assembly Hi all, Wonder if anyone can point me in the right direction. Due to time-constraints, it looks lie I may have to abandon using VB.NET development in favour of my more familiar VB6 environment. The issue I have is, that I have to use a .NET assembly (DLL) to access data from a database. I understand it is possible to create a wrapper using COM which would then make it available to VB6. Although this isnt ideal, it might help me, in this partiular case, get to where I need to go a lot quicker. I'm not familiar with COM, but it may still be less of a learning curve than .NET.... Any help would be happily received. Thanks, Graham Tag: OracleClient stored procedure parameter - can it handle 8 bit VarChars? Tag: 88573

I'm trying to execute a pair of Oracle stored procedures that
encrypt/decrypt a character string using Oracle's obfuscation package. Each
stored procedure has an input and an output parameter. One procedure
encrypts a string, the other decrypts a string.

The problem is that when I encrypt a value the procedure executes without
incident, but the return string is losing it's high-order bits. What I get
back is a value that looks encrypted, but when I feed the string to the
decryption procedure I don't get my original value back. When we compare
the string returned by my .Net function to the string returned when
executing the sp under SQL*Plus we see that several characters are 80h
"smaller" in the .Net functional return than they are when the sp is
executed under SQL*Plus.

The database is Oracle 9i, running with an eight bit character set, but I
don't see any property in the .Net OracleClient that allows me to specify
that I expect 8 bit characters back from Oracle.

Can anyone shed any light on this for me?
How can I get .Net to understand that Oracle is returning 8 bit characters?

Thanks much,
Brad

Top