I'm fairly new to database programming in WinForms, and have been using BindingSource, DataSet, and TableAdapter controls to display data from an Access database in grid and Component One Chart controls. The app is fairly simple right now - the user selects a row in the grid, and a related set of data points is plotted in the Chart cont...
I'm calling a COM library from .NET through a interop assembly and getting the following error: System.Runtime.InteropServices.COMException(0x80040200): Internal error (ADODB.Connection, -2147467259, Property value is invalid. Make sure the value is typed correctly.) I have a test and a production version of the same external system. W...
I am having trouble calling the following stored procedure. When I call ExecuteReader, I am getting the error 'Incorrect syntax near 'GetAverages2'. I can create the stored procedure and call it from TSQL. I can't seem to get it working from ADO: CREATE PROCEDURE GetAverages2 @CompanySize INT, @Q1 FLOAT OUT, @Q2 FLOAT...
Hello I have a classic ADO command which execs a sproc and returns a RecordSet. This is being executed from a VB.NET using the PIA. However when I .Execute the command, the result returned is not an ADODB.Recordset but a System.__ComObject. Wonder if anyone has seen similar behaviour? ...
What is the best way to use an embedded database, say sqlite in Python: Should be small footprint. I'm only needing few thousands records per table. And just a handful of tables per database. If it's one provided by Python default installation, then great. Must be open-source, available on Windows and Linus. Better if SQL is not wri...
Heloo All, I have two simple tables. Tbl_Users, Tbl_Roles. Tbl_users is defined as... UserID --> PK(Varchar) UserName Password RoldID(Int) Tbl_Roles is defined as ... RoleId --> PK(int) RoleDescription(varchar) Data Model is ADO.NET Entity Data Model, SilverLight3.0(Navigation Apllication), .NET RIA Services Class Lib. All I need t...
Excel's NETWORKDAYS function returns the net working days between two dates. Is there a way of replicating this when connecting to a Jet database via ADO? ...
I'm using Delphi 2007 with ADO to access a MS SQL 2008 database. A stored procedure on the database prevalidates the input and if the validation fails it returns an error result set (containing custom error info). Uisng the SQL Server Management Studio, when I run the stored proc I get the custom error result set in one tab and the nat...
I am writing an application that allows a user to submit a query to multiple systems. I then save each report from each system using SaveToFile, which saves it as an XML document. The user can then inspect each report by selecting it from a menu, and the report is displayed by loading the report back into an ADO Query component (using ...
I had a Delphi 4 program that I developed many years ago that used Opus DirectAccess to sequentially search through a Microsoft Access database and retrieve desired records. Delphi 4 did not have ADO, so that's why I was using DirectAccess. But I've now upgraded to Delphi 2009 and converted the program to use ADO. What I found was that ...
I'm having trouble with a filter on an ADO Recordset in legacy ASP Classic code, and I'm trying to understand if what I'm trying to do is not supported, or if I'm just doing it wrong. I have a recordset of Items, and they have a Status of 1 (active) or 0 (inactive), and an optional End_Date. In my administrative user interface, I have ...
I have a classic ASP page that gets POSTed to. The data gets POSTed as UTF-8 (I can see this in Fiddler). I then open an ADODB connection to a database and store the data in a VARCHAR field. If the data can be represented by 8859-1 (e.g. iñtërnâtiônàlizætiøn) it is stored correctly in the varchar field. If I try strings that can't be...
I found an interesting article at MSDN, which says: ADO makes it possible to treat an Excel workbook as if it were a database. So is it possible for an Excel workbook to connect to itself, and treat one of its worksheets as a database table and execute queries on it? -- and is this possible via VBA programming? ...
Language is vbscript and classic ASP. The following SQL works when values are hard coded in the sql statement: sql = "UPDATE STORE2_ITEM SET sku = 'abcd' WHERE id = 224 and host_id = 1" What I'm trying to do is add parameters so I replaced the field1 assignment with the following: sql = "UPDATE STORE2_ITEM SET sku = ? WHERE id = 224...
Using SQL Server 2005 and VB6 When I executing for yearly data or more than 3 months' data, it is showing "Timeout Expired" error. It is not executing completely. My Connection String ConnectionString = "Provider=SQLOLEDB.1;" & _ "Persist Security Info=False; " & _ "User ID=" & Settings.SQL_Username & _ "; Password = " & S...
I found this code online to query Access and input the data into excel (2003), but it is much slower than it should be: Sub DataPull(SQLQuery, CellPaste) Dim Con As New ADODB.Connection Dim RST As New ADODB.Recordset Dim DBlocation As String, DBName As String Dim ContractingQuery As String If SQLQuery = "" Then Else DBName = Range...
So I didn't see the answer to my question: Is there a difference (performance or otherwise) between ADO vs. DataSet? If so, which is more common? ...
I'd like to add a DataTable to more than one DataSet without calling DataTable.Copy(). Simply copying the DataTable doubles the amount of data in memory and causes me to manage its changes. This problem exists because I am implementing a detail tables solution where a detail table can have more than one master. If it helps, consider thi...
I've almost got a basic set of helper functions done for accessing ADO through PHP. I'm running into a problem when trying to execute a stored procedure with the adExecuteNoRecords option set for $cmd->Execute(,,adExecuteNoRecords); I've tried null's for the first two parameters, new VARAINT(), new VARIANT(null), new VARIANT(VT_EMPTY), ...
I am developing Delphi 7 application, which is operating with Access Database (MDB format). It works fine on my PC, and some other PCs as well. But on some machines application gives error when trying to access database sometimes, saying something like "Unkown database format (mdb)". Additionally I noticed one thing: When you open that d...