[nflug] Re: nflug Digest, Vol 21, Issue 31

Wed Jun 27 08:48:31 EDT 2007

MySQL Question.

  I am working on an ERP implementation and I had something similar happen this/last week.  I was able to modify one sql database from access but not the other.  I turns out that there were "Triggers" in place that kept me from modifying the data directly.  This is a data integrity issue so you need to be careful on what you modify. In my case I was pre-filling default fields to remove "null" values (putting zeroes in numeric fields for example).

  For a single table:
  Select the database you wish to work on.
  Using transaction SQL I was instructed to enter the following command:
  alter table part disable trigger all 
  Then execute the command.
  Then I was able to modify the parts table.
  When I was done I was told to reenable the triggers this way:
  alter table part enable triggers all
  again executing the command.

  Worked for me - perhaps this will point you in the right direction.

  Joe Lukasiewicz

nflug-request at nflug.org wrote:
  Send nflug mailing list submissions to
nflug at nflug.org

To subscribe or unsubscribe via the World Wide Web, visit
http://www.nflug.org/mailman/listinfo/nflug
or, via email, send a message with subject or body 'help' to
nflug-request at nflug.org

You can reach the person managing the list at
nflug-owner at nflug.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of nflug digest..."

Today's Topics:

1. roaming linux (eric)
2. Re: MyODBC (Tyler Poland)
3. Ubuntu Mozilla help (Robert Stockdale IV)
4. Re: Ubuntu Mozilla help (Jesse Jarzynka)

----------------------------------------------------------------------

Message: 1
Date: Mon, 25 Jun 2007 13:38:02 -0400
From: eric 
Subject: [nflug] roaming linux
To: nflug at nflug.org
Message-ID: <467FFD7A.6070605 at bootz.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Can I use "roaming linux users" to connect to a Samba Domain, I 
apologies, but I do not know what else to call it but "roaming users" 
like roaming users in Microsoft... would I just change the login to 
authenticate with my LDAP server which would then plugin to the Samba 
Domain?

Thanks,
Eric

------------------------------

Message: 2
Date: Mon, 25 Jun 2007 17:55:08 -0400
From: "Tyler Poland" 
Subject: Re: [nflug] MyODBC
To: nflug at nflug.org
Message-ID:
<4cec6b150706251455u302fa025na78bf4d57a01339a at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Rob,

I've never done that but this might help:
http://www.washington.edu/computing/web/publishing/mysql-access-3.5.html

Could it be the part about selecting the unique IDs?

Tyler

On 6/25/07, Robert Wolfe wrote:
>
> Hi all!
>
> I know this is probably not the best place to ask this but thought I would
> try anyway.
>
> I installed MyODBC on my MS Access install at home. I can access my MySQL
> databases just fine, however, I am not able to add any additional records
> to
> the database using Access 2003. I have all permissions on the database
> set
> correctly (everything checked).
>
> Any assistance in this would be VERY MUCH GREATLY appreciated.
>
> Thanks!
> Rob
>
> _______________________________________________
> nflug mailing list
> nflug at nflug.org
> http://www.nflug.org/mailman/listinfo/nflug
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.nflug.org/pipermail/nflug/attachments/20070625/4a5abc8d/attachment-0001.html

------------------------------

Message: 3
Date: Tue, 26 Jun 2007 08:29:51 -0400
From: "Robert Stockdale IV" 
Subject: [nflug] Ubuntu Mozilla help
To: nflug at nflug.org
Message-ID:
<2b8cfde80706260529r7b496b07ha7cc8c0d5ded1d4e at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi All: I seem to have a problem with Mozilla web browsers on Ubuntu. I've
tried Mozilla, Firefox and Iceweasel. They all have the same problem. I
change the behavior when the browser encounters a certain file type and
something changes it back. For instance: I change the action to use Evince
to open all pdf files. I must do this every time prior to clicking on the
file as something changes it back to Adobe acroread. Acroread never worked
correctly and has been removed. All other action changes get replaced as
well ( ie: shockwave, Quicktime, WinBlows Media, etc). It is as if a program
constantly copies a default config file if it detects a change. Any help
will be much appreciated. Thank you.
Bob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.nflug.org/pipermail/nflug/attachments/20070626/ba0f62e1/attachment-0001.html

------------------------------

Message: 4
Date: Tue, 26 Jun 2007 10:18:32 -0400
From: Jesse Jarzynka 
Subject: Re: [nflug] Ubuntu Mozilla help
To: nflug at nflug.org
Message-ID: <46812038.7090900 at thecybersource.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Robert Stockdale IV wrote:
> Hi All: I seem to have a problem with Mozilla web browsers on Ubuntu. 
> I've tried Mozilla, Firefox and Iceweasel. They all have the same 
> problem. I change the behavior when the browser encounters a certain 
> file type and something changes it back. For instance: I change the 
> action to use Evince to open all pdf files. I must do this every time 
> prior to clicking on the file as something changes it back to Adobe 
> acroread. Acroread never worked correctly and has been removed. All 
> other action changes get replaced as well ( ie: shockwave, Quicktime, 
> WinBlows Media, etc). It is as if a program constantly copies a 
> default config file if it detects a change. Any help will be much 
> appreciated. Thank you.
> Bob
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> nflug mailing list
> nflug at nflug.org
> http://www.nflug.org/mailman/listinfo/nflug
> 
Try the MimeEdit extension - 
https://addons.mozilla.org/en-US/firefox/addon/4498

------------------------------

_______________________________________________
nflug mailing list
nflug at nflug.org
http://www.nflug.org/mailman/listinfo/nflug

End of nflug Digest, Vol 21, Issue 31
*************************************

---------------------------------
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.nflug.org/pipermail/nflug/attachments/20070627/30c2c8fe/attachment-0001.html