Hi,
Wondering if someone could shed a little more light on using SQL withing a set fields function to access data in an external Access DB.

The help files are kinda confusing to how to go about this, and my understanding a little scarse.
It says to use <DatabaseName.owner.table> within the SQL command syntax.
Can someone explain what owner is meant to be, or how I go about finding it.

I am guessing I use it in a context of:

SELECT * FROM <DatabaseName.owner.table> WHERE <COL_NAME> = '$First Name$'


Regards
Carl

Hi,

The owner is the database user whch owns the object. Ask your DBA to know who is this database user.

Hi Vincent,
could you please give me an example of

<DatabaseName.owner.table>

I would like to access a local db on the C: drive called HiTV.mdb (MS Access).

Regards
Carl

Ms Access is not a supported database by AR System.

You need to develop using AR System API and MS Access API an ARDBC plugin to access to this database from your AR System server. Look at C API Reference Guide and Integration Guide for more information. There are some ARDBC code examples.

If the MS Access database is located on your client, try to use OLE Automation actions in active links to connect your AR System client to your MS Access database. I don't know if this solution can work.

The only "sure and approved" solution is to develop an ARDBC plugin.

Ok,
thank you kindly

Cheers
Carl

Ok,
still want to play with the SQL command.
I have a Informix and SQL database available via ODBC. How would I access them via the SQL command?
Is there a relationship I have to setup with Remedy, or have them listed somewhere so Remedy knows where they are?

Regards
Carl

If your AR System server is running on Informix, you can make a database link between these two Informix databases to access to the other Informix database thru AR System.

Otherwise, it's not possible to access to other database thru ODBC. You need to developp an ARDBC plugin to do this.

My ARSystem is on SQL 2000. I would like to access an external database that is not the Remedy backend.
I have available an informix, sql and other databases that we use in the company / different servers etc.

Was hoping to link into these to pull information into Remedy for "live" information.

I was under the understanding that the sql command in a set fields would allow me to do this, but was wondering where the relationship was formed in Remedy to these other databases
eg how does Remedy know where they are.

Help files seem to suggest that this is possible using the sql command.

<DatabaseName.owner.table>

i.e. I would like to put a button on a form, run an active link that pulls the up to date information from the external db and displays this to the user.

Regards
Carl

You can create a link between Ms SQL Server databases and AR System database (Ms SQL Server). So you can with the following SQL syntax databaseName.owner.table make some queries and/or view forms to the other linked databases.

If it isn't a Ms SQL Server database, you must developp an ARDBC plugin to access via Vendor forms to the other databases.