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
0 answers

Not able to connect with a remote Firebird database using PHP and Adodb from a Linux server

I made some changes to the code and it looks like I can connect to the Firebird db using the Adodb library:
Sd1
  • 3
  • 2
0
votes
3 answers

Preventing a database from rejecting user input

I'm making a simple interface that will allow a user to modify pieces of CSS and HTML which are stored in a Microsoft SQL database. This interface uses PHP5 and ADOdb. For some reason this form will reject any input which contains one or more…
James
  • 2,626
  • 5
  • 37
  • 51
0
votes
3 answers

Executing Multiple SQL statements in a single command against SQLServer Database in vb6

I am trying to execute multiple SQL statements against a SQL server database using ADODB and vb6. when I open a recordset the code stops with the following error code: Run-time error '3704': Operation is not allowed when object is closed. here is my…
Sulieman Mansouri
  • 519
  • 3
  • 13
0
votes
1 answer

convert this ADODB crystal report to OLEDB

I don't know how to convert the ADODB into a OLEDB. I'm having problem in DataTable, Recordset and Recordcount. I really don't know how to convert this into OLEDB ADODB Module Public con As New ADODB.Connection Public rec As New…
mr. AL883
  • 3
  • 3
0
votes
1 answer

WebMethod failure

I have the following webmethod on a asmx page that will not connect to my database. Can anyone shed any light on where I have gone wrong. [WebMethod] public int[] getEmployeeIDs() { Connection conn = new Connection(); …
Chris Music
  • 109
  • 11
0
votes
2 answers

Executing a Query in ADODB in VB6

I have a program in Visual Basic 6 thats listens to a ComPort and generates SQL Querys based on the data it recieves. Im using ADODB as my Database link of choice. Currently im trying this: ' Initiate Database Connection Call dbConn …
Magisch
  • 7,312
  • 9
  • 36
  • 52
0
votes
2 answers

Singleton factory for managing and wrapping multiple database objects

I'm building a PHP application which has to interact with several structurally identical databases. I'd like to use a singleton factory to hand out connections to the databases and minimize the number of duplicate connections. I'd also like to wrap…
James
  • 2,626
  • 5
  • 37
  • 51
0
votes
2 answers

SET NOCOUNT ON using ADO is not supressing PRINT messages

In my application I am using the following code: Set oRs = oConn.Execute("SET NOCOUNT ON; EXECUTE mySp;") mySp returns PRINT messages and my application is returning them as errors. How do I make it so the PRINT messages don't show up so it won't…
RealWorldCoder
  • 1,031
  • 1
  • 10
  • 16
0
votes
1 answer

ADODB connection to .mdb file from excel 2013

I hope someone can help. I've developed an excel package that updates a .mdb access database through the connection string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\" The database is shared. I have a Mitel telephony system that checks the…
DezyK
  • 65
  • 1
  • 9
0
votes
1 answer

Microsoft Access Database Engine 2010 Redistributable 64 bit only works if Enable 32-bit set to true

I have an ASP classic application that I'm migrating from a Windows 2000 to Windows 2012 Server. It uses the following code to import xls files Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "DRIVER={Microsoft Excel Driver…
Dijkgraaf
  • 11,049
  • 17
  • 42
  • 54
0
votes
3 answers

ADODB Getting the column count

I was reading through our code base at my company and I saw something that seemed like it could be done better. $dbRow = $dbh->Execute("SELECT * FROM database.table LIMIT 1"); $tableColumnCount = $dbRow->_numOfFields; Is this the only way to get a…
stevebot
  • 23,275
  • 29
  • 119
  • 181
0
votes
1 answer

Spaces Added in Cells Filled with Recordset Value

I have a subroutine that fills cells with data from an SQL DB. Here is a sample of the code that I'm having trouble with: For varTempInt = 1 To varHdrRow - 2 Cells(varTempInt + 1, 2).Value = varRecordset.Fields(varTempInt - 1).Value Next The…
jaysoncopes
  • 805
  • 3
  • 13
  • 26
0
votes
1 answer

Outlook VBA - Not able to update database

I am having issues with updating my database. I am using an ADODB recordset. It is giving me this error: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. However, the query does…
Fly Guy
  • 255
  • 1
  • 4
  • 12
0
votes
1 answer

tsql arithmetic overflow converting expression to data type int only with adodb

with the application I am working on I get this error: error '80040e57' Arithmetic overflow error converting expression to data type int when this query: SELECT 0 as type_elm , 999 AS key0 , def_car.desc_elm as sh_elm , def_car.desc_elm ,…
arpho
  • 1,576
  • 10
  • 37
  • 57
0
votes
2 answers

VBA winhttp equivalent for local file

So I currently have a sub which copies documents stored on our intranet and saves them to our shared drive. Now, I would like to do the exact same thing, but with a file stored locally on a users computer, not on the intranet. How could I do…
mrlemmer11
  • 347
  • 2
  • 15
1 2 3
…
99 100