Prepare method at OracleCommand

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
    - Introduction to OLAP Questions... Greetings, I have come to the realisation that a lot of my problems could be easily solved by storing data in "multidimensional" tables in databases. Instead of the traditional 2-D "Table", using a 3-D "Cube" would greatly simplify a lot of the pivoting/cross tabular/slicing and dicing querying my applications are required to perform. Doing some *preliminary* research, it seems the solution is "OLAP". - I have MSDE, (MS OLAP is not included), does anyone know of any FREE databases with some OLAP capabilites? (MSDE, SQLite, Firebird, etc.) - I have searched sourceforge.net and found "Mondrian". I am going to try this opensource software and see what I can do with it. Anyone have any thoughts/experience using Mondrian ?? - Mondrian is Java... are there any .NET efforts currently underway complete with ADO.NET Providers? - any recommended links for newbies to OLAP? Thanks again, Cip Tag: Prepare method at OracleCommand Tag: 86015
  - 2
    - OleDbDataAdapter.Update or OleDbCommand.ExecuteNonQuery ? Hi all, I've been wondering which one of these to use in my application, in terms of efficiency: the Update method of the DataAdapter or the ExecuteNonQuery method of the Command? Using OleDbDataAdapter.Update() is so much easier than creating a command object with all the parameters, as it just involves calling the method and passing it a DataTable object. (Some great design and elegancy from the side of the .NET architects ;) ). I'm trying to keep my application as connected as possible, so that when I update/insert/delete a row, the data source would be immediately updated accordingly. I wonder if the DataAdapter iterates over the changed rows only, or over all the rows in the DataTable... Interesting :) Thank you : Tag: Prepare method at OracleCommand Tag: 86001
  - 3
    - Connectivity problems When you use a fill method of the data adapter, it does a connection to the database, exist 3 mechanisms for avoid this. 1. add the dataset to session va 2. put the dataset in the view state 3. doit a cache whell, my doubt is if I can put the dataset in Xml at the Web server, and only read for this, and all users read from this xml. it brings within a concurrency problem at the time to read. thanks Tag: Prepare method at OracleCommand Tag: 85998
  - 4
    - ASP.NET/MS SQL2K Connectivity Problem Database: MS SQL 2K on a sub-domain, uses Named Pipes and TCP/IP and it's in Mixed Mode. Local PC: Win2K Pro Dev Server: Win2K Server From my local PC I can connect to this database with no problem through EM and QA, but when I try to use the same SQL login to connect through an ASPX page it fails. I get "SQL Server Does Not Exist or Access Denied". However, if I turn on impersonation I can connect to this database through my ASPX page. From my development server impersonation doesn't work. I get "Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection." Anyone have a clue as to why I can connect to the SQL DB through EM and QA with no problem, but through my ASPX page it fails. Also, why would turning impersonation on make things work. One moe thing, the original page was written in classic ASP. This page works fine on my PC , but if I move it to another PC or server it fails. I dunno if that helps. Thanks in advance. Any help would be appreciated. Tag: Prepare method at OracleCommand Tag: 85993
  - 5
    - Store byte array into SQL Server Hi This question has been asked b4 on these newsgroups. I can't find a clear example I have a byte array called signature. I'd like to store this byte array in a SQL server varbinary column and then read it back again. I have the following code snippet Assumptions: sqlCon is a valid SQL connection initialized elsewher public void InsertSalesTransaction(string SalesPersonID, byte[] signature string sCmd = "INSERT INTO SalesTransactions " sCmd += "(SalespersonID,Signature)" sCmd += " VALUES ('" + SalesPersonID + "'," + ??? SqlCommand sqlCmd = new SqlCommand (sCmd, sqlCon) sqlCmd.ExecuteNonQuery() > 0 HOW do you insert the signature byte array Can someone provide me with an example Thanks a lo Tag: Prepare method at OracleCommand Tag: 85990
  - 6
    - Working with a remote server Hi there, I wonder if someone would be kind enough to describe to me the basic procedure for working with ADO.NET, Visual Studio.NET 2003 and an Access 2000 database to and from my ISP's server? I'd really appreciate some help, as I've been trying to work through this for days now, and I can't seem to find a help file that talks me through my specific situation...(I'm using Win 2000, BTW) I've created a simple web project at http://localhost/WebApplication1. I've dragged the appropriate 'Data' icons onto a webform to create an OleDbDataAdapter and an OleDbConnection to a database that's in this directory. I've generated a new dataset, filled it and bound it to the load event for the form. When I preview the aspx form in a browser I see the dataset and all is fine. So far so good. My problem comes with moving the project to my ISP's server. I'm reasonably confident that all is set up properly with .NET1.1 at their end. How do I transfer my project to the server? I've tried simply FTPing the project to the ISP's folder, but references to my local machine's C:/Inetpub/wwwroot folder are not updated. I've also tried using Visual Studio's Project-Copy Project, but with similar results. I think I need to somehow map my C:/Inetpub/wwwroot/WebApplication folder to my server's http://myCompany.com/WebApplication folder, so that the links are updated. However, I can't Map Network Drive because the ISP's server drive isn't part of my physical LAN - the Map Network drive won't accept a http:// prefix?. The ISP folks said I needed a DNS(?) for my database, but I don't know how to use it. It's of the form: \\NAS1\Home\A\AHI647\data\myDatabase.mdb. I presume that my web project is in a folder on the ISP's server called \\NAS1\Home\A\AHI647\www\WebApplication2\ One thing I've tried is to create the project on the remote server itself, connecting via the Frontpage server extensions. While I can connect and see the files online (or at least in the VSWebCache subdirectory on my local machine), the connection the database, while appearing to be on the ISP's directory is actually linking to a temp file on my local drive. My gut tells me this isn't the way to approach things...? As you can see, I'm getting in a bit of a pickle here. Please help!! Many thanks for any response. Graham Tag: Prepare method at OracleCommand Tag: 85981
  - 7
    - formatting datagrid column? Hi, All I populate a datagrid using dataset, read data from SQL Server database "Northwind" database including "Customer", "Order" and "Orderdetails" tables. When the "unit price" display in the datagrid, it does not have $ sign. How do I format "Unit Price " column with $ sign? Thanks Kai Tag: Prepare method at OracleCommand Tag: 85980
  - 8
    - Replictaion doesnot replicate newly added table Replictaion doesnot replicate newly added table from the source server to the target server. Any ideas. This has been happening everyday. Please let me know. Thanks Ramesh --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: Prepare method at OracleCommand Tag: 85979
  - 9
    - Integrate with database on webserver I've got a database on a remote webserver hosted by my ISP that collects data from a website. I only have FTP access to the webserver. What is the best way to get the data from this DB into an existing database inside my internal LAN? I suppose I could FTP a copy of the webserver DB, but I am wondering if there is a better way. Thanks in advance for any help. Dave Tag: Prepare method at OracleCommand Tag: 85978
  - 10
    - DataView.Sort loses ASC/DESC value I use a DataView object as the datasource for an ASP.NET DataGrid. I am seting the DataView.Sort member with a column name and a direction, eg: dvEmp.Sort = "emp_name DESC"; This works fine, but when I post back to the page and look at the dvEmp.Sort value, it only contains "emp_name", and appears to have discarded the " DESC" specifier. Despite this, the dataview is actually sorted correctly in descending order. What gives? John H. Tag: Prepare method at OracleCommand Tag: 85971
  - 11
    - DataSet and updating Ok. I have a table with a primary key being an integer. When using VS.NET 2002, it could not create an update command for my table. Being SQL savvy, I created my own update statement below Me.SqlCommand4.CommandText = "UPDATE dbo.links_page SET (title=@title, imageurl=@imageurl) WHERE (link_page_id = @link_page_id); SELECT title, link_page_id, imageurl FROM dbo.links_page It is bound to the SqlDataAdapter I created. When I add a new record, it is getting the proper auto-increment values, and when I execute .Update(myDataSet), the record is added to the database table But after that record is added, it gives me a constraint error. Apparently, it is having a problem with records that are already in the table. It looks like it is attempting to insert copies of them into the table (which violates my primary key. The exact error is Column 'link_page_id' is constrained to be unique. Value '2' is already present How do I fix this problem Tag: Prepare method at OracleCommand Tag: 85963
  - 12
    - Automatically Convert DB Type to .NET Type Is there an API to convert from a Database type to a .NET System type. I could create a switch statement using the info here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconmappingnetdataproviderdatatypestonetframeworkdatatypes.asp but was really hoping not to have to do this. Thanks, Dave Tag: Prepare method at OracleCommand Tag: 85962
  - 13
    - size problem with ole object data type (blob) and ado.net Hi there, I've a strange problem with ado.net and an Access db. I need to create a little C# app that take the content of "ole object" field and then save it into a file. The problem is that when I do the following Byte[] byteBLOBData = new Byte[0]; byteBLOBData = (Byte[])(ds.Tables["tblRefAlbum"].Rows[0]["photo"]); I get the exact double of the original size! and if I save this array byte to a file I'll get my file with every two byte set to 00. The result is, of course, not an image. I've tryed to manipulate my array of byte to strip every two bytes but the result is an visible image but not the correct image (it's a scrambled image that appears). Please help, I really need to do this exportation of picture in .net with the access db. Thanks a lot for people whom can help me. Tag: Prepare method at OracleCommand Tag: 85957
  - 14
    - Oracle Connectivity Issues Angel Saenz-Badillos[MS] wrote: > the bad pool will clean itself out in 4-8 minutes. Uhm.... I tried but it don't seem be good. With the example code posted, after the 5th session-killing, i get a loop with "Connecting... Exception: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.". I waited 20 minutes, but nothing changed..... .net framework 1.1, microsoft provider for oracle, oracle 9.2. Bye Diego Tag: Prepare method at OracleCommand Tag: 85956
  - 15
    - Can this be done?? Hi Sirs Is it possible to create a transaction which inserts data into a table in such a way that all the inserted rows are NOT visible to other processes accessing the same table until the transaction commits the data?? Thanks in advance Regards Morten Tag: Prepare method at OracleCommand Tag: 85953
  - 16
    - using DataSet to transport data as XML Hi, I have two exacts databases, but phisically distant and without direct connection. I want data be transported from one place to another. The process that i'm doing to achieve that is loading a DataSet from source database, writting schema to an XSD file, writting data to an XML file sending them by any mean (email as first attempt) and in the other point, receiving the XMLs, loading DataSet and update to a destination database. I have done almost everything , but i have troubles with the last part of the process. How i can say that the changes in the DataSet must be updated in the destination database? Will i have troubles with the relations of the tables ? Regards, José. Tag: Prepare method at OracleCommand Tag: 85949
  - 17
    - check database exists Hi How do I check whether a database exists before attaching a database Thankx in Advance Priya Tag: Prepare method at OracleCommand Tag: 85940
  - 18
    - Function, datagrid and findcontrol <ItemTemplate> <asp:HyperLink id=HyperLink2 runat="server" CssClass="LABELGAUCHE" NavigateUrl='<%# funcSite(DataBinder.Eval(Container, "DataItem.WebSite")) %>' Target="_blank">Visit the Website</asp:HyperLink> </ItemTemplate> i want in the function funcSite put hyperlink2.visible = false if there is not a website But i can't find the control. My datagrid name is dgWebSite Thx -- Ceci est une signature automatique de MesNews. Site : http://mesnews.no-ip.com Tag: Prepare method at OracleCommand Tag: 85933
  - 19
    - OleDb vs Odbc for access database? Hello, I am creating a program that usese MS access database, is it better to use OleDb with Jet provider or is it better to use Odbc? what is the difference betwen them? Alex Tag: Prepare method at OracleCommand Tag: 85928
  - 20
    - SQLException timeout I am using the .NET SQLData Provider for accessing data from an SQL Server 2000 SP3 Server I have an SQLDataAdapter that it is being provided an appropriate constructed SQLCommand object. The Command's object Timeout Property has been set to 0 i.e. "do not timeout". However, when I am using the SQLDataAdpter Fill method with a DataSet as parameter A and a TableName (string) as parameter B in some cases I get an SQLException with the error code -2 (i.e. timeout). This is not a reproducible behaviour. It usually happens in our customers sites. Just to help you, it cannot be a problem of locks and SQL Server's overload because we run the process that fills in the dataset when nobody else is connected to the SQL server thus it cannot be neither a concurrency problem (locks) nor sql server's overload because there only one user in the server logged in Could you please help me on this. In order to overcome the problem I put a loop of 30 retries to fill the dataset prior to letting the exception be thrown to the caller stack and even with this patch I still have cases that the fill fails to execute with a time-out error What can I do to solve the problem? Is there another property that I can set in the SQL ADO.NET Objects (I had also set the connection timeout to 0) HINTS 1. When the SQLException with the -2 error is thrown the Fill command did not wait a little bit (not even 60 secs). It looks like the error has been immediately sent from the server. 2. The query that I am using in the SQLCommand object is a liitle bit complex (it has aggregate functions, scalar columns and complex WHERE condition that uses xxx IN (SELECT YYY ...). Might be the case that the time out comes from the SQL Preprocessor 3. I put an index in a sensitive column and the exception vanished !! 4. However, this cannot be the solution. I want my queries to execute and my code wait until the execution completes without having to worry about query optimization which is something that will come in next phase of tunning Thank you in advance Stavros K Menegos Tag: Prepare method at OracleCommand Tag: 85916
  - 21
    - Dataset to Access DB How can I insert all records from a DataSet to an Access Table. Thanks Tag: Prepare method at OracleCommand Tag: 85897
  - 22
    - Advice on connections Is it possible to have an ado.net connection object that would connect to both SQL Server 2000 and Oracle. Thanks, Will. Tag: Prepare method at OracleCommand Tag: 85896
  - 23
    - Nulls from msaccess to Vb.Net I've written the following and found that the ISNULL function is not working properly. I want to be able to query the Firstname record from an access database and have it return a string of my preference when the Firstname field is null. I found that this is isn't happening. Under transact-sql ISNULL is to have a replacement parameter and find that I receive a wrong parameters error message with my code. I've tried using the nz command for msAccess and I receive a function not found error. Is there a way to return a string for a null value from vb.net querying an access database?. My code is below Dim x as strin Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.MDB" x = "SELECT Name, ISNULL(FirstName,'John') From MyTable Dim cmd As New OleDb.OleDbCommand(x, conn Dim rdr As OleDb.OleDbDataReade Tr conn.Open( rdr = cmd.ExecuteReade repeaterOrderDetails.DataSource = rd repeaterOrderDetails.DataBind( rdr.Close( conn.Close( Catch ex As Exceptio Response.Write(ex.Message Response.End( Finall If conn.State = ConnectionState.Open The conn.Close( End I End Tr Tag: Prepare method at OracleCommand Tag: 85895
  - 24
    - can't find a downed server even when it comes back up. Pooling problem? I have a program that looks for remote SQL Servers and pulls information off of them every x minutes. It's possible that the DSL connection to one of the servers can be down for an extended period of time. If that happens, I have good exception handling and logging so that it doesn't try to pull data off of that server. I'm experiencing a problem when a server is down for some period of time, but then comes back up. The problem is that the application immediately fails after trying to open the connection, like it doesn't even try to open it. If I stop and restart my program (it's a .NET program running as a Windows service), then it detects that the server is back up and starts working. One other note - if I change a config file so that the server name is the IP address of the server, OR from IP address back to server name, then the program detects that the server is back up and starts pulling data again. (meaning - I change connection string to something else and the program detects the server is back up). Could this be some sort of connection pooling issue? I need my program to detect when the server comes back up and start pulling data without manual intervention. matt tag Tag: Prepare method at OracleCommand Tag: 85883
  - 25
    - testing for "" blank nulls vs 2002/xp pro/win forms/MS access 2002 I want to query my database where fieldA = "" (Blank) Select MYDB where fieldA = "" or Blank or Null What is the correct syntax for checking for "" blanks nulls thanks Tag: Prepare method at OracleCommand Tag: 85874
- Next
  - 1
    - Problems instantiating a DataSet from XML schema In a standard Windows project, I created a couple of xml schema and used the generate data set tool under the schema menu. I could then view the schema as data sets and they look right - so far so good. However, when I try to instantiate them by dragging a data set onto a form, as described in the help files, I have problems. The IDE correctly lists the xml schema under typed datasets, but when I hit OK I get told that VS can't instantiate the data sets. Underneath it says to build the solution, fix any errors and try again. I build - get no errors or warnings - but when I go through the process again I get the same error message. What am I missing? Tag: Prepare method at OracleCommand Tag: 85862
  - 2
    - DataSet.Merge - Expressions not recalculated - Known Bug? When merging a DataSet, if the the DataSet being merged into contains an expression column and the DataSet merging does not, then the expression column is not evaluated for new rows (they are DBNull). Of course, I strip the expression column before updating because of the other bug that causes DataAdapter Update to blow up if an Expression column is present, so this causes the aforementioned bug to occur. Is this a known bug? The workaround is to reset the column.Expression property after a merge. Cole Tag: Prepare method at OracleCommand Tag: 85859
  - 3
    - Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction Hi there, I have this code to select and insert data into the database. It all works fine if i don't use a transaction but if i do i get the message: Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. What a i doing wrong here, please help! Dim insertCmd As New SqlCommand Dim myTransaction As SqlTransaction Dim selectAll As New SqlDataAdapter insertCmd.Connection = New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString")) insertCmd.Connection.Open() myTransaction = insertCmd.Connection.BeginTransaction("L1") insertCmd.Transaction = myTransaction Dim t As Integer sqlstring = "Select * from TAanvraagTekening where aanvraagid = " & ds.Tables(0).Rows(i).Item("AanvraagId") & "" selectAll = New SqlDataAdapter(sqlstring, insertCmd.Connection) selectAll.Fill(dsAll) <-----HERE THE CODE FAILS! For t = 0 To (dsAll.Tables(0).Rows.Count - 1) insertCmd.CommandText = "INSERT INTO TAanvraagTekening(AanvraagId,TekeningId,TekeningUitgave,TekeningDatum" & _ ") Values(" & tmpAanvraagId & ", " & dsAll.Tables(0).Rows(t).Item("TekeningId") & ", '" & dsAll.Tables(0).Rows(t).Item("TekeningUitgave") & "'" & _ ",'" & IsoDate(dsAll.Tables(0).Rows(t).Item("TekeningDatum")) & "')" insertCmd.ExecuteNonQuery() Next ....... more code...... myTransaction.Commit() Thnx in advance! Victor Tag: Prepare method at OracleCommand Tag: 85856
  - 4
    - Attention William Ryan eMVP Bill, You were helping on a thread in this group: "Typed Dataset Problem" and posted a reply to your post and I was hoping that you could reply to it. Thanks Tag: Prepare method at OracleCommand Tag: 85855
  - 5
    - Resizing rows height in a WindowsForms DataGrid automatically Hi Does the WinForm DataGrid has a property that enables it t increase the height of certain rows automatically, in case whe in those rows, some cells contain text that cannot fit inside of them so instead of just trimming the text, the whole row's heigh increases? Something similar in concept to what an HTM table does. If not, is it possible For example CustomerName|CustomerPhone ------------------------------------- ShortName | 000-0000000 ------------------------------------- This is a very | 001-0000000 long name | ------------------------------------- ShortName2 | 003-2222000 ------------------------------------- Thank you so much for your time :) Tag: Prepare method at OracleCommand Tag: 85851
  - 6
    - ANN: SocketPro -- A framework implemented with batching/queue, asynchrony and parallel computaion Hi, All: I am happy to annouce that we have released our latest SocketPro version 4 (in beta), an advanced framework written from batching/queue, asynchrony and parallel computation. Key Benefits of SocketPro: Super performance It is a guarantee that SocketPro based client-server applications beat all of .Net remoting, DCOM, COM/Surrogation, MTS/COM+, Corba, Java RMI and Web service in speed UNDER ANY CASES! No joke! Lots of unique features None of common frameworks can provide more features than SocketPro. Many of SocketPro features are unique, which can not be implemented in other frameworks and are found ONLY in SocketPro. Simple to use SocketPro completes all of common distributed application tasks. The latest version of SocketPro can match with anyone of common distributed application frameworks in simplicity. Notification service SocketPro implements a built-in notification service, which enables you to notify a message to one or more clients either from a remote server or from a client. Different programming experience and lots of fun SocketPro is written from batching, asynchrony and parallel computations. You can get a totally different programming experience with lots of fun, and will have no or much less multithreading and event problems to bother you! Accessing your data securely anywhere over all of types of networks, Dial-up, cable, DSL, Wireless modems, and LAN SocketPro is created for internet development with all of types of networks. You can share your databases, files, and messages over all of types of networks. You can even use a phone line modem to access these data with decent speed. Secure Embedded with openssl to secure all of data transaction between clients and servers, beginning with the version 3.0.0.1. Support all of COM-enabled development languages for client applications SocketPro comes with a set of COM objects exposing IDispatch-derived interfaces. It can be used with all of COM-enabled development languages. Support lots of development languages for server applications The latest version of SocketPro supports not only C/C++ with all of compilers available but also dotNet languages. SocketPro supports all of development languages capable of handling window callbacks and threads. Great interoperability Unlike common distributed frameworks, SocketPro has great interoperability among many different development languages. For example, you can easily let old VB code communicate the latest dotNet managed code. Support multiple services with one port As shown in samples, SocketPro server provides different services with one TCP/IP port. You can easily add your services into a SocketPro server. All of services can be switched at run time. SocketPro can be free to you Within a limited time period, you can get a copy of SocketPro for free! -- Yuancai (Charlie) Ye Fast and securely accessing all of remote data sources anywhere with SocketPro using batch/queue, asynchrony and parallel computation See 30 well-tested and real OLEDB examples RDB, a tool for fast and securely accessing remote databases with dial-up, cable, DSL and wireless modems anywhere www.udaparts.com Tag: Prepare method at OracleCommand Tag: 85845
  - 7
    - Distributed transaction completed errors I am encountering SQLClient errors in a COM+ object (spawned from Biztalk) that extracts data from an xml document and updates a SQL table (version 2000 8.00.760 SP3) Under a fairly low load of documents, there seems to be no problems, but with several messages to process, these errors start to stack up. I also see "SqlConnection does not support parallel transactions. I am only using one SQL connection, one stored procedure - and one SQLTransaction that may be called a couple of times throughout the process Any advice will be greatly appreciated Troy Tag: Prepare method at OracleCommand Tag: 85840
  - 8
    - Double or float - make your mind up! I use floats in SQL server as they are its standard datatype for dealing with non-integral numbers I thus thought it would be logical to use the SqlDbType.Float for accessing parameters of this type in ADO.NET, from C# However, when I declare an SqlParameter with SqlDbType.Float as its datatype, its Value property after the command has executed can't be cast to a float, only a double. I'm OK with this if this is what the DB engine wants to do - but is it really correct?????? I know I could cast to a float but would there be much point if I'm only doing comparisons, not much maths. I'm mainly after fast performance Thanks! Tag: Prepare method at OracleCommand Tag: 85818
  - 9
    - Fastest db methods? Could someone tell me which is faster, or no difference, between Which is the fastest out of the following two methods?? Reading a recordset using SqlDataAdapter.Fill(a_dataset) / reading a recordset using SqlDataReader ?? Which is the fastest out of the following two methods?? Reading a recordset using SqlDataAdapter.Fill(a_dataset) / reading a recordset using SqlDataReader *after* doing an ExecuteNonQuery on the same command (after changing an in parameter's value to enable the SQL to be optimized) in to glean output parameters (which need to be used during the reading of the records Which of the following three is faster, or none at all?? Accessing fields using dr.GetInt32(0) / dr["fieldname"] / or dr[0] ?? Tag: Prepare method at OracleCommand Tag: 85817
  - 10
    - C# oracle connectivity Consider a situation that i need to connect to a remote oracle database using a ASP.NET interface. I dont have the access to change the TNSname.ora file. In that case, how can i connect to oracle using the following information: 1. Network Address 2. Port 3. SID 4. User Id 5 Password Java does allow this. But the .NET connection string using both ORAClient or Microsoft's Oracle native driver, doesnt allow me to do that. Any body who can help me on this.? --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: Prepare method at OracleCommand Tag: 85815
  - 11
    - Still unable to connect to SQL database on non-development machine Hi I have still not been able to sort out the issue of a non-development machine not being able to open a connection to an SQL database. Aaron, if you read this thanks for any help you can/could give me The details are as below My connection code is (using VB.net): myConnection = New SqlConnection("data source=SPEEDY;initial catalog=OpsAdminTest;integrated security=True" MessageBox.Show("connection string: " + myConnection.ConnectionString MessageBox.Show("myConnection.Database: " + myConnection.Database MessageBox.Show("myConnection.DataSource:" + myConnection.DataSource MessageBox.Show("myConnection.Workstationid:" + myConnection.WorkstationId Tr myConnection.Open( Catch ex As Exceptio MessageBox.Show("Error opening connection" End Tr MessageBox.Show("finished initialization" This is done immediately after the InitializeComponent() call in the application When I compile/release the code for installation and then install on the same machine that I developed it on, it works fine. But when I install on the non-development machine, it fails to open the connection >Are you using DSN, if so, is there an appropriate DSN connection on the non development machine The non-development machine has the SystemDSN connection to the OpsAdminTest database as it is an active database that we use for test developement of other services. My company does interactive voice services for various tv/radio/magazines and we use SQL to maintain the services >Are you using Windows or SQL authentication We are using windows authentication for the SystemDSN connection to the database >Have you used SQL Profiler to see if you are even touching the SQL server Sorry this question eludes my limited knowledge. How would I use SQL Profiler in my code to see if I am connection to the server Again, thanks for any help Tag: Prepare method at OracleCommand Tag: 85809
  - 12
    - Real Simple Insert - doesn't work Hey Trying to do a real simple online Newsletter form - an Insert into a SQL Server DB, but when the submit button is pressed, the page refreshes, but nothing is added to the DB. Code Dim ConDB As SqlConnectio Dim strINSERT As Strin Dim cmdINSERT As SqlComman ConDB = New SqlConnection("Persist Security Info=False;User ID=xxx;password=xxx;Initial Catalog=xxx;Data Source=xxx" strINSERT = "INSERT Newsletter " & "(FName, SName, Email) " & "Values ('" & Fname.Text & "','" & Sname.Text & "','" & Email.Text & "') cmdINSERT = New SqlCommand(strINSERT, ConDB ConDB.Open( cmdINSERT.ExecuteNonQuery( ConDB.Close( appreciate your assistance guys. Tag: Prepare method at OracleCommand Tag: 85803
  - 13
    - How to determine that rows on server changed and dataset needs to be updated ? Hi, I'm starting using ADO.NET and trying to understand if there is any analog of Server side cursor in ADO.NET. Using ADO i could just open recordset with serverside cursor and adOpenDynamic options. Then if another user has changed values on the server while recordet is opened, i got updated records automatically. In ADO.NET i couldn't find the way to implement this future. Is there any event or something else that informs program that records on the server had been changed ? Best Regards, Giga. Tag: Prepare method at OracleCommand Tag: 85801
  - 14
    - solve my problem (Type your message here) Hi all, Now I am doing my project using VC++/MFC and sql server as a database.I hava to store the Bitmaps in the database.If anybody knows about how to store the bitmap in the sql server as a BLOB object & retrive it.please help me it is urgent. -------------------------------- From: Ramesh Kumar ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>Dv3OrgDiFEaF9UAPoH2Etg==</Id> Tag: Prepare method at OracleCommand Tag: 85800
  - 15
    - Updating datagrid display using custom collection I'm having problems refreshing a DataGrid that a custom business object collection (PeopleCollection) is binded to. The PeopleCollection class maintains a collection of PersonInfo items. The PeopleCollection class inherits from CollectionBase and implements IBindingList. The PersonInfo class implements IEditableObject and IDataErrorInfo. What I have so far, is when a user double clicks a row on the DataGrid a 'Person Details' form is displayed showing the details of the person selected. The details of the person may be changed via textboxes on the form. This works well. Problem is if the user changes, say, the name of the person on the form and clicks the OK button the Person Details form is closed, but the new name is not displayed in the DataGrid (it still displays the old data). I know the new name is propagated to the PersonInfo object cause if I click on the row that was changed by the form the DataGrid decides to refresh itself, therefore displaying the new name. So, how do I update the DataGrid when the PersonInfo object is updated? I know the PersonInfo object should be notifying the PeopleCollection object, which should then raise the ListChanged event. The DataGrid updates nice and well on addition and removal of people from the the collection. Problem is only with modification of person objects. I've been working with a small sample program that you can download from microsoft's website. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadvnet/html/vbnet02252003.asp Hope you can understand my problem and help out. If there's any articles on the web that may point me in the right direction, let me know. Thanks a bundle to all replies. Much appreciated. Tag: Prepare method at OracleCommand Tag: 85792
  - 16
    - finding child tables Oracle. 1)how to find all the the existing chaild tables of a master table? ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>uQ+Pk5MDTU2Wcrlfzf3Buw==</Id> Tag: Prepare method at OracleCommand Tag: 85791
  - 17
    - very rookie VBScript ADO RDS Binding question Looking at what is posted here, I'm afraid this will be a real dumb thing to ask (I'm just getting into web programming after having worked in mainframe programming for a long time). I'm learning about ADO RDS Binding. My (simple) web page finally has been made to successfully retrieve a little data from my sample database (which has a "songs" table and a "users" table - joinable on a field called "username"). I'm now trying to persist the extracted recordset (eventually in XML and in a "stream") and to make a user fiendish (oops - I meant "friendly") "table" with sortable column headers and all that... To help me learn about the topic, I found a very interesting MSDN article that had a great looking VBScript at the bottom. The idea of the script is to present form input fields via the page and you can override defaulted connection info and have the script draw you a simple "table" from one of your database tables... Well - I can't get the VBScript to work... I get the form inputs to show up just fine but when I click the "run" button, nothing seems to really happen (and I sure don't get my MS Access info displayed in a "table" on the screen like is supposed to happen). So, my question is "can someone coach me as to how to get the script really to work?" I can share where to find version of the script if that would help. The MDSN article is at: (except for very minor tailoring like putting my column names in where they had different columns, my script is exactly like the one in the article)http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjaddataconx.asp Some of my connection info is as follows: ' CONNECTION STRING DataBasePath = Server.MapPath("..\db\fpdb\srtestdb.mdb") DatBaseDriver = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" DataBaseSource = DatBaseDriver & DataBasePath ' CONNECTION Set DBConn = Server.CreateObject("ADODB.Connection") DBConn.Open(DataBaseSource) ' Create an ADO recordset object Set rsSRDB = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT [songs].[songtitle], [songs].[songgenre], [songs].[songusername], [users].[username], [users].[emailaddr] FROM users LEFT JOIN songs ON [users].[username] =[songs].[songusername];" ' Open the recordset with the SQL query rsSRDB.Open strSQL, DBConn ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Prepare method at OracleCommand Tag: 85789
  - 18
    - Strongly typed data sets Hello there, How can I automatically create strongly typed data set from existing SQL Server 2000 tables. I know that I can drag and drop a table to generate one, but I'd like to generate strongly typed data set for all specified tables with relations between them ? Is it possible with Microsoft Visual Studio Enterprise Architect 2003 or another tool ? Thank You Best regards Rafal Grzybowski Tag: Prepare method at OracleCommand Tag: 85785
  - 19
    - Date Querry Hello, I am working with an Access Database and am trying to return a Querry that is between two specified dates, I have tried the following and none of them work: 1) ADataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Contributions WHERE 'Date' > " & dtpFrom.Text & " and 'Date' < dtpTo.Text & ";", AConnectionString) 2) ADataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Contributions WHERE [Date] BETWEEN DATEPART ('" & dtpFrom.Text & "') AND DATEPART ('" & dtpTo.Text & "')" , AConnectionString) 3) ADataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Contributions WHERE 'Date' > 1/1/2004 and 'Date' < 6/1/2004;", AConnectionString) No records are returned. Any suggestions will be greatly appreciated. Thanks, Chuck Tag: Prepare method at OracleCommand Tag: 85783
  - 20
    - Advice on filtering and using a Data View Using vb.net, I created a data view and would like to filter the view and determine if a record or group of records exists. My question..........is there a property I can check to determine if the view contains records meeting my criteria after filtering is performed? Also if the view does in fact contain records, is there a way to loop through view to get certain field values from it? Wil. Tag: Prepare method at OracleCommand Tag: 85773
  - 21
    - Error create DataAdapter with Config wizard. hi I was trying to use following query to create Data Adapter SELECT DISTINCT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Customers.CompanyName, Customers.Address, Customers.City FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerI Error always happen with -------------------------- Primary Key Columns Missin -------------------------- The wizard can not automatically create queries for updating the database because your query does not include some primary key columns. Do you wish to add the primary key columns to your query Please suggest how can I fix it rgds Fish. Tag: Prepare method at OracleCommand Tag: 85763
  - 22
    - Get "table doesn't have a primary key exception" I get a "table doesn't have a primary key" exception during a .Rows.Find(string); However the table has a primary key. I moved it from one column to an other. But the table designer shows it. What could be wrong? Tag: Prepare method at OracleCommand Tag: 85753
  - 23
    - Web Services and SQL Server Stored Procedures I've written a very basic web service that is used by my PocketPC to add two numbers together. It works fine. So next I'm writing a WebService which accesses my SQL Server and returns rows appertaining to a specific OrderId. I have written a stored procedure called spGetConfirmedOrder to which I pass the OrderId and it works okay until I need to reference it in my code then it doesn't recognise it. Is there something that I'm missing out here do I need to get involde with SOAP and WDSL files or can I just use ADO.NET? Regards Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.667 / Virus Database: 429 - Release Date: 23/04/2004 Tag: Prepare method at OracleCommand Tag: 85749
  - 24
    - DataGrid master-detail indicator Microsoft make a feaure in Datagrid that support master-detail in the one grid. but for end user i prefer to present MD by tow grids. on the master grids have automatic indicator (+), this is redundant, and end user may confuse with it. can i remove the (+) indicator from master datagrid? how to do that? Tag: Prepare method at OracleCommand Tag: 85741
  - 25
    - SqlConnection Question Hi , I have a Dll with few functions and when i m opening a connection by using one of the Dll functions and i m relating the connection to some SqlDataReader then i can't use the connection for other purpose until i will close the DataReader . why is that ? why i can use the connection for other things but for SqlDataReader more then once ? how can i work with the same connection ? should i work with one connection or should i open a new one ? please notice that i need to use the connection while i m in the middle of some loop in the datareader (While DataReader.Read() ...) Best Regards , Tiraman :-) Tag: Prepare method at OracleCommand Tag: 85732

I have been trying to retrieve data from Oracle Data base server 8.0.6.0.0 using Oracle Data Provider.
I can't use stored procedure...so I used prepare method of OracleCommand class to make execution plan at server.
but oracle database returned error code "ora-00936".
what's wrong at this code..?
string strConOra = @"Data Source=datasource;User ID= userid; Password=pwd";
OracleConnection objCon = new OracleConnection(strConOra);
objCon.Open();
string strcmd = "select * from test where test_ID = @str ";
OracleCommand objCom = new OracleCommand(strcmd, objCon);
objCom.CommandText = strcmd;
objCom.Parameters.Add("@str", "ddd");
objCom.Prepare();
OracleDataReader rd = objCom.ExecuteReader();

Thanks in advance .

Top

Re: Prepare method at OracleCommand by William

William
Wed Apr 28 06:48:41 CDT 2004

Set the comamndtype to CommandType.StoredProcedure
"ms.Joo" <msjoo@auinfo.co.kr> wrote in message
news:83EFA361-B667-4D9F-89D2-9C457179A99C@microsoft.com...
>
> I have been trying to retrieve data from Oracle Data base server
8.0.6.0.0 using Oracle Data Provider.
> I can't use stored procedure...so I used prepare method of OracleCommand
class to make execution plan at server.
> but oracle database returned error code "ora-00936".
> what's wrong at this code..?
> string strConOra = @"Data Source=datasource;User ID= userid;
Password=pwd";
> OracleConnection objCon = new OracleConnection(strConOra);
> objCon.Open();
> string strcmd = "select * from test where test_ID = @str
";
> OracleCommand objCom = new OracleCommand(strcmd, objCon);
> objCom.CommandText = strcmd;
> objCom.Parameters.Add("@str", "ddd");
> objCom.Prepare();
> OracleDataReader rd = objCom.ExecuteReader();
>
> Thanks in advance .
>

Top