| OleDbParameters (4 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| I'm working my way through a book on .NET, specifically ADO.Net. There is an example of updating a table with the data displayed in a datagrid, with an "Edit" link button. This allows certain columns on any row to be updated. The example works when connecting to SQL Server using the SqlClient namespace. I, however, (for reasons I won't go into) must make it work with OleDb instead. The problem is ... |
|
| Could not find installable ISAM. (3 replies, VIP) |
| ASPFriends.com 'ngfx-oledb' list |
| Hi all, A newbie to ASP.Net. I am trying to retrieve database rows with a dataset and I am getting the error above. Thanks inAdvance Regards Srini Source Error: Line 17: Line 18: dim ds as Dataset new Dataset() Line 19: myCommand.Fill(ds, "tblUsers") Line 20: end sub Line 21: /script The code is given below %@ Page Language "VB" debug "true"% %@ Import NameSpace "System.Data" % %@ Import Namespace... |
|
| Updatable Query Problem (7 replies, VIP) |
| ASPFriends.com 'ngfx-oledb' list |
| I can't get this query to work on a live machine but it works fine on my system. I want to INSERT a database record. Real easy stuff, but for some reason I can't get it to work. I'm pulling my hair our here, maybe I should of been a carpenter. Here's my relevenet code: 'Update conMain.Open() strInsert "Insert Into sites ( sitename, siteurl, seotype, lastsubmitted, contactemail ) Values ( ?, ?, ?, ... |
|
| MSAccess cant cope with the workload of a couple of page requests ? (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Alex Lowe webmaster@asp grandrapids.net Moved from [aspngfreeforall] to [aspngdata] by Rachel Reese rachelemilyreese@hotmail.com Dear friends, The plot is the following: Some clients and hosting providers down here prefer and offer ACCESS as the database solution for our client's sites. So we were forced in some cases to use access as data storage backend ... |
|
| Problem reading long MS Access Memo fields (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngfreeforall] to [ngfx oledb] by Marcie Jones marciejones@yahoo.com When the Memo field is over 255 characters, OleDbDataAdapter doesn't Fill well my DataTable (only the first 255 characters). I tried with OleDbDataReader, GetChars and filling a StringBuilder, and it seems it only has 255 characters; it doesn't reach the rest. Please help! Saludos from Spain! Ignacio Calvo |
|
| ASP / MS Access Question (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| I'm trying to search a linked table in MS Access the actual table resides on another computer on our network. When I try to get to the data, I get the error Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '\\ea itst g150 10\dbtest\test.mdb'. It is already opened exclusively by another user,... |
|
| Problem inserting large text object using OleDbCommand (5 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Alex Lowe webmaster@asp grandrapids.net I folks, I seem to have uncovered a strange problem inserting a large text object into an ntext column in SQL2000. It would seem that the OleDbcommand object is limited to 900 characters of data, would someone have a workaround? I am using the varwchar database type and giving it an explicit limit of more than one mi... |
|
| Why no error closing datareader or connection objects? (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Marcie Jones marciejones@yahoo.com In the following code, I expected to get an error on Lines 13 or 15 because I specified CommandBehavior.CloseConnection on Line 7. Leave it to me to worry about NOT getting an error! Shouldn't I get a runtime error trying to close a reader or connection that's already closed? L1 Dim objConnection As New OleDbConnection() ... |
|
| CR/LF in MS Access Memo fields (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hello Everyone, If a user enters two carriage return/line feeds in a memo field in MS Access (for example, to start a new paragraph in their text), how can I convert that to br br or /p p when I read it back and display it on the screen? Tim :) Timothy M. Brewi |
|
| Obtaining value of autonumber key field (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Marcie Jones marciejones@yahoo.com I have an Access database whose key field is an AutoNumber. When I insert a new record, Access automatically assigns a unique value to the key field. How can I obtain that value when I inser a record? This could be done in ASP v3, but I can't find documentation on how to do this in ASP.NET. Thanks for any help. Tim :) Tim... |
|
| Accessing Sql Server 6.5 (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| I am working on a project where I need to access Sql Server 6.5 through ADO.net and I am using the oledb provider. I have moving this project from asp to asp.net, but I am having some major speed issues with asp.net. When running this with asp the speed was fine, no problems there, now it is extremely slow. It is bad enough that it times out if more than 6 items are returned. I set up a trace on t... |
|
| EOF For OleDbDataAdapter or DataSet (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Tony Stark IronMan@aspelite.com My first "real" .Net page displays all of the tables in a database in a dropdownlist. Upon selection of a table name, a DataGrid (with paging) displays the data. Some of the tables, however, contain no rows. When a table with no rows is selected it usually displays the column names and nothing else. Occasionaly (inconsistent... |
|
| OLEDB Connection to Informix (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngfreeforall] to [ngfx oledb] by Tony Stark IronMan@aspelite.com If this is not the proper list to pose this question please forgive me. I wasn't sure where to post it. Has anyone connected to Informix in .Net? I use the following connection string in classic ASP without any problem: "Provider Ifxoledbc.2;password password ;User ID user ;Data Source opcrts@alpha;Persist Security Inf... |
|
| Could not delete from specified tables.. Access 2000 Jet 4.0 (3 replies, VIP) |
| ASPFriends.com 'ngfx-oledb' list |
| I am having a problem deleting a record from a table with the Jet 4.0 connection. The SQL string is: Delete From tblUsers where UserID 'jdoe' When I try to do a ExecuteNonQuery, the following error occurs: Could not delete from specified tables... Any Ideas? I read a Microsoft Article that talked about setting a Unique Record property, but I don't think it applicable to my problem / issue. Thanks!... |
|
| How do I use oledbdatareader in business object (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| I can't seem to use OleDbDataReader as parameter for a class contained in a business object namespace MyUtility { public class DbProp { public void AddSpace(Page myPage, OleDbDataReader myReader, int number of spaces, params string[] FieldNames) { ... } } } When I compile I get the following error : error cs0246: the type or namespace name 'OleDbDataReader' could not be found (are you missing a us... |
|
| Error with connection to Access.mdb file (4 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| I am working through some sample files from ADO.Net Step By Step When I attempt to run the ASP.Net project, it gives me the following error message when it attempts to load the data adapters: The Microsoft Jet database engine cannot open the file 'C:\adonetsbs\SampleDBs\nwind.mdb'. It is already opened exclusively by another user, or you need permission to view its data. The connection string bein... |
|
| Access Locking (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hello List, I am having trouble referencing an access database. The program runs fine on my development server but when posted to the ISPs server I get an error message of "Can't Lock File". I am only asking for Read access so am puzzled by this. I built the connection string in Visual Studio's connection designer . here is what it came up with: sConnection "Provider Microsoft.Jet.OLEDB.4.0;Passwo... |
|
| Weird Database error (2 replies, VIP) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Bob Levittan blevittan@hotmail.com Hi, I have just started getting the following bizarre error message when my asp.net page queries the Access DB: Exception Details: System.InvalidCastException: The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was ... |
|
| Connection objects (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngfreeforall] to [ngfx oledb] by Marcie Jones marciejones@yahoo.com I recall there was a discussion about it on some of the aspfriends lists but can't seem to find it. In order to release a {OleDb|Sql}Connection object back to the connection pool, the developer needs to: 1. call Close() on the object 2. set it to null (Nothing) 3. call Dispose() on the object Which of the three appl... |
|
| Can ExecuteScalar be used to return the autonumber of a new record when doing a SQL INSERT? (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by devin devinr@drone interactive.com I need to link several tables together by a unique id when doing a insert from a form. Actaully perhaps I would be better to generate a unique number at runtime and insert that to the db (access 2000) as an identifyer rather than rely on an autonumber feild? Thoughts? Paul |
|
| Using dates in Access query (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hello, I know this is probably off topic, but i have a problem with regard to date columns in Access 2000. I have a table in Access 2000 let us say table A. In this i have a date field called 'Date1'. Now, my regional setting is English (US), which stores date in MM/DD/YY format. I have a ASP.Net web form, which gives me a date in DD/MM/YY format (en GB culture). This date gets automatically store... |
|
| ordering by date (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hi all, I am working on a WebForum using VB.Net & Access2K. I want to give the user an option to select to view messages posted in the last 7 / 15 Days. Can any one tell me how can I do it? I have the following query, but this will return me only if a particular date is selected SELECT [UserName], [Subject], MessageDesc, [DateCreated], [MessageViews] FROM tblMessages WHERE DateCreated [@Date]; TYA... |
|
| Get date function (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hi all, I want to insert the current date. How do I do this using an access query. similar to the Getdate() in SQL Regards Srini |
|
| How to use IsDBNull() with literal field name (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdatagridrepeaterdatalist] to [ngfx oledb] by James Avery javery@deluxeeng.com Hi !!! At present I use the following to detect null field values : while (myReader.Read()) { if (!myReader.IsDBNull(12)) { ..... my code .... } } where myReader is a oledbdatareader Is there any way by which I can use the literal field name instead of field column number. Hope you can help me !!! Sum |
|
| Variable Parameters and returning a Dataset (4 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hi All, I'm writing a DLL which searches the Database and returns a Dataset, the problem I'm facing is that I have 4 Search Parameters but not everyone needs to be used. I tried to get arround this by using " Select * From Table Where (Cell1 Like '* parameter *') And (cell2 Like '*parameter2*')" etc. This works in Access but does NOT return anything through the OleDb Class. So my question is: What... |
|
| Please Help. OleDbDataAdapter.Update(dataset) method does not update database. (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Yannick Smits dotnet@stepcompany.com Hi, I'm using the following code to update database through dataset but the update method of dataadapter does not update the database. Please guide. %@ Page Language "C#" Debug "True"% %@ Import namespace "System" % %@ Import namespace "System.Data" % %@ Import namespace "System.Data.OleDb" % HTML HEAD script language "... |
|
| ASp.net connecting With Oracle (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngstart] to [ngfx oledb] by devin devinr@drone interactive.com Guys Any idea what this error means? Anyone seen this? Regards Deepak Microsoft OLE DB Provider for Oracle (0x80004005) Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is un... |
|
| Error Trying to Update an Access Database (6 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngfreeforall] to [ngfx oledb] by Chaz charlesmarkcarroll@yahoo.com I try to update an Access Database using an Update query and the following code: Dim comAnyCommand As OleDbCommand Dim shoRows As Short Try comAnyCommand New OleDbCommand(pstrSQL, mdcnDatabase) shoRows comAnyCommand.ExecuteNonQuery() The execute fails the error is: Operation must use an updateable query. I found this... |
|
| SQL Function (3 replies, VIP) |
| ASPFriends.com 'ngfx-oledb' list |
| MessageI need a function in Oracle SQL to rounded a number but always to the max. Example: if the number is 0,1 the function must return 1 if the number is 0,9 the function must return 1 I tried with ROUND but it doesn't work because when the number is 0,1 the returned value is 0 Thanks Lucas Lodeiro Teletec Soluciones S.A. Tel: 54 (11) 4554 4666 Cel: 54 (11) 5007 6026 |
|
| OLE DB provider for Oracle. (4 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hi, I'm using "Microsft OLE DB provider for Oracle" to connect with oracle. I'm trying to create connection string through .udl file, i specified server name, user and password and then tested the connection, it is giving me the following error. "Test Connection failed because of an error in initializing prov... |
|
| Need MDAC version 2.6 or later (4 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngvb] to [ngfx oledb] by James Avery javery@deluxeeng.com I hit a error as following: System.SystemException: The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later. System.Runtime.InteropServices.COMException (0x8007007F): The specified procedure could not be found.... |
|
| unanswered question (9 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| hi all please help me in following code as working... in web.config i have... appSettings add key "strMyDbaseCon" value "Provider Microsoft.Jet.OLEDB.4.0; Data Source c:\inetpub\wwwroot\qtrmgmt\database\qtr.mdb;"/ /appSettings my function is like... Public Sub CreateMyOleDbCommand(ByVal myExecuteQuery As String, ByVal myConnectionString As String) Dim myConnection As New OleDbConnection(myConnecti... |
|
| The Microsoft Jet database engine cannot open the file (3 replies, VIP) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngstart] to [ngfx oledb] by Ken Schaefer ken@adOpenStatic.com Ok, I give up. I am getting this error no matter what I try to do to access an access database to get familer with asp.net as I can't afford sql server to do sql testing. I've installed MDAC 2.7 and made sure I added "aspuser" to the directory (and all files inside) as full control (read,write,change,delete). I erased the... |
|
| SQLServer Database in access? (5 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Marcie Jones marciejones@yahoo.com Is it possible to open a SQL Server database in Microsoft Access? I find the design tools are far superior to those of SQL Server... Anyone know how to do this? THANX! Gavan Brown |
|
| Connecting to Oracle (5 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| C'd anyone send me sample code to connect to oracle from an aspx page. I have installed the client on my m/c but when i run the foll. code, i get an error on the conAuthors.Open() statement. It doesn't seem to be finding the oracle stuff, although when i try to test teh connection from ODBC tester, it works fine. Whats missing? Thanks deepika %@ Import Namespace "System.Data.OleDb" % % Dim conAuth... |
|
| How would I get a first value from this dataset? (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngcommunity] to [ngfx oledb] by Charles M. Carroll charlesmarkcarroll@yahoo.com In the code below, I have bound the results of myCommand to a DataGrid called myList. How would I extract the value of the first emailID returned in the same query? I could yuse another query such as SELECT Top 1 EmailID from Email, but I am terying to avoid 2 queries... Any suggestions.. Here is my code... |
|
| MySQL with ASP.net? (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngcommunity] to [ngfx oledb] by Charles M. Carroll charlesmarkcarroll@yahoo.com It s possible to use MySQL with ASP.net? I ve tried using a DataReader to retrieve data from the database, but it says that I need to use a valid OLEDB connection string. Urgent plz!!! Help me! |
|
| NOT ANSWERED: how can i store a value selected from a oledb as a string? (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hi I want to get a version number from a oledb/database, How can I store this number as a string/integer so I can set number number 1 and add this in my insert new record statement? Dim myCommand2 As New OleDbCommand() Dim myString2 As String myString2 "SELECT VersionsNR FROM Oppg delt ORDER BY VersjonsNR DESC WHERE Gruppe " & myGruppe myCommand2 New OleDbCommand(myString2, myConnection) myCommand... |
|
| how to use ASP.net connect DB2 (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by PeterB peter@aspdll.com Moved from [aspngstart] to [aspngdata] by Marcie Jones marciejones@yahoo.com how to use ASP.net connect DB2 because ASP.net not support ODBC and ASP.net only have sqlclient , oledbconnection. i dont know how to connect DB2... |
|
| Could not find installable ISAM (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngfreeforall] to [ngfx oledb] by Marcie Jones marciejones@yahoo.com Hello Guys I am getting this error: Could not find installable ISAM. I am getting it when I do this line: objcmd.Connection.Open (third from the bottom). What can be causing this problem? Thank you for any help. dim intID As Integer 0 dim objConn As New OleDbConnection ("Provider Microsoft.Jet.OLEDB.4.0;DataSource "... |
|
| how can i select method based on a query in database? (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hi How can I, based on a query in a database using oledbdatareader (vb) select a specific method? I search in db if there is any match (username, and ID). I can get that the person is right, metA else metB. How can I do this... Eivind |
|
| Return Value From Stored Procedure (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Copied from [aspngfreeforall] to [ngfx oledb] by Marcie Jones marciejones@yahoo.com Hello Guys I am having a problem with a returned value from a Stored Procedure (unfortunately, it is Access, as that is the only database I can use for this site). The problem child is "intID." I am attempting to set it in the Try part, but it is still 0. I know the actualy SP works, as I ran it with the values, an... |
|
| Specifying DSN names in Database Connections (4 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Copied from [aspngfreeforall] to [ngfx oledb] by Alex Lowe webmaster@asp grandrapids.net Hi , I have a problem in connecting to Access Database if the database is in another machine. I have created a DSN in my system for this database, but I don't know what's the exact format I need to give with OLEDBCONNECTION object for initializing the connection. If I give something like this, am getting error... |
|
| Calling Ora Stored Proc that returns "Table type" variables? (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Copied from [aspngdata] to [ngfx oledb] by Alex Lowe webmaster@asp grandrapids.net Does anyone have an example of how to call an Oracle Stored procedure that returns variable of type "TABLE" using ADO.NET? 20 Given the following definitions, how would you call "MyProcedure" and capture the returned information? I have looked around and I haven't seen anything like this posted. Package MYTYPE AS TY... |
|
| Syntax error in Update command (5 replies, VIP) |
| ASPFriends.com 'ngfx-oledb' list |
| Hi, I am trying to execute the following sql statement against a MS access db. The query works fine in Access Query Analizer but throws the exception below in OleDb. Any suggestions? UPDATE USERS SET Password 'test', Email 'test', Role 'Admin', ClubName 'rdsf' WHERE UserName 'test' System.Data.OleDb.OleDbException: Syntax error in UPDATE statement. at System.Data.OleDb.OleDbCommand.ExecuteCommandT... |
|
| Connection Pooling (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| I was setting up a data access class and wanted to make sure I was not inadvertently disabling connection pooling as described in: http://msdn.microsoft.com/library/default.asp?url /library/en us/dnmdac/html/pooling2.asp I have a db access class that contains a connection object used by all the methods with in it (get a rs, datareader, etc). When I am done with the class (my dispose method) I ensu... |
|
| Using Oracle in .NET (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Copied from [aspngdata] to [ngfx oledb] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hi all, I have a question about working with Oracle Stored Procedures. The last few months I used a Microsoft SQL Server database with stored procedures for selecting data. From within a SQLCommand I was able to fill a dataset based on the result of a microsoft sql server stored procedure. At this moment the... |
|
| oledb.type for parameter? (3 replies, VIP) |
| ASPFriends.com 'ngfx-oledb' list |
| I am using parameters for Access and Oracle. When creating a parameter you need to specify the oledb.type for example, OleDbType.VarChar New OleDbParameter(name, OleDbType.VarChar, length) Is there a list or easy way to relate the Access and Oracle data types to the oledb.type? I just guess now. |
|
| Problem with delete - OleDbDataAdapter.Update (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Copied from [aspngfreeforall] to [ngfx oledb] by Charles M. Carroll darthcarroll@asplists.com I am trying to delete a row from a datatable using OleDbDataAdapter.Update I manage to add rows and change in rows, but for some reason Deleted rows are still there. This is the code. (simplified) Any ideas? Private Sub btn delete Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles b... |
|
| Oracle stored procedure with an out parameter with VB.NET (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Copied from [aspngdata] to [ngfx oledb] by Charles M. Carroll darthcarroll@aspfriends.com I am trying to call a stored procedure in Oracle that contains an out parameter. Here is my code: Dim oledbCn As OleDbConnection Dim oledbCm As OleDbCommand Dim strCn As String "Provider OraOleDb.Oracle;Data Source dotnet localhost.wallymdevelopment.com;User Id usruser;PassWord usruser;" Dim strSql As String ... |
|
