Stack Overflow
Stack Overflow

Questions tagged [adodb]

ActiveX Data Objects, a Microsoft middleware for accessing data sources. Allows to access data from various languages without knowing how the database is implemented. Successor of RDO (Remote Data Objects) and DAO (Data Access Objects), first introduced in 1996.

1825 questions
0
votes
1 answer

RecordSet.RecordCount returns -1

I know there are tons of questions on this and most of them say setting the cursor location fixes it (resultSet.CursorLocation = adUseClient). This still returned -1. I then found a post that said to try RecordSet.MoveLast, then get the…
user736893
0
votes
0 answers

Visual Studio VB.NET Global ADODB.CONN

I am building an application that requires me to query an AS400 database up to 100 times per single use. I have functions for each of the queries right now written in the following structure. Option Explicit On Shared Function query1() Dim conn…
rOcelot
  • 1
  • 1
0
votes
1 answer

ADODB Error inserting to Access DB with JavaScript

I am writing an .asp file to insert data to an Access database using the following JS: MM_query = "INSERT " + "INTO Employees (FirstName, Surname, Department, Email, FaxNumber, JobTitle, KnownAs, MobileTelephone, WorkTelephone,…
Bailz
  • 605
  • 2
  • 8
  • 17
0
votes
0 answers

Add column to Select * ADODB csv connection

I have the following code that aims to convert multiple csv files into a single array in VBA. The code works perfectly except for the one part. This works just fine: Sub CreateArrayFromCSV() Dim cn As ADODB.Connection, RS As ADODB.Recordset, strSQL…
Spurious
  • 1,903
  • 5
  • 27
  • 53
0
votes
1 answer

Problems with SQLNCLI connection string

We have fresh installation of SQL Server 2012 on WIN2012 64 bit. According to ODBC Administrator, SQL Server native Client 11.0 is installed, too. However, while trying to connect to SQL with "Provider=SQLNCLI..." or "Provider=SQLNCLI11..." or…
Baufix
  • 31
  • 5
0
votes
0 answers

VBA + ADO: Insert without select?

I'm writing some Excel VBA for a user to be able to insert records into a SQL Server table, using ADODB. This is working fine: Dim conn As New ADODB.connection conn.Open "" Dim records As New…
user1454265
  • 868
  • 11
  • 25
0
votes
1 answer

Argument Not Optional error connecting to Access database

I have this simple coding for a login form in vb6 with connection to an Access database, but every time I compile this code, it shows an error: Argument not optional and highlights the Private Sub Loginbtn_Click() and txtUsrName. Private Sub…
Lakshmi
  • 1
0
votes
1 answer

MSAccess/SQL lookup table for match field based on sum of current table.field

I've been battling this for the last week with many attempted solutions. I want to return the unique names in table with the sum of their points and their current dance level based on that sum. Ultimately I want compare the returned dance level…
Dacam
  • 13
  • 5
0
votes
0 answers

Fatal error: Call to a member function SetFetchMode() on a non-object error

I was using ADODB to fetch data. I get error like this: Fatal error: Call to a member function SetFetchMode() on a non-object and this is my code: function createAdodbConnection($fetchMode = ADODB_FETCH_ASSOC) { $self =…
Hello Man
  • 693
  • 2
  • 12
  • 29
0
votes
1 answer

Read Excel using OLEDB with Cell Format

I am reading excel sheet using ADO DB in C# but the problem I am facing is it is not able to copy the cell data with its format. For e.g. One of my cell is in Currency format ($2,123.45) so when I am getting the result set I am getting the cell…
Piyush Kumar
  • 1
  • 3
0
votes
1 answer

Why does my script seem to randomly truncate strings?

The script below basically takes a source table and a target table and copies all the records. It works fairly well, but one recurring issue I'm having is that it seems to truncate some strings. Here is one of the error outputs: Error Number:…
user736893
0
votes
1 answer

How do I turn a QueryTable Connection into an ADODB connection?

I'm trying to update an old excel sheet that uses QueryTables to connect to a Microsoft SQL Server. The following is working: With ActiveSheet.QueryTables.Add(Connection:= _ "ODBC;DSN=[dbname];UID=[name];PWD=[pass];APP=Microsoft Office…
neogeek23
  • 813
  • 1
  • 12
  • 23
0
votes
1 answer

VB6. Proceesing ADODB Table Is there a better way of doing this?

I am using .Open to check if record exists. If it exists, I delete it. If not, I an adding it. Then I close the ADODB Recordset. I am sure there is a better way of doing this - and this is probably a slow way of doing it. Is there a way of doing…
Steve Staple
  • 2,983
  • 9
  • 38
  • 73
0
votes
0 answers

UTL_FILE command through ASP.NET gives "[Oracle][ODBC]Syntax error or access violation." error

I am trying to execute a PLSQL UTL_FILE command through an ASP.NET web app and keep encountering this error; [Oracle][ODBC]Syntax error or access violation. I am passing in a string (filename) into the sql (insql) and using the below code to…
chrisberry86
  • 35
  • 1
  • 1
  • 9
0
votes
2 answers

Limit access to an Excel file database

I'm using some Excel files like databases. Those files are read by a VBA code that extract data from it. For example I've created an Excel file containing logins and password to build an authentification system. What I would like to do now is to…
otus
  • 385
  • 3
  • 10
  • 28
1 2 3
…
99
100