ADODB Recordset Open method crashes Calling program

Hi,

New to ADODB, Using ooREXX ole class to call it which works fine for me
with lots of other applications.

Trying to query a table from an Access 2000 database.

...
dbfile='C:\FILES\CENTRE\TEST.MDB'
query="SELECT * From People"

conn=.oleobject~new("ADODB.connection")
conn~provider="Microsoft.Jet.OLEDB.4.0"
conn~open(dbfile,conn)
rs=.oleobject~new("ADODB.Recordset")
rs~open(query,conn)
...

The connection and recordset objects seem to instantiate alright, but
when I send the open message to the recordset (rs~open("People",conn))
the ooRexx interpreter manages to resolve the arguments and send the
message, but then the interpreter crashes completely without even the
chance for it's error handling to kick in. This is something I have
never seen before (short of pulling the plug) in 22 years of using the
language.

Others in the open Object Rexx community manage to perform similar
tasks with similar code without this problem and cannot help me.

I have tried various different databases, opening tables rather than
queries, setting the connection timeout attribute to 0 (although the
crash seems to be instantaneous), but this always happens.

I know the code probably looks unfamiliar, but does anyone have any
idea why this is happening.

I am running on XP Home SP2

Here is the connection string generated:
Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=C:\FILES\CENTRE\TEST.MDB;Mode=Share Deny None;Extended
Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry
Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet
OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet
OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet
OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet
OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without
Replica Repair=False;Jet OLEDB:SFP=False

Connection object Version = 2.8

One clue might be that the connection string specifies USER ID=Admin
and there is no such account present on my machine.

many thanks for any help you can give,

Jon

.

Relevant Pages

  • Re: Complicated Connection Problems bewteen ADP and SQL Server
    ... front end on the 5-8 workstations where the users happen to sit. ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... thought that I should instead change my connection string to something ...
    (microsoft.public.access.adp.sqlserver)
  • Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
    ... Also see http://www.connectionstrings.com/ and try other providers ... > Here is some of my connection code: ... >> And are you sure your connection string is ok. ... >>> Oracle error occurred, but error message could not be retrieved from ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Changing Connection String programmatically
    ... This is a good situation for putting the connection string information in the app.config file. ... every year we will create new database. ... change the body of the private void InitConnection(), ...
    (microsoft.public.sqlserver.connect)
  • Re: Deployment + Vista
    ... I'm talking about the user being able to edit the server connection setting ... MSI will allow you to edit the app directory, ... function in order to put together the connection string something like: ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Loop through Excel Files and Tables
    ... I'm having some issues using the ForEach container to process multiple excel ... and trying to reuse the connection strings they built up ... The connection string format is not valid. ... Warning: 0x80019002 at Foreach Loop Container: The Execution method ...
    (microsoft.public.sqlserver.dts)