on 13/11/01 4:26 PM, Kevin Miller at [EMAIL PROTECTED] wrote:
>> - is there supposed to be a way to use a DSN? If so, how?
>
> Try to connect using the syntax:
>
> get revdb_connect("ODBC",<DSN>,"",[user],[password])
Making progress! This worked.
> Where user and password are optional.
Not very. As far as I can see, you need to specify the username and
password in the call to revdb_connect, even though they may have been
specified in the DSN. In fact, using the Merant system, the DSN includes a
username; and on every connection, a dialog box comes up repeating this
username, and requesting a password. But using revdb_connect, and
specifying the DSN, the username and password passed to revdb_connect
override the username specified in the DSN, and the password entered in the
dialog box. Omitting the username and password from the call to
revdb_connect is a error; leaving them empty still causes them to override
the ones specified in the DSN and dialog, hence causing the connection to
fail. Is there any way to avoid this?
>> - if we ignore DSNs, how do you specify port? I've tried every "<ip
>> address>:<port number>" and "<ip address>,<port number>" (which is what the
>> Merant tool seems to need for DSNs); and also tried using the name, rather
>> than the ip address, of the host computer (with both variants for setting
>> port). I've no reason to think this is the root of my problem, but it would
>> be nice to know so that I can have fewer variables to test.
>
> Set all of this information in the Merant Control Panel. You might also
> want to check if it connects with MacSQL - if so, it should work with
> Revolution.
Do you mean that it only works through a DSN? Generally, the idea is that
one uses a DSN to avoid entering specifying host etc info directly.
Entering this info in the Merant Control Panel means using a DSN. But the
documentation ignores DSN (hence the question which you've answered, thanks
very much) and explains how to specify everything explicitly to
revdb_connect - except how to specify the port. So... how?
Or, is it the case that ODBC at least, on MacOS at least, _always_ requires
a DSN?
TIA,
Ben Rubinstein | Email: [EMAIL PROTECTED]
Cognitive Applications Ltd | Phone: +44 (0)1273-821600
http://www.cogapp.com | Fax : +44 (0)1273-728866
