| IDLdbDatabase - how to check the connected dataSource name? [message #31835] |
Thu, 22 August 2002 04:14 |
Martin Downing
Messages: 136
Registered: September 1998
|
Senior Member |
|
|
Hi All,
Long time out of contact, now I seem to be doing a little datamining!
My problem is this:
I have a IDLdbDatabase object, I can see whether I have a connection using
>oDB->GetProperty, IS_CONNECTED=IS_CONNECTED
However assume I have previously connected it to a source:
>oDB->Connect, datasource = sources[index].dataSource
where the source is
IDL> help, sources[9], /str
** Structure DB_DRIVER_INFO, 2 tags, length=24, data length=24:
DATASOURCE STRING 'UMRdatabase'
DESCRIPTION STRING 'Driver do Microsoft Access (*.mdb)'
I now want to retrieve a new recordset from the same source - how do I
check the source is correct? I thought that this would work:
>oDB->GetProperty, DBMS_NAME=DBMS_NAME
>print, "connected to ", DBMS_NAME
However this prints:
connected to ACCESS
I could look at the available tables:
IDL> tables = oDB->GetTables()
IDL> help, tables[0], /str
** Structure DB_TABLE_INFO, 4 tags, length=48, data length=48:
QUALIFIER STRING 'D:\Data\rsa\Hip4\UMRSA_LINK'
OWNER STRING 'B'
NAME STRING 'qXrayReport2'
TYPE STRING 'VIEW'
And check the "qualifier" string. However the "dataSource" is an alias to
this database, so what I would like to do is confirm the
dataSource, any ideas?
Martin
----------------------------------------
Martin Downing,
Clinical Research Physicist,
Grampian Orthopaedic RSA Research Centre,
Woodend Hospital, Aberdeen, AB15 6LS.
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
