I have an Excel application with an ADO database connection. The connection string is:
"DSN=LIVE_TRICS;DATABASE=" & sTRICSdbName & ";UID=eod_fe;PWD=design2"
My application will be used by sev...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23093165.html
I am trying to connect from macro in MS Word writen in VBA
to Oracle 7.3 using ADO. I have created DSN using microsoft
ODBC driver but every time when macro tries to connect to
Oracle I get "unspec...
http://www.experts-exchange.com/Database/Oracle/Q_10089300.html
Zones:
OracleDate Answered: 10/26/1998 Grade: C Views: 0
Hi,
Got a Excel spreadsheet here. Its password protected on a network drive.
Now ive read the MS article about password-protected Excel spreadsheets - and i have the Excel file opened. This a...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_21079410.html
Zones:
VB DBDate Answered: 09/19/2004 Grade: A Views: 15
I am using ADO 2.8 in VBA. I create a record set. This recordset is passed by Reference to a sub routine. The recordset is advanced forward several records. Before leaving the subroutine I check th...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_22500459.html
Zones:
VB DBDate Answered: 04/10/2007 Grade: A Views: 0
Hi
using ADO, I'm executing a stored procedure that should return 2 datasets in a recordset object
PROBLEM: when i "dump" the data into a spreadsheet i only see dataset #1.
Is there a way ...
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/XP/Q_22737623.html
I am using Access 2003 with some VBA code. The VBA code accesses the data from an ADODB.Connection call. To enable this in my testing environment I need to go to Tools -> References and select one ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22903273.html
Zones:
MS AccessDate Answered: 11/16/2007 Grade: A Views: 17
I have an xml column in a SQL Express 2008 table that I want to obtain through an ADO 2.8 call in VBA. It always comes back as an empty string. In the snippet below, GetSCFText is a stored proce...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2385...
I've written some SQL query in Access. I want to run this query in VBA ADO and count how many records are returned in this query.
How can I achieve that?
Thx
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21154388.html
Zones:
MS AccessDate Answered: 10/03/2004 Grade: B Views: 0
I'm using Access 2000.
I've opened a query in VBA using :
Set oRS = CreateObject("Adodb.RecordSet")
oRS.Open QueryName, CurrentProject.Connection, 0, 1
This query holds data that I want t...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21882878.html
Zones:
MS AccessDate Answered: 06/16/2006 Grade: A Views: 0
Hi All,
I have a series of log files I'm trying to organize into excel by treating the text logs as an ADO Recordset.
The format of the logs is as follows:
"Column1" "Column2" "Column3" "C...
http://www.experts-exchange.com/Programming/Languages/Q_21927578.html
Zones:
LanguagesDate Answered: 08/28/2006 Grade: A Views: 0
