Re: odbc question

Read-only should not have anything to do with joins.  Can
you tell me what
application you are using to run the queries?  Can you give
me the exact
steps I would need to reproduce it?

Thanks,

Jeff Ash
Software Engineer
BASIS International Ltd.
www.basis.com
+1.505.345.5232 Phone
+1.505.938.6172 Direct


                           Continue the journey...
                 BBxcellerate to the next generation!

           TechCon2007 ~ November 4-6 ~ Albuquerque
             Register before August 26th and save $200!
-----Original Message-----
From: owner-bbj-developerbasis.com
[mailto:owner-bbj-developerbasis.com]
On Behalf Of Randal Wilson
Sent: Wednesday, June 20, 2007 1:17 PM
To: bbj-developerbasis.com
Subject: Re: [bbj-developer] odbc question

Janet,

Yes, the read-only box is checked.
I want the database to be read-only.  Why can't I do joins
with a read-only 
database?
Like I said, this worked fine at another site with an
earlier rev of bbj.
Query box is checked.
Default policy for dictionary is allow all.
Read-only is true.
User has all permissions checked.
When I turn Read-only to false, the problem disappears.
But I need my database to be read-only!
Why does read-only disallow the joining of fields?  I don't
want to write 
back...


""BASIS Technical Support""
<supportbasis.com> wrote in message 
news:EqhZDB.A.n6H.rKudGBoliver-a...
> Hello Randy,
>
> Have you looked at configuration of the data source in
Enterprise Manager 
> to see if the read only box was checked?  Also check if
the user that 
> connecting to the data source has read write access to
the data source in 
> Enterprise Manager.   Check what the default policy for
the data base and 
> then the specific user.  If the default policy is read
only, then you 
> would have to read write access for the specific user. 
Or change the 
> default. And look at your license file, confirm that
the vendor string 
> does not have a R ( read only) in the middle position. 
Are you using a 
> Pro5 data server for the path to DATA and DICTIONARY? 
If so, confirm that

> the user that is being passed via the ODBC connection
has the correct 
> permissions at the OS level.  And last,  in MsQuery
itself, there is a 
> configuration option to "Allow Editing" ,
confirm that you have this 
> checked.
>
> Sincerely,
>
> Janet Smith
> Technical Support
> BASIS International Ltd.
> www.basis.com
> +1.505.345.5232
>
> Continue the journey,
>         BBxcellerate to the next generation!
>
>       TechCon2007 ~ November 4-6 ~ Albuquerque
>
>      Register before August 26th and save $200!
>          www.basis.com/events/techcon2007
>
>
>
>
>
>
> ""Randal Wilson"" <rrwrcgweb.com> wrote in message 
> news:0eW1k.A.wLG.l7pdGBoliver-a...
>> Trying to link two key fields from within Microsoft
query.
>> Get the message: "Attempted updateable SELECT
on a read-only Connection".
>> This works fine at another site with the same data
dictionary.
>> Any ideas?
>>
>> Thanks in advance,
>> Randy Wilson
>> Response Computer Group
>>
>>
>> # Need help using (or leaving) this mailing list?
>> # Email majordomobasis.com with the command
INFO BBJ-DEVELOPER in the 
>> message body.
>>
>
>
>
> # Need help using (or leaving) this mailing list?
> # Email majordomobasis.com with the command INFO
BBJ-DEVELOPER in the 
> message body.
> 



# Need help using (or leaving) this mailing list?
# Email majordomobasis.com with the command INFO
BBJ-DEVELOPER in the
message body.


# Need help using (or leaving) this mailing list?
# Email majordomobasis.com with the command INFO
BBJ-DEVELOPER in the message body.