[ado] Forum Topics

Hi! My database is in AS/400 DB2 hence, I am using SQL. Here's my line of code for opening a connection. Dim str As String = "User ID=EDITH;Password=EDITH;Data Source=10.0.1.11;Initial Catalog=ictms;Integrated Security=True" Dim conn As SqlConnection = New SqlConnection(str) conn.Open() Now, I wanted to execute a delete query, however, I already …

I am trying to connect a Crystal report to my database.mdf i.e SQL Server database. When using the wizard At the [I]Database Expert[/I] window after choosing the [I]OLE DB (ADO) [/I]i can not find any server and a database in the drop down menu. how to get that? i have …

hi, I need a help.how can i SEARCH a record in a database using listbox and display the results?? For an example: if i select a destination on the listbox and it will look for the records on database and display it. im using ms access and adodb connection.Below is …

Hi Guys, is there a Code snippet which allows me to check if a certian ADO Connection has been setup on a clients Local machine and if not then disable certian Radio buttons? The reason I ask is I have a 'Read-Only' Connection to a DB (Don't ask.. that's all …

i have a problem when updating database. i need to update stock value in other table and count it and update to another table again. here the code : 'in every row on 'SalesDetailBindingSource' For Each SalesDetailData In SalesDetailBindingSource MsgBox("SalesDetailData : " & SalesDetailBindingSource.Count) 'dim use to take parameter Dim …

Hi guys... I have a radio button that one checked will connect to an ADO Connection. The following code being used is: private void radioButton3_CheckedChanged(object sender, EventArgs e) { //Fields Disabled until a new Account is created.// txtAccRef.Enabled = false; txtAccName.Enabled = false; txtAccAddr1.Enabled = false; txtAccAddr2.Enabled = false; txtAccTown.Enabled …

Hi Guys, Is there a best practise when having an ADO connection to speed up the process? Currently the method I am using below works fine but it's a little slow in getting the data. Is there any hints, tips or tricks I can utilise to speed this up? //Opens …

I am working with sql server using ADO provider. My code uses recordsets and commands to run quries and I fail to understand a basic issue - connections. In my code, they set a connection string (which is being built in the code, not taken from other ADO element) to …

I'm really new in ADO for just a substitution on Data Control (I cannot dl any access 2003 D:) --- Whenever I enter command3, it says: *Compile Error: Method or data member not found* and the highlighted one was **.EOF** Code: Private Sub Command3_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.Find "SID = '" & …

Hi I have a big (working) software written in C++ that uses SQL database, using the ADO interface. I'm currently using old ADO libraries (prior to the Windows7 SP1 problem) and wish to upgrade. I'm considering taking advantage of this need and upgrade to ADO.NET. What do you think?

Hi Guys, I'm currently working on a small item that I hope you will be able to help with. I have used an example Code to get connected to 'Sage Line 50' data and it seems to work correct. Currently it populates the Combo Box with the Database Scheme and …

Good day! I just want to ask on what is the best ADO connection string to connect to MS Access fast? and what is the fastest way to create it? And also, where in the project to best put it so that all forms in the project will use it …

I have an application that is writen in PHP and connects to a MS SQL Server 2008 Database. I'm using ADO recordsets. There are cases where specific IDs and years in the table returns nothing. How do I test for when there are no results? I searched and most of …

Hi i'm unable to do multiple update (using Ms Acess because of restrictions). I try to do through ADO method (also because of restriction , x ODBC). The operation will break when reaching the script to update on the second page. Can you guys point where did i went wrong? …

Hello guys. Just wanna know how you could add item to a vb 6 list box or combo box that is bind to a database? I.e. Ado oledb. Let say i have 1 text box wherein every time i input a data to it. It would be added to a …

I have been fighting with this all day and looked at so much documentation and other posts I think I am going blind. I can't find an answer that works. I am trying to read through a set of records until the reference number changes and then return to the …

Hi there, Currently I am making an payroll system using VB6. There is a form where it is used as a search form. We will input the name in the search bar. So what I want to ask is that, is it possible that without clicking the search button and …

hello everyone i have this error saying "requested operation requires ole db session object which is not supported by the current provider"..i wonder why this appears.i am using an ado and using vb6..can someone enlighten me with this problem..thanks

Hi all, I am trying to produce a basic till system, and at current am using an ADOquery to bring up the items ordered along with their relevant prices in a DBGrid. What I now need to be able to do is use the price values contained within the DBGrid …

I have a legacy VB6 application; simple VB6 front end and Access backend database. Works fine on Win 2000, WinXP, Vista, and 32-bit Win7. Bought a new laptop and everything seems to be shipping with 64-bit Windows now. Out of the box, the application worked fine after I manually re-registered …

Problem is based on C#, ADO.NET, using Access Database. I am trying to filter the results from the database and display them in DataGridView on click of 'button1' button. But the datagridview shows empty results when there are actually 3 records with matching conditions. According to what I know, the …

how to add record into my database mysql

First, sorry for posting this here, but I couldn't find a VBScript forum on Daniweb (which I find surprising). I'm working with binary data in several different projects. Below is an example of code that works to retrieve a static map image (PNG) from Google: [CODE]strFileURL = "http://maps.google.com/maps/api/staticmap?markers=2200+S+Western+Ave+Lisle+IL&zoom=14&size=400x400&sensor=false" Set objXMLHTTP …

how do I link ADO data control with a protected access database ???

Hi all, I'm writing an application that imports and tidy up address data into a cleaned, deduped excel workbook ordered in rows with each column as an address field. One of the issues I've ran into is that we sometimes get a workbook where the multiple address fields are held …

I've been working on getting a SQL DB to return records through an ADODB.Connection object and have had zero luck getting it to work in VB6. Whereas I created an ASP form using VBS to produce the exact same functionality with no issues. In VB6, I've included the following references: …

Hi, I am new to this website (and C++) so pls forgive any newb errors / convention mistakes. I have a project that contains both a normal source file (PB.cpp), associated header (PB.h) and a windows form (GUI.h). I'm trying to pass a variable from the form to a function …

Hi, I have a little problem with a macro I'm working at. I need to pull data from a database and then show it in an excel sheet. Everything work fine till the moment when I want to close the recordset . Then my application freezes and I have to …

Hi, i'm not sure this is in the right place but here goes: I'm currently using ADO in VBScript to access a SQL Server database and one of my current issues is returning the full error message that a stored procedure generates. I can get a brief error description and …

can anyone post a tutorial or a link to tutorial where it would help me understand ado codes for connecting to my database . . . i'm really a newbie about ado codes. . . i haven't even tried to code using it yet . . . i just heard …